Esempio n. 1
0
        public long Create(cust_mast customer)
        {
            using (var ctx = new ConXContext())
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    cust_mast newCust = new cust_mast()
                    {
                        cust_name = customer.cust_name,
                        //surname = customer.surname,
                        address1 = customer.address1,
                        //address2 = customer.address2,
                        subDistrict = customer.subDistrict,
                        district    = customer.district,
                        province    = customer.province,
                        zipCode     = customer.zipCode,
                        status      = "A",
                        fax         = customer.fax,
                        tel         = customer.tel,
                        sex         = customer.sex,
                        line        = customer.line,
                    };
                    ctx.CustMasts.Add(newCust);
                    ctx.SaveChanges();
                    scope.Complete();

                    return(newCust.customerId);
                }
            }
        }
Esempio n. 2
0
        public void Update(CustomerView model)
        {
            using (var ctx = new ConXContext())
            {
                //string imagePath = @model.pic_file_path;
                //string imgBase64String = Util.Util.GetBase64StringForImage(imagePath);

                using (TransactionScope scope = new TransactionScope())
                {
                    cust_mast updateObj = ctx.CustMasts.Where(z => z.customerId == model.customerId).SingleOrDefault();

                    updateObj.cust_name   = model.cust_name;
                    updateObj.address1    = model.address1;
                    updateObj.subDistrict = model.subDistrict;
                    updateObj.district    = model.district;
                    updateObj.province    = model.province;
                    updateObj.zipCode     = model.zipCode;
                    updateObj.tel         = model.tel;



                    ctx.SaveChanges();
                    scope.Complete();
                }
            }
        }
Esempio n. 3
0
        //public void SyncUpdate(cust_mast customer)
        //{
        //    using (var ctx = new ConXContext())
        //    {
        //        using (TransactionScope scope = new TransactionScope())
        //        {

        //        }
        //    }
        //}

        public void Update(cust_mast customer)
        {
            using (var ctx = new ConXContext())
            {
                using (TransactionScope scope = new TransactionScope())
                {
                }
            }
        }
Esempio n. 4
0
        public long IsExitingCustomer(cust_mast cust)
        {
            using (var ctx = new ConXContext())
            {
                cust_mast customer = ctx.CustMasts
                                     .Where(x =>
                                            x.cust_name == cust.cust_name &&
                                            x.address1 == cust.address1
                                            //&& x.address2 == cust.address2
                                            && x.subDistrict == cust.subDistrict &&
                                            x.district == cust.district &&
                                            x.province == cust.province &&
                                            x.zipCode == cust.zipCode &&
                                            x.tel == cust.tel
                                            ).SingleOrDefault();

                return((customer != null) ? customer.customerId : 0);
            }
        }
Esempio n. 5
0
        public CustomerView GetInfo(int code)
        {
            using (var ctx = new ConXContext())
            {
                cust_mast model = ctx.CustMasts
                                  .Where(z => z.customerId == code).SingleOrDefault();

                return(new CustomerView
                {
                    customerId = model.customerId,
                    cust_name = model.cust_name,
                    address1 = model.address1,
                    subDistrict = model.subDistrict,
                    district = model.district,
                    province = model.province,
                    zipCode = model.zipCode,
                    tel = model.tel
                });
            }
        }
Esempio n. 6
0
        public HttpResponseMessage postCreate(cust_mast model)
        {
            try
            {
                //check dupplicate Code
                //var isDupplicate = colorSvc.CheckDupplicate(model.menuFunctionId);
                //if (isDupplicate)
                //{
                //    return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัสเมนู {0} มีอยู่ในระบบแล้ว", model.menuFunctionId));
                //}

                customerService.Create(model);

                return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ"));
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString()));
            }
        }
Esempio n. 7
0
        public void Delete(CustomerView custView)
        {
            using (var ctx = new ConXContext())
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    cust_mast cust = ctx.CustMasts
                                     .Where(z => z.customerId == custView.customerId)
                                     .SingleOrDefault();

                    //ctx.UserBranchPrvlgs.RemoveRange(ctx.UserBranchPrvlgs.Where(z => z.username == colorView.emb_color_mast_id));
                    //ctx.SaveChanges();

                    ctx.CustMasts.Remove(cust);

                    ctx.SaveChanges();

                    scope.Complete();
                }
            }
        }