public int UpdateLoTrinhShipper(String type, String data)
{
try
{
dynamic dataDynamic = Newtonsoft.Json.JsonConvert.DeserializeObject(data);
dynamic listIdLoTrinh = dataDynamic.listIdLoTrinh;
dynamic listStatus = dataDynamic.listStatus;
int check = -1;
if (listIdLoTrinh.Count > 0)
{
for (int i = 0; i < listIdLoTrinh.Count; i++)
{
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
String ID = (String)listIdLoTrinh[i];
obj.ID = Convert.ToInt32(ID);
String TrangThai = (String)listStatus[i];
obj.TrangThai = TrangThai;
check = Servies.ShipperServices.UpdateLoTrinhShipper(obj);
}
return(check);
}
else
{
return(-1);
}
}
catch (Exception e)
{
e.ToString();
return(-1);
}
}
public String DeleteTrinhShipper(String type, String data, String IdLotrinh)
{
try
{
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
obj.ID = Convert.ToInt32(IdLotrinh);
Servies.ShipperServices.DeleteTrinhShipper(obj);
return("1");
}
catch (Exception e)
{
e.ToString();
return("0");
}
}
public static int InsertLoTrinhShipperReturnId(DataObject.LoTrinhShipper obj)
{
String Insert = "INSERT INTO LoTrinhShipper (MaLoTrinh,NgayTao,NguoiTao,TrangThai) VALUES (@MaLoTrinh,@NgayTao,@NguoiTao,@TrangThai);Select @@IDENTITY as newId";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@MaLoTrinh", obj.MaLoTrinh);
cmd.Parameters.AddWithValue("@NgayTao", obj.NgayTao);
cmd.Parameters.AddWithValue("@NguoiTao", obj.NguoiTao);
cmd.Parameters.AddWithValue("@TrangThai", obj.TrangThai);
conn.Open();
object insertedID = cmd.ExecuteScalar();
cmd.Connection.Close();
conn.Close();
return(Convert.ToInt32(insertedID));
}
public String InsertLoTrinhShipperReturnId(String type, String data)
{
try
{
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
String MaLoTrinh = DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh") + DateTime.Now.ToString("mm") + DateTime.Now.ToString("ss");
obj.MaLoTrinh = MaLoTrinh;
obj.NguoiTao = "";
obj.NgayTao = DateTime.Now;
obj.TrangThai = "Chưa xử lý";
int idLotrinh = Servies.ShipperServices.InsertLoTrinhShipperReturnId(obj);
return(idLotrinh + "," + MaLoTrinh);
}
catch (Exception e)
{
e.ToString();
return("0");
}
}
public static void DeleteTrinhShipper(DataObject.LoTrinhShipper obj)
{
String Insert = "Delete LoTrinhShipper where ID = @ID";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
conn.Close();
String updateStatusNHD = "Update NgayHoaDon set IdLotrinhShipper = -1 where IdLotrinhShipper = " + obj.ID;
SqlCommand cmd1 = new SqlCommand(updateStatusNHD);
cmd1.CommandType = CommandType.Text;
cmd1.Connection = conn;
conn.Open();
cmd1.ExecuteNonQuery();
cmd1.Connection.Close();
conn.Close();
}
public static int UpdateLoTrinhShipper(DataObject.LoTrinhShipper obj)
{
// 1 : Lưu thành công
// 2 : Lưu thông tin không thành công trạng thái đang xử lý
// 3 : Lưu thông tin không thành công trạng thái hoàn thành
// 4 : Lưu thông tin không thành công trạng thái Đang xử lý về Chưa xử lý
SqlConnection conn = Common.Connection.SqlConnect();
String getTrangThaiLoTrinh = "Select TrangThai FROM LoTrinhShipper where ID = @ID";
SqlCommand cmdGetTrangThai = new SqlCommand(getTrangThaiLoTrinh);
cmdGetTrangThai.CommandType = CommandType.Text;
cmdGetTrangThai.Connection = conn;
cmdGetTrangThai.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
object trangthaiLT = cmdGetTrangThai.ExecuteScalar();
conn.Close();
String statusLT = (String)trangthaiLT;
String strCheck = "SELECT dbo.fCheckStatusLoTrinh(" + obj.ID + ",'" + obj.TrangThai + "') AS MyResult";
SqlCommand cmdCheck = new SqlCommand(strCheck);
cmdCheck.CommandType = CommandType.Text;
cmdCheck.Connection = conn;
conn.Open();
object checkTT = cmdCheck.ExecuteScalar();
conn.Close();
int result = Convert.ToInt16(checkTT);
if (statusLT == "Chưa xử lý" && obj.TrangThai == "Đang xử lý")
{
//SELECT dbo.fCheckStatusLoTrinh(1,'Chưa xử lý') AS MyResult
String Insert = "Update LoTrinhShipper set TrangThai= @TrangThai where ID = @ID";
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@TrangThai", obj.TrangThai);
cmd.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
conn.Close();
String strUpdateNHD = "Update NgayHoaDon set TrangThai= @TrangThai where IdlotrinhShipper = @ID";
SqlCommand cmdUpdateNHD = new SqlCommand(strUpdateNHD);
cmdUpdateNHD.CommandType = CommandType.Text;
cmdUpdateNHD.Connection = conn;
cmdUpdateNHD.Parameters.AddWithValue("@TrangThai", obj.TrangThai);
cmdUpdateNHD.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmdUpdateNHD.ExecuteNonQuery();
cmdUpdateNHD.Connection.Close();
conn.Close();
}
else if (statusLT == "Đang xử lý" && obj.TrangThai == "Hoàn thành")
{
if (result != 0)
{
String Insert = "Update LoTrinhShipper set TrangThai= @TrangThai where ID = @ID";
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@TrangThai", obj.TrangThai);
cmd.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
conn.Close();
return(1);
}
else
{
return(3);
}
}
else if (statusLT == "Đang xử lý" && obj.TrangThai == "Chưa xử lý")
{
return(4);
}
else if (statusLT == "Hoàn thành" && obj.TrangThai != "Hoàn thành")
{
return(5);
}
else if (statusLT == "Chưa xử lý" && obj.TrangThai == "Chưa xử lý")
{
return(1);
}
return(1);
}
public void ProcessRequest(HttpContext context)
{
try
{
String type = context.Request.Form["type"].ToString();
if (type == "InsertLoTrinhShipperReturnId")
{
String jsonData = context.Request.Form["data"].ToString();
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
String MaLoTrinh = DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh") + DateTime.Now.ToString("mm") + DateTime.Now.ToString("ss");
obj.MaLoTrinh = MaLoTrinh;
obj.NguoiTao = "";
obj.NgayTao = DateTime.Now;
obj.TrangThai = "Chưa xử lý";
int idLotrinh = Servies.ShipperServices.InsertLoTrinhShipperReturnId(obj);
context.Response.ContentType = "text/plain";
context.Response.Write(idLotrinh + "," + MaLoTrinh);
}
else if (type == "UpdateLoTrinhShipper")
{
String jsonData = context.Request.Form["data"].ToString();
dynamic data = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonData);
dynamic listIdLoTrinh = data.listIdLoTrinh;
dynamic listStatus = data.listStatus;
int check = -1;
if (listIdLoTrinh.Count > 0)
{
for (int i = 0; i < listIdLoTrinh.Count; i++)
{
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
String ID = (String)listIdLoTrinh[i];
obj.ID = Convert.ToInt32(ID);
String TrangThai = (String)listStatus[i];
obj.TrangThai = TrangThai;
check = Servies.ShipperServices.UpdateLoTrinhShipper(obj);
}
context.Response.ContentType = "text/plain";
context.Response.Write(check);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write(-1);
}
}
else if (type == "DeleteTrinhShipper")
{
String IdLotrinh = context.Request.Form["IdLotrinh"].ToString();
DataObject.LoTrinhShipper obj = new DataObject.LoTrinhShipper();
obj.ID = Convert.ToInt32(IdLotrinh);
Servies.ShipperServices.DeleteTrinhShipper(obj);
context.Response.ContentType = "text/plain";
context.Response.Write("1");
}
else if (type == "ViewLoTrinhShipper")
{
String jsonData = context.Request.Form["data"].ToString();
String NgayLotrinh = context.Request.Form["NgayLotrinh"].ToString();
String MaLoTrinh = context.Request.Form["MaLoTrinh"].ToString();
String ShipName = context.Request.Form["ShipName"].ToString();
String ShipNumber = context.Request.Form["ShipNumber"].ToString();
String TrangThai = context.Request.Form["TrangThai"].ToString();
DataTable lst = Servies.ShipperServices.ViewLoTrinhShipper(NgayLotrinh, MaLoTrinh, ShipName, ShipNumber, TrangThai);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(lst));
}
else if (type == "InLoTrinh")
{
}
else if (type == "InsertShipperReturnId")
{
String jsonData = context.Request.Form["data"].ToString();
String DiaChi = context.Request.Form["DiaChi"].ToString();
String SoDienThoai = context.Request.Form["SoDienThoai"].ToString();
String NAME = context.Request.Form["NAME"].ToString();
String DESCRIPTION = context.Request.Form["DESCRIPTION"].ToString();
DataObject.Shiper s = new DataObject.Shiper();
s.NAME = NAME;
s.DiaChi = DiaChi;
s.SoDienThoai = SoDienThoai;
s.NguoiTao = "";
s.NgayTao = DateTime.Now;
s.DESCRIPTION = DESCRIPTION;
int idShipper = Servies.ShipperServices.InsertShipperReturnId(s);
context.Response.ContentType = "text/plain";
context.Response.Write(idShipper);
}
else if (type == "UpdateShipperReturnId")
{
String jsonData = context.Request.Form["data"].ToString();
String DiaChi = context.Request.Form["DiaChi"].ToString();
String SoDienThoai = context.Request.Form["SoDienThoai"].ToString();
String NAME = context.Request.Form["NAME"].ToString();
String Shipe_ID = context.Request.Form["Shipe_ID"].ToString();
String DESCRIPTION = context.Request.Form["DESCRIPTION"].ToString();
DataObject.Shiper s = new DataObject.Shiper();
s.NAME = NAME;
s.DiaChi = DiaChi;
s.SoDienThoai = SoDienThoai;
s.DESCRIPTION = DESCRIPTION;
s.SHIPER_ID = Convert.ToInt16(Shipe_ID);
Servies.ShipperServices.UpdateShipperReturnId(s);
context.Response.ContentType = "text/plain";
context.Response.Write("1");
}
else if (type == "getDataShipper")
{
DataTable table = new DataTable();
String NAME = context.Request.Form["NAME"].ToString();
String Shipe_ID = context.Request.Form["Shipe_ID"].ToString();
DataObject.Shiper s = new DataObject.Shiper();
s.NAME = NAME;
s.SHIPER_ID = Convert.ToInt16(Shipe_ID);
table = Servies.ShipperServices.getDataShipper(s);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(table));
}
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("0");
}
}
