private string checkInputData(Trai_Cay trai_Cay)
{
string result = "";
if (trai_Cay.Ten_Trai_Cay == "")
{
result += " Tên trái cây,";
}
if (trai_Cay.Don_Vi_Tinh == "")
{
result += " Đơn vị tính,";
}
if (trai_Cay.Don_Gia_Nhap == 0)
{
result += " Đơn giá nhập,";
}
if (trai_Cay.Don_Gia_Xuat == 0)
{
result += " Đơn giá xuất,";
}
if (trai_Cay.So_Luong == 0)
{
result += " Số lượng ";
}
if (result.Length != 0)
{
result = result.Substring(0, result.Length - 1);
}
return(result);
}
public int themTraiCay(HttpContext context)
{
try
{
string strJson = new StreamReader(context.Request.InputStream).ReadToEnd();
//deserialize the object
Trai_Cay trai_Cay = JsonConvert.DeserializeObject <Trai_Cay>(strJson);
if (trai_Cay == null)
{
return(1);
}
// Check prop của trái cây
string check = checkInputData(trai_Cay);
if (check != "")
{
object_Response.Status_Code = -2;
object_Response.Status_Text = "Vui lòng nhập" + check;
object_Response.Data = "";
context.Response.ContentType = "text/json";
context.Response.Write(JsonConvert.SerializeObject(object_Response));
return(-2);
}
// Parse sang class DTO của linq
string count = string.Format("{0, 0:D3}", db.TRAI_CAYs.Count() + 1);
TRAI_CAY tc = new TRAI_CAY();
tc.Ma_Trai_Cay = "TC" + count;
tc.Ten_Trai_Cay = trai_Cay.Ten_Trai_Cay;
tc.So_Luong = trai_Cay.So_Luong;
tc.Xuat_Xu = trai_Cay.Xuat_Xu;
tc.Don_Gia_Xuat = trai_Cay.Don_Gia_Xuat;
tc.Don_Gia_Nhap = trai_Cay.Don_Gia_Nhap;
tc.Don_Vi_Tinh = trai_Cay.Don_Vi_Tinh;
tc.Loai_ID = trai_Cay.Loai_ID;
LOG_NHAP_TC logNhap = new LOG_NHAP_TC();
logNhap.Auto_ID = "LNTC" + string.Format("{0, 0:D3}", db.LOG_NHAP_TCs.Count() + 1);
logNhap.Don_Gia_Nhap = tc.Don_Gia_Nhap;
logNhap.Ma_Trai_Cay = tc.Ma_Trai_Cay;
logNhap.Thoi_Gian = DateTime.Now;
logNhap.So_Luong_Nhap = tc.So_Luong;
logNhap.Tong_Tien_Nhap = tc.So_Luong * tc.Don_Gia_Nhap;
db.TRAI_CAYs.InsertOnSubmit(tc);
db.LOG_NHAP_TCs.InsertOnSubmit(logNhap);
db.SubmitChanges();
return(0);
}
catch (Exception e)
{
Console.WriteLine(e);
return(-1);
}
}
private int suaTraiCayByID(HttpContext context)
{
try
{
string strJson = new StreamReader(context.Request.InputStream).ReadToEnd();
//deserialize the object
Trai_Cay trai_Cay = JsonConvert.DeserializeObject <Trai_Cay>(strJson);
if (trai_Cay == null)
{
return(1);
}
// Check prop của trái cây
string check = checkInputData(trai_Cay);
if (check != "")
{
object_Response.Status_Code = -2;
object_Response.Status_Text = "Vui lòng nhập" + check;
object_Response.Data = "";
context.Response.ContentType = "text/json";
context.Response.Write(JsonConvert.SerializeObject(object_Response));
return(-2);
}
// Parse sang class DTO của linq
TRAI_CAY tc = db.TRAI_CAYs.Where(p => p.Ma_Trai_Cay == trai_Cay.Ma_Trai_Cay).FirstOrDefault();
tc.Ten_Trai_Cay = trai_Cay.Ten_Trai_Cay;
tc.So_Luong = trai_Cay.So_Luong;
tc.Xuat_Xu = trai_Cay.Xuat_Xu;
tc.Don_Gia_Nhap = trai_Cay.Don_Gia_Nhap;
tc.Don_Gia_Xuat = trai_Cay.Don_Gia_Xuat;
tc.Don_Vi_Tinh = trai_Cay.Don_Vi_Tinh;
tc.Loai_ID = trai_Cay.Loai_ID;
db.SubmitChanges();
return(0);
}
catch (Exception e)
{
Console.WriteLine(e);
return(-1);
}
}
public void ProcessRequest(HttpContext context)
{
var listTraiCay = db.TRAI_CAYs.Where(p => p.Ma_Trai_Cay != "");
var list = new List <Trai_Cay>();
Trai_Cay trai_Cay;
foreach (TRAI_CAY item in listTraiCay.ToList())
{
trai_Cay = new Trai_Cay(item.Ma_Trai_Cay, item.Ten_Trai_Cay, item.So_Luong, item.Don_Gia, item.Don_Vi_Tinh, item.Xuat_Xu, item.Mo_Ta, item.Loai_ID);
list.Add(trai_Cay);
}
var json = JsonConvert.SerializeObject(list);
context.Response.ContentType = "text/json";
context.Response.Write(json);
}
private int getListTraiCay(HttpContext context)
{
try
{
var listTraiCay = db.TRAI_CAYs.Where(p => p.Is_Deleted == 0);
var list = new List <Trai_Cay>();
Trai_Cay trai_Cay;
foreach (TRAI_CAY item in listTraiCay.ToList())
{
// Truy xuat ten loai trai cay tu ma tuong ung
String tenLoaiTC = db.LOAI_TRAI_CAYs.Where(p => p.Ma_Loai_Trai_Cay == item.Loai_ID).FirstOrDefault().Ten_Loai_Trai_Cay;
trai_Cay = new Trai_Cay();
trai_Cay.Ma_Trai_Cay = item.Ma_Trai_Cay;
trai_Cay.Ten_Trai_Cay = item.Ten_Trai_Cay;
trai_Cay.So_Luong = item.So_Luong;
trai_Cay.Don_Gia_Nhap = item.Don_Gia_Nhap;
trai_Cay.Don_Gia_Xuat = item.Don_Gia_Xuat;
trai_Cay.Don_Vi_Tinh = item.Don_Vi_Tinh;
trai_Cay.Xuat_Xu = item.Xuat_Xu;
trai_Cay.Mo_Ta = item.Mo_Ta;
trai_Cay.Loai_ID = item.Loai_ID;
trai_Cay.Ten_Loai_TC = tenLoaiTC;
list.Add(trai_Cay);
}
object_Response.Status_Code = 0;
object_Response.Status_Text = "Get list trái cây thành công";
object_Response.Data = list;
context.Response.ContentType = "text/json";
context.Response.Write(JsonConvert.SerializeObject(object_Response));
return(0);
}
catch (Exception e)
{
Console.WriteLine(e);
return(-1);
}
}
