c# aspt.net controller part region url for ajax load blank form create async partiaviewresult action method load respective add form in partial view region url for ajax submit/save Create async JSONResult action method grab/get posted data save them to table if success return json with status true and data with recently added id if fail …
stop work of that coop from all places Login to Master Panel Org List and Org Edit respective organisation Change DB name to old fiscal year db like “coop_md197” Open Org List page Find restore matchin copy of db in that org Open Org Edit panel of resepective Organisation Change DB name to New Fiscal …
In case of Old data of coop is not properly restore then Read More »
<table class=”table table-striped table-fixed-header table-hover ” id=”reportContent “> <thead id=”pageHeader” class=”header”> <tr> <th colspan=”2″ width=”100px”> </th> <th width=”100px”>Ledger Code</th> <th>Ledger Name</th> <th width=”100px”>Debit</th> <th width=”100px”>Credit</th> </tr> </thead>
Download Help File documentation for SQLSuperAdminModel
Application/Files/Database to backup SN Application Description Runtime User Uploads Database 1 Main MIS Web Application Yes Yes Yes 2 Desktop Application Yes No No 3 Payroll Application Yes Yes Yes 4 Inventory Application Yes No Yes 5 Main MIS Web Application [2073] Yes No Yes 6 Old Record Check Application Yes Yes Yes
use database_name; — ALTER DATABASE database_name SET READ_WRITE ——– Reset SQL user account guids ——————— DECLARE @UserName nvarchar(255) DECLARE orphanuser_cur cursor for SELECT UserName = su.name FROM sysusers su JOIN sys.server_principals sp ON sp.name = su.name WHERE issqluser = 1 AND (su.sid IS NOT NULL AND su.sid <> 0x0) AND suser_sname(su.sid) is null ORDER BY …
Fix User Server Principal authentication error after db restore Read More »
Using DB First Approach Database Part MSSQL Management Studio Create DB Tables, Views and Stored Procedure as requirement Visual Studio Application Part Create New Project Create Separate Projects for DAL Add Reference of DAL Project to main project Add Nuget package of Entity Framework to both projects [DAL and Main] Create EDMX Model from Database …
error log api log application error tracking
use dbname; DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR SET @Cursor = CURSOR FAST_FORWARD FOR SELECT DISTINCT sql = ‘ALTER TABLE [‘ + tc2.TABLE_NAME + ‘] DROP [‘ + rc1.CONSTRAINT_NAME + ‘]’ FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1 LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql WHILE (@@FETCH_STATUS = 0) BEGIN Exec …
Add Common Models to MFI_API_MODEL Project Build project and make error free Change Nuget Package Version in MFI_API_MODEL.nuspec file Generate Nuget Package from CMD using command: nuget pack mfi_api_model.nuspec -prop configuration=release Host Nuget Package to accessible server location in Ants or local computer Open Own UI project, Update Package version