public static DataTable getDataShipper(DataObject.Shiper obj) { DataTable table = new DataTable(); String Select = "Select * from SHIPER Where "; if (obj.SHIPER_ID != null && obj.SHIPER_ID > 0) { Select += "SHIPER_ID =" + obj.SHIPER_ID + " AND "; } if (obj.NAME != null && obj.NAME != "") { Select += "NAME LIKE N'%" + obj.NAME + "%' AND "; } Select += "1=1 ORDER BY SHIPER_ID DESC"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; conn.Open(); table.Load(cmd.ExecuteReader()); conn.Close(); return(table); }
public static void UpdateShipperReturnId(DataObject.Shiper obj) { String Insert = "Update SHIPER SET NAME = @NAME,DiaChi = @DiaChi,SoDienThoai = @SoDienThoai,DESCRIPTION = @DESCRIPTION where SHIPER_ID = @ID"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@NAME", obj.NAME); cmd.Parameters.AddWithValue("@DiaChi", obj.DiaChi); cmd.Parameters.AddWithValue("@SoDienThoai", obj.SoDienThoai); cmd.Parameters.AddWithValue("@DESCRIPTION", obj.DESCRIPTION); cmd.Parameters.AddWithValue("@ID", obj.SHIPER_ID); conn.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); conn.Close(); }
public String UpdateShipperReturnId(String type, String data, String DiaChi, String SoDienThoai, String NAME, String Shipe_ID, String DESCRIPTION) { try { 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); return("1"); } catch (Exception e) { e.ToString(); return("0"); } }
public Int32 InsertShipperReturnId(String type, String data, String DiaChi, String SoDienThoai, String NAME, String DESCRIPTION) { try { 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); return(idShipper); } catch (Exception e) { e.ToString(); return(0); } }
public static int InsertShipperReturnId(DataObject.Shiper obj) { String Insert = "INSERT INTO SHIPER (NAME,DiaChi,SoDienThoai,DESCRIPTION,NguoiTao,NgayTao) VALUES (@NAME,@DiaChi,@SoDienThoai,@DESCRIPTION,@NguoiTao,@NgayTao);Select @@IDENTITY as newId"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@NAME", obj.NAME); cmd.Parameters.AddWithValue("@DiaChi", obj.DiaChi); cmd.Parameters.AddWithValue("@SoDienThoai", obj.SoDienThoai); cmd.Parameters.AddWithValue("@DESCRIPTION", obj.DESCRIPTION); cmd.Parameters.AddWithValue("@NguoiTao", obj.NguoiTao); cmd.Parameters.AddWithValue("@NgayTao", obj.NgayTao); conn.Open(); object insertedID = cmd.ExecuteScalar(); cmd.Connection.Close(); conn.Close(); return(Convert.ToInt32(insertedID)); }
public ContentResult getDataShipper(String type, String data, String NAME, String Shipe_ID) { try { DataTable table = new DataTable(); DataObject.Shiper s = new DataObject.Shiper(); s.NAME = NAME; s.SHIPER_ID = Convert.ToInt16(Shipe_ID); table = Servies.ShipperServices.getDataShipper(s); var list = JsonConvert.SerializeObject(table, Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore }); return(Content(list, "application/json")); } catch (Exception e) { e.ToString(); return(null); } }
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"); } }