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