public string funcCheckProductPacking(BOPurchaseBill objBOPurchaseBill)
{
DataTable dt = new DataTable();
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
string cmdText = "SELECT packing FROM product_master WHERE product_id = ";
cmdText += objBOPurchaseBill.product_id;
SqlCommand cmd = new SqlCommand(cmdText, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(Convert.ToString(dt.Rows[0]["packing"]));
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00011" + Environment.NewLine + "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
return(null);
}
finally
{
objDB_Utility.funcCloseConnection();
}
}
public string funcSaveInvoiceDetails(BOPurchaseBill objBOPurchaseBill, DataTable dtSupplierInvoiceDetails)
{
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
SqlCommand cmd = new SqlCommand("sp_saveSupInvoiceDetails", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//Code to Insert Supplier Details Data into Database using stored procedure
cmd.Parameters.AddWithValue("@invoice_no", objBOPurchaseBill.invoice_number);
cmd.Parameters.AddWithValue("@supp_id", objBOPurchaseBill.supplier_id);
cmd.Parameters.AddWithValue("@total_mrp", objBOPurchaseBill.totalMRP);
cmd.Parameters.AddWithValue("@discount", objBOPurchaseBill.discount);
cmd.Parameters.AddWithValue("@amount_ad", objBOPurchaseBill.totalCost);
cmd.Parameters.AddWithValue("@amount_paid", objBOPurchaseBill.amount_paid);
cmd.Parameters.AddWithValue("@payment_method", objBOPurchaseBill.payment_method);
cmd.Parameters.AddWithValue("@invoice_date", objBOPurchaseBill.invoice_date);
SqlParameter tvparam = cmd.Parameters.AddWithValue("@dt_supplier_invoice", dtSupplierInvoiceDetails);
//tvparam.SqlDbType = SqlDbType.Structured;
cmd.ExecuteNonQuery();
return("success");
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00013" + Environment.NewLine + "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
return(ex.Message);
}
finally
{
objDB_Utility.funcCloseConnection();
}
}
public string funcSaveInvoiceDetails(BOPurchaseBill objBOPurchaseBill, DataTable dtSupInvoiveDetails)
{
return(objDALpurchaseBill.funcSaveInvoiceDetails(objBOPurchaseBill, dtSupInvoiveDetails));
}
public string funcCheckProductPacking(BOPurchaseBill objBOPurchaseBill)
{
string packing = objDALpurchaseBill.funcCheckProductPacking(objBOPurchaseBill);
return(packing);
}