public void UpdateRecord(Objects.PurOrder obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_PurOrder Update";
cmd.Parameters.AddWithValue("@PurOrderID", obj.PurOrderID);
cmd.Parameters.AddWithValue("@OrderDate", obj.OrderDate);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
cmd.Parameters.AddWithValue("@VendorID", obj.VendorID);
cmd.Parameters.AddWithValue("@BillNo", obj.BillNo);
cmd.Parameters.AddWithValue("@BillDate", obj.BillDate);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@PaidAmount", obj.PaidAmount);
cmd.Parameters.AddWithValue("@Narration", obj.Narration);
cmd.Parameters.AddWithValue("@SpecialDiscount", obj.SpecialDiscount);
cmd.Parameters.AddWithValue("@CustomerId", obj.CustomerId);
cmd.Parameters.AddWithValue("@GSTax", obj.GSTax);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void InsertRecord(Objects.PurOrder obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_PurOrder Insert";
/**/
cmd.Parameters.AddWithValue("@PurOrderID", obj.PurOrderID);
cmd.Parameters.AddWithValue("@OrderDate", obj.OrderDate);
cmd.Parameters.AddWithValue("@OfficeID", obj.OfficeID);
cmd.Parameters.AddWithValue("@VendorID", obj.VendorID);
cmd.Parameters.AddWithValue("@BillNo", obj.BillNo);
cmd.Parameters.AddWithValue("@BillDate", obj.BillDate);
cmd.Parameters.AddWithValue("@IsUploaded", obj.IsUploaded);
cmd.Parameters.AddWithValue("@PaidAmount", obj.PaidAmount);
cmd.Parameters.AddWithValue("@Narration", obj.Narration);
cmd.Parameters.AddWithValue("@SpecialDiscount", obj.SpecialDiscount);
cmd.Parameters.AddWithValue("@CustomerId", obj.CustomerId);
cmd.Parameters.AddWithValue("@GSTax", obj.GSTax);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
public void InsertRecordBody(Objects.PurOrderBody obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_PurOrderBodyInsert";
/**/
cmd.Parameters.AddWithValue("@PurOrderId", obj.PurOrderId);
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);
cmd.Parameters.AddWithValue("@IsDeleted", obj.IsDeleted);
cmd.Parameters.AddWithValue("@CustomerId", obj.CustomerId);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
