コード例 #1
0
        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);
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
        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);
            }
        }
コード例 #4
0
        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);
            }
        }