private int huyDonHangById(HttpContext context) { try { string maDonHang = context.Request.QueryString["MaDonHang"]; if (maDonHang.Length == 0) { return(1); } var donhang = db.DON_HANGs.Where(x => x.Ma_Don_Hang == maDonHang).FirstOrDefault(); if (donhang == null) { return(2); } donhang.Tinh_Trang = (int)DonHang.DH_Cancel; db.SubmitChanges(); return(0); } catch (Exception e) { Console.WriteLine("Exception huyDonHangById", e); } return(-1); }
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 saveTraiCay() { try { string maTraiCay = Request.QueryString["MaTraiCay"].ToString(); var traiCay = db.TRAI_CAYs.Where(p => p.Ma_Trai_Cay == maTraiCay).FirstOrDefault(); if (traiCay == null) { return(2); } traiCay.Mo_Ta = txtMoTa.Value; traiCay.Url_Anh = "/Image/" + imageUpload.PostedFile.FileName; db.SubmitChanges(); return(1); } catch (Exception e) { Console.WriteLine(e); return(2); } }
public int themLoaiTraiCay(HttpContext context) { try { string strJson = new StreamReader(context.Request.InputStream).ReadToEnd(); //deserialize the object Loai_Trai_Cay loai_Trai_Cay = JsonConvert.DeserializeObject <Loai_Trai_Cay>(strJson); if (loai_Trai_Cay == null) { return(1); } // Check prop của loại trái cây string check = checkInputData(loai_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.LOAI_TRAI_CAYs.Count() + 1); var ltc = new LOAI_TRAI_CAY(); ltc.Ma_Loai_Trai_Cay = "LTC" + count; ltc.Ten_Loai_Trai_Cay = loai_Trai_Cay.Ten_Loai_Trai_Cay; db.LOAI_TRAI_CAYs.InsertOnSubmit(ltc); db.SubmitChanges(); return(0); } catch (Exception e) { Console.WriteLine(e); return(-1); } }