public int AddInvoiceDetails(List <OrderInvoiceEntity> entity) { int value = 0; try { // int i = 0; ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertInvoiceOrderUpdateListToDataTable(entity); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd = new SqlCommand("[spUpdateInvoiceDetails]", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter customrId = cmd.Parameters.AddWithValue("@tblInvoiceUpdate", table); value = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception ex) { } return(value); }
public int AcceptInvoicedetails(int Statusid) { ConvertEntitiesDL obj = new ConvertEntitiesDL(); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("Sp_UpdateInvoiceStatusDetails", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter customrId = cmd.Parameters.AddWithValue("@Statusid", Statusid); return((int)cmd.ExecuteScalar()); } } }
public int AddNewInvoice(List <OrderInvoiceEntity> entity) { ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertInvoiceOrderListToDataTable(entity); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spInsertInvoiceDetails", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter customrId = cmd.Parameters.AddWithValue("@tblInvoice", table); return((int)cmd.ExecuteScalar()); } } }
public int AddUploadInvoiceFile(List <OrderInvoiceEntity> entity) { ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertInvoiceUploadListToDataTable(entity); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spUpdateInvoiceOrderUpload", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter customrId = cmd.Parameters.AddWithValue("@INVOICEORDERNO", table.Rows[0][0].ToString()); SqlParameter Comment = cmd.Parameters.AddWithValue("@UPLOADFILENAME", table.Rows[0][1].ToString()); return((int)cmd.ExecuteScalar()); } } }
public int AddComment(List <OrderInvoiceEntity> entity) { ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertInvoicCommentListToDataTable(entity); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spUpdateInvoiceComment", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter customrId = cmd.Parameters.AddWithValue("@INVOICETRANSID", table.Rows[0][0].ToString()); SqlParameter Comment = cmd.Parameters.AddWithValue("@INVOICECOMMENT", table.Rows[0][1].ToString()); return((int)cmd.ExecuteScalar()); } } }
public int AddETA(List <OrderInvoiceEntity> entity) { ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertInvoiceETAListToDataTable(entity); using (SqlConnection myConnection = new SqlConnection(cs)) { using (SqlCommand cmd = new SqlCommand("spUpdateEtaInvoiceOrder", myConnection)) { cmd.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlParameter INVOrderNo = cmd.Parameters.AddWithValue("@INVOrderNo", table.Rows[0][0].ToString()); SqlParameter ETADate = cmd.Parameters.AddWithValue("@ETADATE", table.Rows[0][1].ToString()); return((int)cmd.ExecuteScalar()); } } }
public int AddNewPurchase(List <SerialNumberEnity> entity, int Category) { // int i = 0; ConvertEntitiesDL obj = new ConvertEntitiesDL(); DataTable table = obj.ConvertPurchaseOrderListToDataTable(entity); using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd = new SqlCommand("[spInsertPurchaseOrder]", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter customrId = cmd.Parameters.AddWithValue("@tblEmp", table); SqlParameter category = cmd.Parameters.AddWithValue("@Category", Category); return((int)cmd.ExecuteScalar()); } }