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