public static int InsertKho003ReturnID(DataObject.Kho003 obj)
{
SqlConnection conn = Common.Connection.SqlConnect();
int check = 0;
String select = "Select count(*) FROM Kho003 where ID = " + obj.ID;
SqlCommand cmd = new SqlCommand(select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
conn.Open();
object count = cmd.ExecuteScalar();
conn.Close();
check = Convert.ToInt16(count);
if (check > 0)
{
String insert = "Update Kho003 SET NhaCungCap = @NhaCungCap,Ten = @Ten ,SoDT = @SoDT ,DiaChi = @DiaChi ,Ngay = @Ngay ,Kho = @Kho,GhiChu = @GhiChu where ID = @ID";
SqlCommand cmdInsert = new SqlCommand(insert);
cmdInsert.CommandType = CommandType.Text;
cmdInsert.Connection = conn;
cmdInsert.Parameters.AddWithValue("@NhaCungCap", obj.NhaCungCap);
cmdInsert.Parameters.AddWithValue("@Ten", obj.Ten);
cmdInsert.Parameters.AddWithValue("@SoDT", obj.SoDT);
cmdInsert.Parameters.AddWithValue("@DiaChi", obj.DiaChi);
cmdInsert.Parameters.AddWithValue("@Ngay", obj.Ngay);
cmdInsert.Parameters.AddWithValue("@Kho", obj.Kho);
cmdInsert.Parameters.AddWithValue("@GhiChu", obj.GhiChu);
cmdInsert.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmdInsert.ExecuteNonQuery();
conn.Close();
return(obj.ID);
}
else
{
String insert = "";
if (obj.Type == 0)
{
insert = "Insert into Kho003 (NhaCungCap,Ten,SoDT,DiaChi,Ngay,Kho,GhiChu,NgayTao,NguoiTao,MaPhieuNhap,Type) Values(@NhaCungCap,@Ten,@SoDT,@DiaChi,@Ngay,@Kho,@GhiChu,@NgayTao,@NguoiTao,@MaPhieuNhap,@Type);Select @@IDENTITY as newId";
}
else if (obj.Type == 1)
{
insert = "Insert into Kho003 (NhaCungCap,Ten,SoDT,DiaChi,Ngay,Kho,GhiChu,NgayTao,NguoiTao,MaPhieuXuat,Type) Values(@NhaCungCap,@Ten,@SoDT,@DiaChi,@Ngay,@Kho,@GhiChu,@NgayTao,@NguoiTao,@MaPhieuXuat,@Type);Select @@IDENTITY as newId";
}
else if (obj.Type == 2)
{
insert = "Insert into Kho003 (NhaCungCap,Ten,SoDT,DiaChi,Ngay,Kho,GhiChu,NgayTao,NguoiTao,MaPhieuNhap,Type) Values(@NhaCungCap,@Ten,@SoDT,@DiaChi,@Ngay,@Kho,@GhiChu,@NgayTao,@NguoiTao,@MaPhieuNhap,@Type);Select @@IDENTITY as newId";
}
SqlCommand cmdInsert = new SqlCommand(insert);
cmdInsert.CommandType = CommandType.Text;
cmdInsert.Connection = conn;
cmdInsert.Parameters.AddWithValue("@NhaCungCap", obj.NhaCungCap);
cmdInsert.Parameters.AddWithValue("@Ten", obj.Ten);
cmdInsert.Parameters.AddWithValue("@SoDT", obj.SoDT);
cmdInsert.Parameters.AddWithValue("@DiaChi", obj.DiaChi);
cmdInsert.Parameters.AddWithValue("@Ngay", obj.Ngay);
cmdInsert.Parameters.AddWithValue("@Kho", obj.Kho);
cmdInsert.Parameters.AddWithValue("@GhiChu", obj.GhiChu);
cmdInsert.Parameters.AddWithValue("@NgayTao", obj.NgayTao);
cmdInsert.Parameters.AddWithValue("@NguoiTao", obj.NguoiTao);
if (obj.Type == 0)
{
cmdInsert.Parameters.AddWithValue("@MaPhieuNhap", obj.MaPhieuNhap);
}
else if (obj.Type == 1)
{
cmdInsert.Parameters.AddWithValue("@MaPhieuXuat", obj.MaPhieuXuat);
}
else if (obj.Type == 2)
{
cmdInsert.Parameters.AddWithValue("@MaPhieuNhap", obj.MaPhieuNhap);
}
cmdInsert.Parameters.AddWithValue("@Type", obj.Type);
conn.Open();
object Id = cmdInsert.ExecuteScalar();
conn.Close();
return(Convert.ToInt16(Id));
}
}
public void ProcessRequest(HttpContext context)
{
String type = context.Request.Form["type"].ToString();
//String jsonData = context.Request.Form["data"].ToString();
if (type == "viewK001P1")
{
try
{
String Ngay = context.Request.Form["Ngay"].ToString();
String thu = context.Request.Form["thu"].ToString();
List <DataObject.Kho001> result = Servies.KhoServices.viewK001P1(Ngay, thu);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(result));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "viewSPCL")
{
try
{
String Ngay = context.Request.Form["Ngay"].ToString();
String thu = context.Request.Form["thu"].ToString();
List <DataObject.Kho001> result = Servies.KhoServices.viewSPCL(Ngay, thu);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(result));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "insertOrUpdateViewK001")
{
try
{
//String Ngay, String ID,String productName,String ProductId,String productUnit,String productUnit_DK,String productUnit_CL
String jsonData = context.Request.Form["data"].ToString();
dynamic data = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonData);
for (int i = 0; i < data.Count; i++)
{
String Ngay = data[i].Ngay;
String ID = data[i].ID;
String productName = data[i].productName;
String ProductId = data[i].ProductId;
String productUnit = data[i].productUnit;
String productUnit_DK = data[i].productUnit_DK;
String productUnit_CL = data[i].productUnit_CL;
Servies.KhoServices.insertOrUpdateViewK001(Ngay, ID, productName, ProductId, productUnit, productUnit_DK, productUnit_CL);
}
context.Response.ContentType = "text/plain";
context.Response.Write("1");
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "viewK001P2")
{
try
{
// Case ID > 0 -> Result = 1 record
// Case ID = 0; -> Result = All Record getUserInGroup(String MaHD,String TenKH,String TenSP)
String Ngay = context.Request.Form["Ngay"].ToString();
DataTable lst = Servies.KhoServices.viewK001P2(Ngay);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(lst));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "viewK002")
{
try
{
String TuNgay = context.Request.Form["TuNgay"].ToString();
String DenNgay = context.Request.Form["DenNgay"].ToString();
List <DataObject.Kho002> lst = Servies.KhoServices.viewK002(TuNgay, DenNgay);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(lst));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "InsertKho003ReturnID")
{
try
{
String jsonData = context.Request.Form["data"].ToString();
dynamic data = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonData);
DataObject.Kho003 obj = new DataObject.Kho003();
dynamic dataPX = data.PX;
obj.ID = Convert.ToInt16(dataPX.ID);
obj.NhaCungCap = (String)dataPX.NhaCungCap;
obj.Ten = (String)dataPX.Ten;
obj.SoDT = (String)dataPX.SoDT;
obj.DiaChi = (String)dataPX.DiaChi;
obj.Ngay = DateTime.ParseExact((String)dataPX.Ngay, "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.Kho = Convert.ToInt16(dataPX.Kho);
obj.GhiChu = (String)dataPX.GhiChu;
obj.NgayTao = DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy"), "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.NguoiTao = HttpContext.Current.Session["UserName"].ToString();
obj.MaPhieuNhap = "PN-" + DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh");
obj.MaPhieuXuat = "PX-" + DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh");
obj.Type = Convert.ToInt16(dataPX.Type);
int result = Servies.KhoServices.InsertKho003ReturnID(obj);
dynamic dataDetail = data.Detail;
for (int i = 0; i < dataDetail.Count; i++)
{
DataObject.KhoNhapXuatDetail detail = new DataObject.KhoNhapXuatDetail();
detail.Type = Convert.ToInt16(dataDetail[i].Type);
detail.ID = Convert.ToInt16(dataDetail[i].ID);
if (detail.Type == 0)
{
detail.NhapKhoId = result;
}
else if (detail.Type == 1)
{
detail.XuatKhoId = result;
}
else if (detail.Type == 2)
{
detail.NhapKhoId = result;
}
detail.Product_Code = (String)dataDetail[i].Product_Code;
detail.Product_Name = (String)dataDetail[i].Product_Name;
detail.SoLuong = Convert.ToInt16(dataDetail[i].SoLuong);
detail.DonVi = (String)dataDetail[i].DonVi;
detail.HanSuDung = DateTime.ParseExact((String)dataDetail[i].HanSuDung, "dd/MM/yyyy", CultureInfo.InvariantCulture);
detail.Gia = (String)dataDetail[i].Gia;
detail.Kho = Convert.ToInt16(dataDetail[i].Kho);
Servies.KhoServices.InsertKhoNhapXuatDetailReturnID(detail);
}
context.Response.ContentType = "text/plain";
if (obj.Type == 0)
{
context.Response.Write(obj.MaPhieuNhap);
}
else if (obj.Type == 1)
{
context.Response.Write(obj.MaPhieuXuat);
}
else if (obj.Type == 2)
{
context.Response.Write(obj.MaPhieuNhap);
}
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "viewDetailNhapXuatKho")
{
try
{
String Type = context.Request.Form["TypeXNK"].ToString();
String IdNhapXuat = context.Request.Form["IdNhapXuat"].ToString();
List <DataTable> lst = Servies.KhoServices.viewDetailNhapXuatKho(Convert.ToInt16(Type), Convert.ToInt16(IdNhapXuat));
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(lst));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "viewNhapXuatKho")
{
try
{
String Type = context.Request.Form["TypeXNK"].ToString();
String Ma = context.Request.Form["Ma"].ToString();
String KhoId = context.Request.Form["KhoId"].ToString();
String Ngay = context.Request.Form["Ngay"].ToString();
DataTable lst = Servies.KhoServices.viewNhapXuatKho(Convert.ToInt16(Type), Ma, Convert.ToInt16(KhoId), Ngay);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(lst));
}
catch (Exception e)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error");
}
}
else if (type == "insertOrUpdateNhaCungCap")
{
String jsonData = context.Request.Form["data"].ToString();
dynamic data = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonData);
DataObject.NhaCungCap obj = new DataObject.NhaCungCap();
obj.ID = Convert.ToInt16(data.ID);
obj.MaNCC = (String)data.MaNCC;
obj.TenNCC = (String)data.TenNCC;
obj.SoDT = (String)data.SoDT;
obj.Tinh = (String)data.Tinh;
obj.DiaChi = (String)data.DiaChi;
obj.LoaiDichVu = (String)data.LoaiDichVu;
obj.GhiChu = (String)data.GhiChu;
obj.NgayTao = DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy"), "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.NguoiTao = HttpContext.Current.Session["UserName"].ToString();
int kq = Servies.KhoServices.insertOrUpdateNhaCungCap(obj);
context.Response.ContentType = "text/plain";
context.Response.Write(kq);
}
else if (type == "DeleteNhaCungCap")
{
int ID = Convert.ToInt16(context.Request.Form["ID"].ToString());
Servies.KhoServices.DeleteNhaCungCap(ID);
context.Response.ContentType = "text/plain";
context.Response.Write("1");
}
else if (type == "viewNhaCungCap")
{
//viewNhaCungCap(String MaNCC, String TenNCC, String SoDT, String Tinh, String LoaiDichVu)
String MaNCC = context.Request.Form["MaNCC"].ToString();
String TenNCC = context.Request.Form["TenNCC"].ToString();
String SoDT = context.Request.Form["SoDT"].ToString();
String Tinh = context.Request.Form["Tinh"].ToString();
String LoaiDichVu = context.Request.Form["LoaiDichVu"].ToString();
DataTable dt = Servies.KhoServices.viewNhaCungCap(MaNCC, TenNCC, SoDT, Tinh, LoaiDichVu);
context.Response.ContentType = "application/json";
context.Response.Write(JsonConvert.SerializeObject(dt));
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("1");
}
}
public String InsertKho003ReturnID(String type, String data)
{
try
{
dynamic dataDynamic = Newtonsoft.Json.JsonConvert.DeserializeObject(data);
DataObject.Kho003 obj = new DataObject.Kho003();
dynamic dataPX = dataDynamic.PX;
obj.ID = Convert.ToInt16(dataPX.ID);
obj.NhaCungCap = (String)dataPX.NhaCungCap;
obj.Ten = (String)dataPX.Ten;
obj.SoDT = (String)dataPX.SoDT;
obj.DiaChi = (String)dataPX.DiaChi;
obj.Ngay = DateTime.ParseExact((String)dataPX.Ngay, "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.Kho = Convert.ToInt16(dataPX.Kho);
obj.GhiChu = (String)dataPX.GhiChu;
obj.NgayTao = DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy"), "dd/MM/yyyy", CultureInfo.InvariantCulture);
obj.NguoiTao = this.Session["UserName"].ToString();
obj.MaPhieuNhap = "PN-" + DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh");
obj.MaPhieuXuat = "PX-" + DateTime.Now.ToString("ddMMyy") + DateTime.Now.ToString("tt") + DateTime.Now.ToString("hh");
obj.Type = Convert.ToInt16(dataPX.Type);
int result = Servies.KhoServices.InsertKho003ReturnID(obj);
dynamic dataDetail = dataDynamic.Detail;
for (int i = 0; i < dataDetail.Count; i++)
{
DataObject.KhoNhapXuatDetail detail = new DataObject.KhoNhapXuatDetail();
detail.Type = Convert.ToInt16(dataDetail[i].Type);
detail.ID = Convert.ToInt16(dataDetail[i].ID);
if (detail.Type == 0)
{
detail.NhapKhoId = result;
}
else if (detail.Type == 1)
{
detail.XuatKhoId = result;
}
else if (detail.Type == 2)
{
detail.NhapKhoId = result;
}
detail.Product_Code = (String)dataDetail[i].Product_Code;
detail.Product_Name = (String)dataDetail[i].Product_Name;
detail.SoLuong = Convert.ToInt16(dataDetail[i].SoLuong);
detail.DonVi = (String)dataDetail[i].DonVi;
detail.HanSuDung = DateTime.ParseExact((String)dataDetail[i].HanSuDung, "dd/MM/yyyy", CultureInfo.InvariantCulture);
detail.Gia = (String)dataDetail[i].Gia;
detail.Kho = Convert.ToInt16(dataDetail[i].Kho);
Servies.KhoServices.InsertKhoNhapXuatDetailReturnID(detail);
}
if (obj.Type == 0)
{
return(obj.MaPhieuNhap.ToString());
}
else if (obj.Type == 1)
{
return(obj.MaPhieuXuat.ToString());
}
else if (obj.Type == 2)
{
return(obj.MaPhieuNhap.ToString());
}
return("");
}
catch (Exception e)
{
e.ToString();
return("");
}
}
