public void UpdateRecord(Objects.PurReturns obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_PurReturnsUpdate"; cmd.Parameters.AddWithValue("@PurReturnId", obj.PurReturnId); cmd.Parameters.AddWithValue("@PurchaseId", obj.PurchaseId); cmd.Parameters.AddWithValue("@VendorId", obj.VendorId); cmd.Parameters.AddWithValue("@ReturnDate", obj.ReturnDate); cmd.Parameters.AddWithValue("@Disc2Ratio", obj.Disc2Ratio); cmd.Parameters.AddWithValue("@FTaxRatio", obj.FTaxRatio); cmd.Parameters.AddWithValue("@SpecialDiscount", obj.SpecialDiscount); cmd.Parameters.AddWithValue("@InvOfferDiscount", obj.InvOfferDiscount); cmd.Parameters.AddWithValue("@InvOfferSTax", obj.InvOfferSTax); cmd.Parameters.AddWithValue("@InvOfferFTax", obj.InvOfferFTax); cmd.Parameters.AddWithValue("@ReceivedAmount", obj.ReceivedAmount); cmd.Parameters.AddWithValue("@PreviousCredit", obj.PreviousCredit); cmd.Parameters.AddWithValue("@Narration", obj.Narration); cmd.Parameters.AddWithValue("@IsPosted", obj.IsPosted); cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
public void InsertRecord(Objects.PurReturns obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_PurReturnsInsert"; /**/ cmd.Parameters.AddWithValue("@PurReturnId", obj.PurReturnId); cmd.Parameters.AddWithValue("@PurchaseId", obj.PurchaseId); cmd.Parameters.AddWithValue("@VendorId", obj.VendorId); cmd.Parameters.AddWithValue("@ReturnDate", obj.ReturnDate); cmd.Parameters.AddWithValue("@Disc2Ratio", obj.Disc2Ratio); cmd.Parameters.AddWithValue("@FTaxRatio", obj.FTaxRatio); cmd.Parameters.AddWithValue("@SpecialDiscount", obj.SpecialDiscount); cmd.Parameters.AddWithValue("@InvOfferDiscount", obj.InvOfferDiscount); cmd.Parameters.AddWithValue("@InvOfferSTax", obj.InvOfferSTax); cmd.Parameters.AddWithValue("@InvOfferFTax", obj.InvOfferFTax); cmd.Parameters.AddWithValue("@ReceivedAmount", obj.ReceivedAmount); cmd.Parameters.AddWithValue("@PreviousCredit", obj.PreviousCredit); cmd.Parameters.AddWithValue("@Narration", obj.Narration); cmd.Parameters.AddWithValue("@IsPosted", obj.IsPosted); cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } } public void InsertRecordBody(Objects.PurReturnsBody obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_PurReturnsBodyInsert"; /**/ cmd.Parameters.AddWithValue("@PurReturnId", obj.PurReturnId); cmd.Parameters.AddWithValue("@ProductId", obj.ProductId); cmd.Parameters.AddWithValue("@PackingId", obj.PackingId); cmd.Parameters.AddWithValue("@Multiplier", obj.Multiplier); cmd.Parameters.AddWithValue("@QtyPack", obj.QtyPack); cmd.Parameters.AddWithValue("@QtyLose", obj.QtyLose); cmd.Parameters.AddWithValue("@BnsLose", obj.BnsLose); cmd.Parameters.AddWithValue("@PricePack", obj.PricePack); cmd.Parameters.AddWithValue("@DiscRatio", obj.DiscRatio); cmd.Parameters.AddWithValue("@DiscValPack", obj.DiscValPack); cmd.Parameters.AddWithValue("@DiscValLose", obj.DiscValLose); cmd.Parameters.AddWithValue("@OfferDiscount", obj.OfferDiscount); cmd.Parameters.AddWithValue("@STaxRatio", obj.STaxRatio); cmd.Parameters.AddWithValue("@STaxValPack", obj.STaxValPack); cmd.Parameters.AddWithValue("@IsValueB4Ratio", obj.IsValueB4Ratio); cmd.Parameters.AddWithValue("@IsSTaxOnBns", obj.IsSTaxOnBns); cmd.Parameters.AddWithValue("@IsFTaxExempted", obj.IsFTaxExempted); cmd.Parameters.AddWithValue("@TTLValue", obj.TTLValue); cmd.Parameters.AddWithValue("@TTLSTax", obj.TTLSTax); cmd.Parameters.AddWithValue("@TTLFTax", obj.TTLFTax); cmd.Parameters.AddWithValue("@ExtraSTaxBns", obj.ExtraSTaxBns); cmd.Parameters.AddWithValue("@ExtraFTaxBns", obj.ExtraFTaxBns); cmd.Parameters.AddWithValue("@PerUnitCostLose", obj.PerUnitCostLose); cmd.Parameters.AddWithValue("@IsFreeProduct", obj.IsFreeProduct); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }