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