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