public ExecuteModels DelTempWorksheet(TempWorksheetModels val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabase())
{
string _SQL = "delete from transport_temp where tran_id = " + val.tran_id;
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
try
{
if (Int32.Parse(cmd.ExecuteNonQuery().ToString()) == 1)
{
ecm.result = 0;
ecm.code = "OK";
}
else
{
ecm.result = 1;
ecm.code = _SQL;
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
}
con.Close();
}
return(ecm);
}
public ExecuteModels InsertTempWorksheet(TempWorksheetModels val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabase())
{
string _SQL = "INSERT INTO transport_temp (tran_code,number_po ,cus_id ,branch_id ,contact_id ,product_id ,trunk_id " +
",driver_id_1 ,driver_id_2 ,driver_id_3 ,license_id_head ,license_id_tail ,remark ,tran_status_id ,create_by_user_id ,sheet_name ,cont1,cont2 ) " +
" output inserted.tran_id VALUES (N'" + val.tran_code + "', N'" + val.number_po + "', '" + val.cus_id + "', '" + val.branch_id + "', '" + val.contact_id + "', '" + val.product_id + "'" +
", '" + val.trunk_id + "' ,'" + val.driver_id_1 + "' , '" + val.driver_id_2 + "', '" + val.driver_id_3 + "', '" + val.license_id_head + "' , '" + val.license_id_tail + "'" +
", N'" + val.remark + "' , '" + val.tran_status_id + "' , 1 , '" + val.sheet_name + "' , '" + val.cont1 + "', '" + val.cont2 + "')";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
try
{
var id_return = Int32.Parse(cmd.ExecuteScalar().ToString());
if (id_return >= 1)
{
ecm.result = 0;
ecm.code = "OK";
ecm.id_return = id_return.ToString();
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
}
con.Close();
}
return(ecm);
}
public ExecuteModels UpdateTempWorksheet(TempWorksheetModels val)
{
ExecuteModels ecm = new ExecuteModels();
string _SQL_Set = string.Empty;
string[] Col_Arr = { "tran_code", "number_po", "cus_id", "branch_id", "contact_id", "product_id", "trunk_id", "driver_id_1", "driver_id_2", "driver_id_3", "license_id_head", "license_id_tail", "remark", "tran_status_id", "sheet_name", "cont1", "cont2" };
string[] Val_Arr = { val.tran_code, val.number_po, val.cus_id, val.branch_id, val.contact_id, val.product_id, val.trunk_id, val.driver_id_1, val.driver_id_2, val.driver_id_3, val.license_id_head, val.license_id_tail, val.remark, val.tran_status_id, val.sheet_name, val.cont1, val.cont2 };
for (int n = 0; n <= Val_Arr.Length - 1; n++)
{
if (Val_Arr[n] != null)
{
_SQL_Set += Col_Arr[n] + " = N'" + Val_Arr[n] + "', ";
}
}
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabase())
{
string _SQL = "UPDATE transport_temp set " + _SQL_Set + " update_by_user_id = 1 where tran_id = " + val.tran_id;
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
try
{
if (Int32.Parse(cmd.ExecuteNonQuery().ToString()) == 1)
{
ecm.result = 0;
ecm.code = "OK";
}
else
{
ecm.result = 1;
ecm.code = _SQL;
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
}
con.Close();
}
return(ecm);
}
