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;
}
}
