示例#1
0
 //UPDATE Customer
 public JsonResult UpdateStore(store store)
 {
     if (ModelState.IsValid)
     {
         store st = _context.Stores.Where(c => c.Id == store.Id).SingleOrDefault();
         st.Name    = store.Name;
         st.Address = store.Address;
         _context.SaveChanges();
         return(new JsonResult {
             Data = "Sucess", JsonRequestBehavior = JsonRequestBehavior.AllowGet
         });
     }
     else
     {
         //Console.Write(e.Data + "Exception Occured");
         var modelErrors = new List <string>();
         foreach (var modelState in ModelState.Values)
         {
             foreach (var modelError in modelState.Errors)
             {
                 modelErrors.Add(modelError.ErrorMessage);
             }
         }
         return(new JsonResult {
             Data = modelErrors, JsonRequestBehavior = JsonRequestBehavior.AllowGet
         });
     }
 }
示例#2
0
        private void BtupdateCustomer_Click(object sender, EventArgs e)
        {
            var query2 = store.employee.FirstOrDefault(m => m.EmployeeName == MandobNametextBox1.Text);
            var check  = store.SalesRepresentatives.FirstOrDefault(s => s.Employee_Id == query2.ID);

            if (check != null)
            {
                store = new store();
                p_id  = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
                var query = store.SalesRepresentatives.FirstOrDefault(p => p.ID == p_id);
                var q     = store.employee.FirstOrDefault(m => m.ID == query.Employee_Id);
                q.EmployeeName = MandobNametextBox1.Text.ToString();
                q.Address      = CustomerAddressTxt.Text.ToString();
                q.Phone        = CustomerPhoneTxt.Text.ToString();

                store.SaveChanges();

                bindGridView();
                CustomerAddressTxt.Text = "";
                CustomerPhoneTxt.Text   = "";
                MandobNametextBox1.Text = "";
            }
            else
            {
                MessageBox.Show("هذا المندوب موجود  بالفعل");
                MandobNametextBox1.Text = "";
            }
        }
示例#3
0
        /// <summary>
        /// 增加打印店
        /// </summary>
        /// <returns></returns>
        public string addPrintStore()
        {
            store store = new store();

            store.s_id        = Request["s_id"];
            store.sk_tel      = Request["sk_tel"].ToString();
            store.s_name      = Request["s_name"].ToString();
            store.s_school    = Request["s_school"].ToString();
            store.s_location  = Request["s_location"].ToString();
            store.s_machine   = Convert.ToInt16(Request["s_machine"].ToString());
            store.s_computer  = Convert.ToInt16(Request["s_computer"].ToString());
            store.s_worker    = Convert.ToInt16(Request["s_worker"].ToString());
            store.s_worktime  = Request["s_worktime"].ToString();
            store.s_runstate  = Convert.ToInt16(Request["s_runstate"].ToString());
            store.s_breifinfo = Request["s_breifinfo"].ToString();
            store.s_sculpture = scul_extent; //图片头像,的扩展
            store.s_photo     = spho_extent; //图片实拍,的扩展
            string or_id = bs.addPrintStore(store);

            if (or_id != "0" && or_id != "1" && or_id != "2")
            {
                changelocation(or_id);
            }                                                                       //添加成功则改变图片位置
            return(or_id);
        }
示例#4
0
        private void TXT_customerSearch_TextChanged(object sender, EventArgs e)
        {
            store = new store();
            var query = (from s in store.SalesRepresentatives
                         from m in store.employee
                         where (s.Employee_Id == m.ID && s.status == false && m.EmployeeName.Contains(TXT_customerSearch.Text))
                         select new { s, m }
                         ).ToList();

            if (query.Count != 0)
            {
                DGV_Customer.RowCount = query.Count;


                int i = 0;
                foreach (var item in query)
                {
                    DGV_Customer.Rows[i].Cells[0].Value = item.s.ID.ToString();
                    DGV_Customer.Rows[i].Cells[1].Value = item.m.EmployeeName.ToString();

                    DGV_Customer.Rows[i].Cells[2].Value = item.m.Phone.ToString();
                    DGV_Customer.Rows[i].Cells[3].Value = item.m.Address;

                    i++;
                }
            }
            else
            {
                DGV_Customer.Rows.Clear();
            }
        }
示例#5
0
        public void bindGridView()
        {
            bt_addCustomer.Show();
            BtupdateCustomer.Hide();
            DGV_Customer.Rows.Clear();

            store = new store();

            var query = (from s in store.SalesRepresentatives
                         from m in store.employee
                         where (s.Employee_Id == m.ID && s.status == false)
                         select new { m, s }
                         ).ToList();

            if (query.Count != 0)
            {
                DGV_Customer.RowCount = query.Count;


                int i = 0;
                foreach (var item in query)
                {
                    DGV_Customer.Rows[i].Cells[0].Value = item.s.ID.ToString();
                    DGV_Customer.Rows[i].Cells[1].Value = item.m.EmployeeName.ToString();

                    DGV_Customer.Rows[i].Cells[2].Value = item.m.Phone.ToString();
                    DGV_Customer.Rows[i].Cells[3].Value = item.m.Address;

                    i++;
                }
            }
            DGV_Customer.Refresh();
            DGV_Customer.Update();
        }
示例#6
0
        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            // text changed
            store = new store();
            var query = store.employee.Where(p => p.Status == false && p.EmployeeName.Contains(textBox1.Text)).ToList();


            if (query.Count != 0)
            {
                DGV_EmployeeHome.RowCount = query.Count;


                int i = 0;
                foreach (var item in query)
                {
                    DGV_EmployeeHome.Rows[i].Cells[4].Value = item.ID.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[3].Value = item.EmployeeName.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[1].Value = item.Salary.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[2].Value = item.Phone.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[0].Value = item.Address;

                    i++;
                }
            }
            else
            {
                DGV_EmployeeHome.Rows.Clear();
            }
        }
示例#7
0
        public async Task StoreAsync()
        {
            IUserMessage responce = await ReplyAsync("Getting store...");

            string data = Program.ShopRequest("dev_account_username", "dev_account_password");

            if (data == "nullerror")
            {
                await responce.DeleteAsync();
                await ReplyAsync("Invalid credentials");
            }
            else
            {
                store      storeobj = JsonConvert.DeserializeObject <store>(data);
                string     json     = GetRequest("https://valorant-api.com/v1/bundles/" + storeobj.FeaturedBundle.Bundle.DataAssetID);
                BundleRoot bundle   = JsonConvert.DeserializeObject <BundleRoot>(json);
                if (!File.Exists(bundle.data.uuid + ".png"))
                {
                    using (var client = new WebClient())
                    {
                        client.DownloadFile(new Uri(bundle.data.displayIcon), bundle.data.uuid + ".png");
                    }
                }
                TimeSpan t        = TimeSpan.FromSeconds(storeobj.FeaturedBundle.BundleRemainingDurationInSeconds);
                string   timeLeft = string.Format("{0:D2} days, {1:D2} hours, {2:D2} minutes, and {3:D2} seconds.",
                                                  t.Days,
                                                  t.Hours,
                                                  t.Minutes,
                                                  t.Seconds);
                await responce.DeleteAsync();
                await ReplyAsync("Right now, the " + bundle.data.displayName + " bundle is in the shop. The bundle will be in the shop for " + timeLeft);

                await responce.Channel.SendFileAsync(bundle.data.uuid + ".png");
            }
        }
示例#8
0
        // GET: StoresMain/Details/5
        public ActionResult Details(int id)
        {
            store storee = null;

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:54964/api/StoresApi");
                //HTTP GET
                var responseTask = client.GetAsync("StoresApi?id=" + id.ToString());
                responseTask.Wait();

                var result = responseTask.Result;
                if (result.IsSuccessStatusCode)
                {
                    var readTask = result.Content.ReadAsAsync <store>();
                    readTask.Wait();

                    storee = readTask.Result;
                }
                else //web api sent error response
                {
                    //log response status here..


                    ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
                }
            }
            return(View(storee));
        }
示例#9
0
        private static dicDataDeployments CreateDicDataDeployments()
        {
            dicDataDeployments ddds = new dicDataDeployments();

            ddds.version = Data.version;
            ddds.ListdicDataDeployment = new List <dicDataDeployment>();

            dicDataDeployment ddd = new dicDataDeployment();

            ddd.descriptionFile          = Constants.descriptionFile;
            ddd.archiveFile              = Data.PathToZip;
            ddd.activationTimeStamp      = DateTime.UtcNow.ToLocalTime().ToString();
            ddd.localDownloadTimeStamp   = DateTime.UtcNow.ToLocalTime().ToString();
            ddd.centralDownloadTimeStamp = DateTime.UtcNow.ToLocalTime().ToString();
            ddd.destinations             = new List <destination>();

            destination dest = new destination();

            dest.source       = "destinations";
            dest.name         = Data.PathToZip;
            dest.stores       = new List <store>();
            dest.systemGroups = new List <string>();

            store objStore = new store();

            objStore.name = Data.storeDetails;

            dest.stores.Add(objStore);
            ddd.destinations.Add(dest);
            ddds.ListdicDataDeployment.Add(ddd);

            return(ddds);
        }
示例#10
0
        private void BtupdateCustomer_Click(object sender, EventArgs e)
        {
            if (CustomerNameTxt.Text == null || CustomerAddressTxt.Text == null || CustomerPhoneTxt.Text == null ||
                CustomerTypecomboBox.SelectedItem == null)

            {
                MessageBox.Show("يجب ان تدخل كل البيانات");
            }
            else
            {
                store = new store();
                p_id  = int.Parse(DGV_Customer.SelectedRows[0].Cells[0].Value.ToString());
                var query = store.customers.FirstOrDefault(p => p.ID == p_id);
                query.Name    = CustomerNameTxt.Text.ToString();
                query.addrees = CustomerAddressTxt.Text.ToString();
                query.Phone   = CustomerPhoneTxt.Text.ToString();
                query.type    = CustomerTypecomboBox.SelectedItem.ToString();
                store.SaveChanges();
                MessageBox.Show("تم التعديل بنجاح");
                CustomerNameTxt.Text    = "";
                CustomerAddressTxt.Text = "";
                CustomerPhoneTxt.Text   = "";
                bindGridView();
            }
        }
示例#11
0
        private void TXT_customerSearch_TextChanged(object sender, EventArgs e)
        {
            store = new store();
            var query = store.customers.Where(p => p.Status == false && p.Name.Contains(TXT_customerSearch.Text)).ToList();

            if (query.Count != 0)
            {
                DGV_Customer.RowCount = query.Count;

                int i = 0;
                foreach (var item in query)
                {
                    DGV_Customer.Rows[i].Cells[0].Value = item.ID.ToString();
                    DGV_Customer.Rows[i].Cells[1].Value = item.Name.ToString();
                    DGV_Customer.Rows[i].Cells[2].Value = item.Phone.ToString();
                    // DGV_Customer.Rows[i].Cells[3].Value = item.a.ToString();
                    DGV_Customer.Rows[i].Cells[3].Value = item.addrees;

                    i++;
                }
            }
            else
            {
                DGV_Customer.Rows.Clear();
            }
        }
示例#12
0
        public ApiMessage <string> Save(instore model)
        {
            var api = new ApiMessage <string>();

            model.UnitName = model.UnitID;
            model.ID       = Guid.NewGuid().ToString();
            using (var scope = new PetaPoco.Transaction(_db))
            {
                var sModel = _db.FirstOrDefault <store>("where ProductID=@ProductID AND UnitID=@UnitID", model);
                if (sModel == null)
                {
                    sModel             = new store();
                    sModel.Amount      = model.Amount;
                    sModel.ProductID   = model.ProductID;
                    sModel.ProductName = model.ProductName;
                    sModel.UnitID      = model.UnitID;
                    sModel.UnitName    = model.UnitID;
                    sModel.UpdateDate  = DateTime.Now;
                    sModel.CreateDate  = DateTime.Now;
                    sModel.ID          = Guid.NewGuid().ToString();
                    sModel.OutAmount   = 0;
                    sModel.OutAmount   = 0;
                    _db.Insert(sModel);
                }
                else
                {
                    sModel.Amount = sModel.Amount + model.Amount;
                    _db.Update(sModel);
                }
                _db.Insert(model);
                scope.Complete();
            }
            return(api);
        }
        public IHttpActionResult Poststore(StoreDto storeDto)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            store store = new store();

            store.id        = storeDto.id;
            store.name      = storeDto.name;
            store.location  = storeDto.location;
            store.status_id = storeDto.status.id;
            db.stores.Add(store);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (storeExists(store.id))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = store.id }, store));
        }
示例#14
0
        public ActionResult Create([Bind(Include = "Id,Picture,Name,Location,Description,Likes,Dislikes,Visitors_Frequency,Profit_Yearly,Number_of_stores,Added_by,Created_Date,Modified_Date,Pic_Courtesy_of")] store store)
        {
            if (store.Picture == null)
            {
                store.Picture = "https://upload.wikimedia.org/wikipedia/commons/e/e3/Wako1000.jpg";
            }

            if (store.Pic_Courtesy_of == null)
            {
                store.Pic_Courtesy_of = "Source not known";
            }

            DateTime dateNow = DateTime.UtcNow;

            store.Created_Date  = dateNow;
            store.Modified_Date = dateNow;

            int?currentLikes = 0;

            store.Likes    = currentLikes;
            store.Dislikes = currentLikes;

            if (ModelState.IsValid)
            {
                db.stores.Add(store);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(store));
        }
示例#15
0
        /// <summary>
        /// 编辑打印店信息,打印店名称不能修改且唯一
        /// </summary>
        /// <returns></returns>
        public int SaveChange()
        {
            store store = new store();

            store.s_id        = Request["s_id"];
            store.sk_tel      = Request["sk_tel"].ToString();
            store.s_name      = Request["s_name"].ToString();
            store.s_school    = Request["s_school"].ToString();
            store.s_location  = Request["s_location"].ToString();
            store.s_machine   = Convert.ToInt16(Request["s_machine"].ToString());
            store.s_computer  = Convert.ToInt16(Request["s_computer"].ToString());
            store.s_worker    = Convert.ToInt16(Request["s_worker"].ToString());
            store.s_worktime  = Request["s_worktime"].ToString();
            store.s_runstate  = Convert.ToInt16(Request["s_runstate"].ToString());
            store.s_breifinfo = Request["s_breifinfo"].ToString();
            store.s_carry     = Convert.ToBoolean(Request["s_carry"]);
            store.s_carryterm = Convert.ToInt32(Request["s_carryterm"]);
            store.s_carryadd  = Convert.ToInt32(Request["s_carryadd"]);
            if (scul_extent != "")
            {
                store.s_sculpture = scul_extent;
            }                                                           //图片头像,的扩展
            if (spho_extent != "")
            {
                store.s_photo = spho_extent;
            }                           //图片实拍,的扩展
            changelocation(store.s_id); //改变图片位置
            return(bs.editshop(store));
        }
示例#16
0
        public int editshop(store shop)
        {
            string sql = "";

            if (shop.s_sculpture != null && shop.s_photo != null)
            {
                sql = "update  store set sk_tel='" + shop.sk_tel + "',s_worker='" + shop.s_worker + "',s_school='" + shop.s_school + "'," +
                      "s_location='" + shop.s_location + "',s_machine='" + shop.s_machine + "',s_breifinfo='" + shop.s_breifinfo + "'" +
                      ",s_computer='" + shop.s_computer + "',s_worktime='" + shop.s_worktime + "',s_runstate='" + shop.s_runstate + "' ," +
                      "s_carry=" + shop.s_carry + ",s_carryterm=" + shop.s_carryterm + ",s_carryadd=" + shop.s_carryadd + ",s_sculpture='" + shop.s_id + shop.s_sculpture + "',s_photo='" + shop.s_id + shop.s_photo + "' where s_id='" + shop.s_id + "' ";
            }
            else if (shop.s_sculpture == null && shop.s_photo != null)
            {
                sql = "update  store set sk_tel='" + shop.sk_tel + "',s_worker='" + shop.s_worker + "',s_school='" + shop.s_school + "'," +
                      "s_location='" + shop.s_location + "',s_machine='" + shop.s_machine + "',s_breifinfo='" + shop.s_breifinfo + "'" +
                      ",s_computer='" + shop.s_computer + "',s_worktime='" + shop.s_worktime + "',s_runstate='" + shop.s_runstate + "' ," +
                      "s_carry=" + shop.s_carry + ",s_carryterm=" + shop.s_carryterm + ",s_carryadd=" + shop.s_carryadd + ",s_photo='" + shop.s_id + shop.s_photo + "' where s_id='" + shop.s_id + "' ";
            }
            else if (shop.s_sculpture != null && shop.s_photo == null)
            {
                sql = "update  store set sk_tel='" + shop.sk_tel + "',s_worker='" + shop.s_worker + "',s_school='" + shop.s_school + "'," +
                      "s_location='" + shop.s_location + "',s_machine='" + shop.s_machine + "',s_breifinfo='" + shop.s_breifinfo + "'" +
                      ",s_computer='" + shop.s_computer + "',s_worktime='" + shop.s_worktime + "',s_runstate='" + shop.s_runstate + "' ," +
                      "s_carry=" + shop.s_carry + ",s_carryterm=" + shop.s_carryterm + ",s_carryadd=" + shop.s_carryadd + ",s_sculpture='" + shop.s_id + shop.s_sculpture + "' where s_id='" + shop.s_id + "' ";
            }
            else
            {
                sql = "update  store set sk_tel='" + shop.sk_tel + "',s_worker='" + shop.s_worker + "',s_school='" + shop.s_school + "'," +
                      "s_location='" + shop.s_location + "',s_machine='" + shop.s_machine + "',s_breifinfo='" + shop.s_breifinfo + "'" +
                      ",s_computer='" + shop.s_computer + "',s_worktime='" + shop.s_worktime + "',s_runstate='" + shop.s_runstate + "' ," +
                      "s_carry=" + shop.s_carry + ",s_carryterm=" + shop.s_carryterm + ",s_carryadd=" + shop.s_carryadd + " where s_id='" + shop.s_id + "' ";
            }

            return(mysqlDBhelper.dochangesql(sql));
        }
示例#17
0
        public void bindGridView()
        {
            // Btn_SaveEmp.Show();
            UpdateBtnEmployee.Hide();
            DGV_EmployeeHome.DataSource = null;
            DGV_EmployeeHome.Refresh();
            store = new store();
            var query = store.employee.Where(p => p.Status == false).ToList();

            DGV_EmployeeHome.RowCount = query.Count;


            if (query.Count != 0)
            {
                DGV_EmployeeHome.RowCount = query.Count;


                int i = 0;
                foreach (var item in query)
                {
                    DGV_EmployeeHome.Rows[i].Cells[4].Value = item.ID.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[3].Value = item.EmployeeName.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[1].Value = item.Salary.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[2].Value = item.Phone.ToString();
                    DGV_EmployeeHome.Rows[i].Cells[0].Value = item.Address;

                    i++;
                }
            }
        }
示例#18
0
        static void Main(string[] args)
        {
            string text = System.IO.File.ReadAllText(@"C:\Users\Marishka\Desktop\товары.txt");

            string[] hollow = text.Split(new char[] { '\r', '\t', '\n' });

            List <string> arr = new List <string>();

            for (int i = 0; i < hollow.Length; i++)
            {
                if (hollow[i] != "")
                {
                    arr.Add(hollow[i]);
                }
            }

            store[] goods = new store[5];
            int     count = 0;

            for (int i = 0; i < goods.Length; i++)
            {
                goods[i].name = arr[count];
                count++;
                goods[i].kolichestvo = Convert.ToInt32(arr[count]);
                count++;
                goods[i].price = Convert.ToInt32(arr[count]);
                count++;
                goods[i].fabricate = arr[count];
                count++;
                goods[i].date = Convert.ToDateTime(arr[count]);
                count++;
            }

            for (int i = 0; i < goods.Length; i++)
            {
                if (goods[i].kolichestvo >= 5)
                {
                    Console.WriteLine(goods[i].name + "\t" + goods[i].kolichestvo + "\t" + goods[i].price + "\t" + goods[i].fabricate + "\t" + goods[i].date);
                }
            }

            DateTime max = DateTime.MinValue;

            count = 0;
            for (int i = 0; i < goods.Length; i++)
            {
                if (goods[i].date > max)
                {
                    max   = goods[i].date;
                    count = i;
                }
            }

            Console.WriteLine();

            Console.WriteLine("Мах дата: {0}", goods[count].name + "\t" + goods[count].kolichestvo + "\t" + goods[count].price + "\t" + goods[count].fabricate + "\t" + goods[count].date);


            Console.ReadKey();
        }
示例#19
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (textBox6.Text != "")
     {
         if (textBox13.Text != "")
         {
             if (textBox4.Text != "")
             {
                 int   storeStock = Convert.ToInt32(textBox11.Text);
                 int   dispStock  = Convert.ToInt32(textBox12.Text);
                 int   quantity   = Convert.ToInt32(textBox13.Text);
                 store st         = new store();
                 st.receiveStock(storeStock, dispStock, quantity, textBox6.Text, textBox4.Text, username);
                 loadMedicines();
                 textBox5.Text = "";
                 clearData();
             }
             else
             {
                 MessageBox.Show("Please enter Bill No.!!");
             }
         }
         else
         {
             MessageBox.Show("Please enter the amount of Stock Purchased!!");
         }
     }
     else
     {
         MessageBox.Show("Please Select a Medicine!!");
     }
 }
示例#20
0
 //CREATE customer
 public JsonResult CreateStore(store store)
 {
     if (ModelState.IsValid)
     {
         _context.Stores.Add(store);
         _context.SaveChanges();
         return(new JsonResult {
             Data = "Sucess", JsonRequestBehavior = JsonRequestBehavior.AllowGet
         });
     }
     else
     {
         //Console.Write(e.Data + "Exception Occured");
         var modelErrors = new List <string>();
         foreach (var modelState in ModelState.Values)
         {
             foreach (var modelError in modelState.Errors)
             {
                 modelErrors.Add(modelError.ErrorMessage);
             }
         }
         return(new JsonResult {
             Data = modelErrors, JsonRequestBehavior = JsonRequestBehavior.AllowGet
         });
     }
 }
示例#21
0
        // POST: odata/store
        public async Task <IHttpActionResult> Post(store store)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.store.Add(store);

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateException)
            {
                if (storeExists(store.IdStore))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(Created(store));
        }
示例#22
0
        // GET: store/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            store store = await db.store.FindAsync(id);

            if (store == null)
            {
                return(HttpNotFound());
            }



            if (store.Latitude != null)
            {
                ViewBag.Latitude = store.Latitude.ToString().Replace(",", ".");
            }
            if (store.Longitude != null)
            {
                ViewBag.Longitude = store.Longitude.ToString().Replace(",", ".");
            }

            GetStates(store);
            GetCompanies(store);
            GetCategories(store);

            return(View(store));
        }
        public IHttpActionResult Putstore(int id, store store)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != store.store_id)
            {
                return(BadRequest());
            }

            db.Entry(store).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!storeExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
示例#24
0
        public async Task <IActionResult> Poststore([FromBody] store store)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }
                else
                {
                    storeRepository_.Save(store);
                    //var result = _context.stores.Add(store);
                    //await _context.SaveChangesAsync();
                    return(Ok(store));
                }
            } catch (Exception exM)
            {
                Console.WriteLine(exM.Message);
                throw;
            }


            // _context.stores.Add(store);
            //await _context.SaveChangesAsync();

            //return CreatedAtAction("Getstore", new { id = store.idS }, store);
        }
        public StoreDto getStoreDto(String id)
        {
            store    store    = db.stores.Where(s => s.id == id).FirstOrDefault();
            StoreDto storeDto = new StoreDto(store.id, store.name, store.location, statusRepository.getStatus(store.status_id));

            return(storeDto);
        }
示例#26
0
        public async Task <IActionResult> Putstore([FromRoute] string id, [FromBody] store store)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != store.idS)
            {
                return(BadRequest());
            }

            _context.Entry(store).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!storeExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
示例#27
0
        public ActionResult Create([Bind(Include = "stor_id,stor_name,stor_address,city,state,zip")] store store)
        {
            if (ModelState.IsValid)
            {
                var test = db.stores.Find(store.stor_id); //find if stor_id (prim key's) already exists

                if (test == null)
                {
                    db.stores.Add(store);
                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception e)
                    {
                        return(RedirectToAction("../Home/Error"));
                    }
                }
                else
                {
                    return(RedirectToAction("../Home/Error"));
                }



                return(RedirectToAction("Index"));
            }

            return(View(store));
        }
示例#28
0
    void CreateManager(XmlNode StoreNode, store storeobj)
    {
        // Created New Manger from Manager Prefab
        GameObject NewManager = (GameObject)Instantiate(ManagerPrefab);

        // Update name of Manager to Store Name
        Text ManagerNameText = NewManager.transform.Find("ManagerNameText").GetComponent <Text>();

        ManagerNameText.text = storeobj.StoreName;

        // Update Manager Cost from XML to Store Object
        storeobj.ManagerCost = float.Parse(StoreNode.InnerText);

        // Get Manager Button Component and link with UIStore Object
        Button  ManagerButton = NewManager.transform.Find("UnlockManagerButton").GetComponent <Button>();
        UIStore UIManager     = storeobj.GetComponent <UIStore>();

        UIManager.ManagerButton = ManagerButton;

        // Uppdate Text in Manager Button with Manager Cost
        Text ManagerButtonText = ManagerButton.transform.Find("UnlockManagerButtonText").GetComponent <Text>();

        ManagerButtonText.text = "Unlock " + storeobj.ManagerCost.ToString("C2");

        // Add listner to Manager Button
        ManagerButton.onClick.AddListener(storeobj.UnlockManager);

        NewManager.transform.SetParent(ManagerPanel.transform);
    }
示例#29
0
        /// <summary>
        /// 添加打印店,先检测是否存在,再在打印店表和,所有用户记录表中添加
        /// </summary>
        /// <param name="shop"></param>
        /// <returns></returns>
        public int addPrintStore(store shop)
        {
            string sql0 = "select s_id from store where s_name='" + shop.s_name + "'";//查询打印店表中是否有 相同打印店名称

            if (mysqlDBhelper.doselectsqlReturnNum(sql0) == 0)
            {
                string s_id  = "";
                int    check = 0;
                do
                {
                    s_id = productId();
                    string sql1 = "select s_name from store where s_id='" + s_id + "'";
                    check = mysqlDBhelper.doselectsqlReturnNum(sql1);
                } while (check != 0);
                //插入行细信息
                string sql = "insert into store(s_id,sk_tel,s_name,s_worker,s_school,s_location,s_machine,s_breifinfo,s_sculpture,s_computer,s_worktime,s_runstate)" +
                             "values('" + s_id + "','" + shop.sk_tel + "','" + shop.s_name + "','" + shop.s_worker + "','" + shop.s_school + "'," +
                             "'" + shop.s_location + "','" + shop.s_machine + "','" + shop.s_breifinfo + "','" + shop.s_sculpture + "'" +
                             ",'" + shop.s_computer + "','" + shop.s_worktime + "','" + shop.s_runstate + "')";
                return(mysqlDBhelper.dochangesql(sql));
            }
            else
            {
                return(-1);
            }
        }
示例#30
0
        private void InsertCategoriesFromStore(List <string> categories, store store)
        {
            IQueryable <storeCategory> sc;

            foreach (var category in db.storeCategory.Where(scs => scs.IdStore == store.IdStore))
            {
                category.DeletionDatetime = DateTime.Now;
            }


            // TERMINAR LA INSERCIÓN.
            foreach (var category in categories)
            {
                if (category.Contains("C-"))
                {
                    //is a category
                    int id = Convert.ToInt32(category.Split(new char[] { 'C', '-' })[2]);

                    sc = db.storeCategory.Where(scs => scs.IdCategory == id && scs.IdStore == store.IdStore);
                    if (sc.Count() == 0)
                    {
                        db.storeCategory.Add(new storeCategory()
                        {
                            IdStore    = store.IdStore,
                            IdCategory = Convert.ToInt32(id)
                        });
                    }
                    else
                    {
                        sc.FirstOrDefault().DeletionDatetime = null;
                    }
                }
                else
                {
                    //is a subcategory
                    int id = Convert.ToInt32(category.Split(new char[] { 'S', '-' })[2]);
                    sc = db.storeCategory.Where(scs => scs.IdCategory == id && scs.IdStore == store.IdStore);

                    if (sc.Count() == 0)
                    {
                        db.storeCategory.Add(new storeCategory()
                        {
                            IdStore       = store.IdStore,
                            IdSubCategory = Convert.ToInt32(id)
                        });
                    }
                    else
                    {
                        sc.FirstOrDefault().DeletionDatetime = null;
                    }
                }
            }

            try
            {
                db.SaveChanges();
            }
            catch (Exception e) { }
        }
 /// <summary>
 /// 创建新的 store 对象。
 /// </summary>
 /// <param name="store_id">store_id 的初始值。</param>
 /// <param name="store_code">store_code 的初始值。</param>
 /// <param name="store_name">store_name 的初始值。</param>
 public static store Createstore(int store_id, string store_code, string store_name)
 {
     store store = new store();
     store.store_id = store_id;
     store.store_code = store_code;
     store.store_name = store_name;
     return store;
 }
 /// <summary>
 /// 架构中不存在 store 的注释。
 /// </summary>
 public void AddTostore(store store)
 {
     base.AddObject("store", store);
 }