Skip to main content

Updates of Software on Haram Traders

Comments

Popular posts from this blog

Alter Table Column MsSql

Following is the important script for database server as the table "tbl_Log" as already created. For Adding Default Value in Table ALTER TABLE YourTable ADD CONSTRAINT DF_SomeName DEFAULT N'1' FOR YourColumn ; For Increasing the Column Size ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (50) NOT NULL; For Add/Creating New Column ALTER TABLE PRESENTED_VOUCHER add  descrip  nvarchar(200); For Change/Modify Existing Column  ALTER TABLE PRESENTED_VOUCHER alter column  descrip  nvarchar(200);

Spiral Model C#

I have created following: 01 - Db.Model ( i.e., "TicketProtection.cs + "ServiceCharges.cs" + "AtolProtection.cs") 02 - Configuration ( i.e., "TicketProtectionConfiguration.cs" + "ServiceChargesConfiguration.cs" + "AtolProtectionConfiguration.cs") 03 - Migration Added Migration(add-migration added_costing_charges_table)  04 - SQL Insert Script ( i.e., for ticket_protection_charges. in figure bellow)Please review if i miss anything...? 05 - Data for SQL Insert Script: creating file in seeding folder of project - with "embaded resource" 06 - Run the Project on Database to check data & tables are created. 07 - Repository: 08 - Manager ( Interface and Implementation) (Reference Data Manager) 09 - Controller (Reference Data Controller) "CustomApiResponse" 10 - Create Map in SelectItemProfile   11 - Create Front End "Costing Methods PassengerType wise"