public bool UpdateStatusInMySQL(StatusInJSON elementInJSON) { try { using (var dc = new MySQLEntities()) { var idstatus = elementInJSON.codeStatuses; var elementMySQL = dc.status.Find(idstatus); if (elementMySQL == null) { elementMySQL = dc.status.Add(new status()); } elementMySQL.idstatus = elementInJSON.codeStatuses; elementMySQL.name = elementInJSON.name; dc.SaveChanges(); } return(true); } catch { return(false); } }
public bool UpdateDistrictInMySQL(DistrictInJSON elementInJSON) { try { using (var dc = new MySQLEntities()) { Guid iddistricts = new Guid(elementInJSON.iddistricts); var elementMySQL = dc.districts.Find(iddistricts); if (elementMySQL == null) { elementMySQL = dc.districts.Add(new districts()); } elementMySQL.iddistricts = new Guid(elementInJSON.iddistricts); elementMySQL.name = elementInJSON.name; dc.SaveChanges(); } return(true); } catch { return(false); } }
public bool UpdateWorkInMySQL(WorkInJSON elementInJSON) { try { using (var dc = new MySQLEntities()) { Guid idWorks = new Guid(elementInJSON.idworks); var elementMySQL = dc.works.Find(idWorks); if (elementMySQL == null) { elementMySQL = dc.works.Add(new works()); } elementMySQL.idWorks = new Guid(elementInJSON.idworks); elementMySQL.name = elementInJSON.name; elementMySQL.Price = elementInJSON.price; dc.SaveChanges(); } return(true); } catch { return(false); } }
public bool UpdateCustomerInMySQL(CustomerInJSON elementInJSON) { try { using (var dc = new MySQLEntities()) { Guid idcustomers = new Guid(elementInJSON.idcustomers); var elementMySQL = dc.customers.Find(idcustomers); if (elementMySQL == null) { elementMySQL = dc.customers.Add(new customers()); } elementMySQL.idcustomers = new Guid(elementInJSON.idcustomers); elementMySQL.district = new Guid(elementInJSON.district); elementMySQL.name = elementInJSON.name; elementMySQL.phone = elementInJSON.phone; elementMySQL.privateAddress = elementInJSON.privateAddress; elementMySQL.publicAddress = elementInJSON.publicAddress; dc.SaveChanges(); } return(true); } catch { return(false); } }
public ActionResult IDataFillingWindow() { try { using (var dc = new MySQLEntities()) { //string Login = "******"; //var result = (from w in dc.usersdata // where w.User == Login // select w) as usersdata; string Login = "******"; var user = dc.usersdata.Find(Login); //user.BirthdateNew = user.Birthdate==null ? (DateTime) user.Birthdate : (DateTime) user.Birthdate; //try //{ // user.BirthdateAsString = user.Birthdate.ToString().Substring(0, user.Birthdate.ToString().Length - 8); //} //catch //{ // user.BirthdateAsString = ""; //} return(View(user)); } } catch { return(View()); } }
public ActionResult CustomerDetails(string idCustomersAsString) { try { using (var dc = new MySQLEntities()) { SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); ViewBag.Districts = districts; if (idCustomersAsString == "") { return(PartialView()); } Guid idCustomers = new Guid(idCustomersAsString); var elementMySQL = dc.customers.Find(idCustomers); return(PartialView(elementMySQL)); }; } catch (Exception ex) { return(HttpNotFound()); } }
public bool UpdateMasterInMySQL(MasterInJSON elementInJSON) { try { using (var dc = new MySQLEntities()) { Guid idMasters = new Guid(elementInJSON.idMasters); var elementMySQL = dc.masters.Find(idMasters); if (elementMySQL == null) { elementMySQL = dc.masters.Add(new masters()); } elementMySQL.idMasters = new Guid(elementInJSON.idMasters); elementMySQL.email = elementInJSON.email; elementMySQL.IdFirebase = elementInJSON.idFirebase; elementMySQL.name = elementInJSON.nameIn1C; elementMySQL.nameInMail = elementInJSON.nameInEmail; dc.SaveChanges(); } return(true); } catch { return(false); } }
public int UpdatePointsInDatabase(int seconds) { using (var dc = new MySQLEntities()) { var points = 4 * seconds; string Login = "******"; var user = dc.users.Find(Login); if (user == null) { user = dc.users.Add(user = new users { Login = "******", Points = points, }); } else { user.Points += points; } dc.SaveChanges(); return(user.Points); //TempData["points"] = user.Points; } }
public void UpdatePersonalDataInDatabase(string propertyName, string[] value) { //try //{ using (var dc = new MySQLEntities()) { string Login = "******"; var user = dc.usersdata.Find(Login); if (user == null) { user = dc.usersdata.Add(user = new usersdata { User = Login, }); } PropertyInfo propertyInfo = user.GetType().GetProperty(propertyName); if (propertyName == "Birthdate") { var newValue = DateTime.ParseExact(value[0], "dd.MM.yyyy", CultureInfo.CurrentCulture); propertyInfo.SetValue(user, newValue); } else { propertyInfo.SetValue(user, value[0]); } dc.SaveChanges(); } //} //catch (Exception ex) //{ //} }
public ActionResult OrderDetails(OrderAndTable model) { var order = model.order; using (var dc = new MySQLEntities()) { var orderInDb = dc.orders.Find(order.idOrders); if (orderInDb == null) { order.idOrders = Guid.NewGuid(); dc.orders.Add(order); dc.SaveChanges(); } else { //dc.Set<order>().AddOrUpdate(order); dc.Entry(orderInDb).CurrentValues.SetValues(order); dc.Entry(orderInDb).State = EntityState.Modified; dc.SaveChanges(); } } Thread.Sleep(1000); return(RedirectToAction("../Home/Index")); }
public JsonResult GetOrders() { using (var dc = new MySQLEntities()) { var query = (from o in dc.orders join m in dc.masters on o.Master equals m.idMasters into ps1 from m in ps1.DefaultIfEmpty() join wt in dc.worktypes on o.workType equals wt.idWorkTypes into ps2 from wt in ps2.DefaultIfEmpty() join c in dc.customers on o.Customer equals c.idcustomers into ps3 from c in ps3.DefaultIfEmpty() join d in dc.districts on o.District equals d.iddistricts into ps4 from d in ps4.DefaultIfEmpty() join s in dc.status on o.status equals s.idstatus into ps5 from s in ps5.DefaultIfEmpty() select new { orderNumber = o.orderNumber, idOrders = o.idOrders, formationDate = o.formationDate, customerName = c.name, workTypeName = wt.name, districtName = d.name, masterName = m.name, takenDate = o.takenDate, statusName = s.name, o.InitialAmount, o.TotalAmount, o.CustomerComment }) .AsEnumerable() .Select(i => new { i.orderNumber, i.idOrders, formationDate = String.Format("{0:dd/MM/yyyy hh:mm:ss}", i.formationDate), i.customerName, i.workTypeName, i.districtName, i.masterName, i.takenDate, i.statusName, i.InitialAmount, i.TotalAmount, i.CustomerComment } ) .OrderBy(a => a.formationDate); var result = query.ToArray(); //formationDate = String.Format("{0:dd/MM/yyyy hh:mm:ss}", o.formationDate), return(Json(result, JsonRequestBehavior.AllowGet)); } }
public bool RemoveElement(string elementType, string idElementAsString) { if (idElementAsString == "") { return(false); } idElementAsString = idElementAsString.Replace("[", "").Replace("]", "").Replace("\"", ""); string[] ids = idElementAsString.Split(new char[] { ',' }); try { using (var dc = new MySQLEntities()) { foreach (var item in ids) { switch (elementType) { case "works": Guid idWorks = new Guid(item); var elementMySQL1 = dc.works.Find(idWorks); dc.works.Remove(elementMySQL1); break; case "masters": Guid idMasters = new Guid(item); var elementMySQL2 = dc.masters.Find(idMasters); dc.masters.Remove(elementMySQL2); break; case "districts": Guid idDistricts = new Guid(item); var elementMySQL3 = dc.districts.Find(idDistricts); dc.districts.Remove(elementMySQL3); break; case "customers": Guid idCustomers = new Guid(item); var elementMySQL4 = dc.customers.Find(idCustomers); dc.customers.Remove(elementMySQL4); break; default: break; } } dc.SaveChanges(); return(true); }; } catch (Exception ex) { return(false); } }
public JsonResult GetWorktypes() { using (var dc = new MySQLEntities()) { var result = (from w in dc.worktypes select new { w.idWorkTypes, w.name }) .OrderBy(i => i.name).ToArray(); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult OrderDetails(string idOrdersAsString) { try { using (var dc = new MySQLEntities()) { SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); ViewBag.Districts = districts; SelectList statuses = new SelectList(dc.status.ToList(), "idstatus", "name"); ViewBag.Statuses = statuses; SelectList customers = new SelectList(dc.customers.ToList(), "idcustomers", "name"); ViewBag.Customers = customers; SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name"); ViewBag.Worktypes = worktypes; SelectList masters = new SelectList(dc.masters.ToList(), "idMasters", "name"); ViewBag.Masters = masters; SelectList works = new SelectList(dc.works.ToList(), "idWorks", "name"); ViewBag.Works = works; var order = new orders(); if (idOrdersAsString == "") { order.idOrders = Guid.NewGuid(); } else { Guid idOrders = new Guid(idOrdersAsString); order = dc.orders.Find(idOrders); } var model = new OrderAndTable(order) { order = order, }; return(PartialView(model)); }; } catch (Exception ex) { return(HttpNotFound()); } }
public bool UpdateOrderInMySQL(OrderInJSON order) { try { using (var dc = new MySQLEntities()) { Guid idOrders = new Guid(order.idOrders); var elementMySQL = dc.orders.Find(idOrders); if (elementMySQL == null) { elementMySQL = dc.orders.Add(new orders()); } elementMySQL.idOrders = new Guid(order.idOrders); elementMySQL.formationDate = DateTime.Parse(order.formationDate); elementMySQL.Customer = new Guid(order.customer); elementMySQL.workType = new Guid(order.workType); elementMySQL.CustomerComment = order.customerComment; elementMySQL.District = new Guid(order.district); elementMySQL.InitialAmount = order.initialAmount; elementMySQL.status = order.status; elementMySQL.orderNumber = order.orderNumber; if (order.master.IsEmpty()) { elementMySQL.Master = null; } else { masters masterInMySQL = dc.masters.SingleOrDefault(item => item.IdFirebase == order.master); elementMySQL.Master = masterInMySQL.idMasters; } elementMySQL.MasterComment = order.masterComment; elementMySQL.TotalAmount = order.totalAmount; //elementMySQL.Work = new Guid(order.work); // var newValue = DateTime.ParseExact(value[0], "yyyy-mm-dd", null); dc.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public JsonResult GetMasters() { using (var dc = new MySQLEntities()) { var result = (from w in dc.masters select new { w.idMasters, w.name, w.IdFirebase, w.email, w.nameInMail, w.deposit }) .OrderBy(i => i.name).ToArray(); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult DistrictDetails(districts district) { using (var dc = new MySQLEntities()) { if (district.iddistricts == Guid.Empty) { district.iddistricts = Guid.NewGuid(); dc.districts.Add(district); dc.SaveChanges(); } else { dc.Entry(district).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Districts")); }
public ActionResult WorktypeDetails(worktypes worktype) { using (var dc = new MySQLEntities()) { if (worktype.idWorkTypes == Guid.Empty) { worktype.idWorkTypes = Guid.NewGuid(); dc.worktypes.Add(worktype); dc.SaveChanges(); } else { dc.Entry(worktype).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Worktypes")); }
public ActionResult CustomerDetails(customers customer) { using (var dc = new MySQLEntities()) { if (customer.idcustomers == Guid.Empty) { customer.idcustomers = Guid.NewGuid(); dc.customers.Add(customer); dc.SaveChanges(); } else { dc.Entry(customer).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Customers")); }
public int GetPoints() { using (var dc = new MySQLEntities()) { var query = (from users in dc.users where users.Login == "Istur" select new { users.Points }); if (query.Count() == 0) { return(0); } else { return(query.First().Points); } } }
public JsonResult GetCustomers() { using (var dc = new MySQLEntities()) { var result = (from w in dc.customers join d in dc.districts on w.district equals d.iddistricts into ps4 from d in ps4.DefaultIfEmpty() select new { w.idcustomers, w.name, districtName = d.name, w.phone, w.privateAddress, w.publicAddress }) .OrderBy(i => i.name).ToArray(); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult WorktypeDetails(string idWorktypesAsString) { if (idWorktypesAsString == "") { return(PartialView()); } try { using (var dc = new MySQLEntities()) { Guid idWorkTypes = new Guid(idWorktypesAsString); var elementMySQL = dc.worktypes.Find(idWorkTypes); return(PartialView(elementMySQL)); }; } catch (Exception ex) { return(HttpNotFound()); } }
public ActionResult WorkDetails(works work) { using (var dc = new MySQLEntities()) { if (work.idWorks == Guid.Empty) { work.idWorks = Guid.NewGuid(); dc.works.Add(work); dc.SaveChanges(); } else { dc.Entry(work).State = EntityState.Modified; dc.SaveChanges(); } } return(RedirectToAction("Works")); //if (idWorksAsString == null) //{ // return HttpNotFound(); //} //try //{ // using (var dc = new MySQLEntities()) // { // Guid idWorks = new Guid(idWorksAsString); // var elementMySQL = dc.works.Find(idWorks); // return PartialView(elementMySQL); // }; //} //catch (Exception ex) //{ //return HttpNotFound(); //} }
public ActionResult MasterDetails(string idMastersAsString) { try { using (var dc = new MySQLEntities()) { //SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name"); //ViewBag.Districts = districts; //SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name"); //ViewBag.Worktypes = worktypes; var master = new masters(); if (idMastersAsString == "") { master.idMasters = Guid.NewGuid(); } else { Guid idMasters = new Guid(idMastersAsString); master = dc.masters.Find(idMasters); } var model = new MasterAndTable(master) { master = master, }; ViewBag.districtsmaster = model.districtsmaster; return(PartialView(model)); }; } catch (Exception ex) { return(HttpNotFound()); } }
public WebAPIController() { context = new MySQLEntities(); }
//------------------------------------------------------------------------- public ActionResult Details(string id) { //if (id == null) //{ // return HttpNotFound(); //} //try //{ // using (var dc = new MyDatabaseEntities()) // { // var request = (from emp in dc.Employees // join pos in dc.Positions on emp.PositionID equals pos.IDPosition // join dp in dc.Departments on emp.DepartmentID equals dp.IDDepartment // join block in dc.Departments on dp.ParentID equals block.IDDepartment into blockvr // from block in blockvr.DefaultIfEmpty() // join div in dc.Departments on emp.DivisionID equals div.IDDepartment // join org in dc.Organizations on emp.OrganizationID equals org.IDOrganization // join empPhoto in dc.EmployeePhotoes on emp.EmployeePhotoID equals empPhoto.IDEmployeePhoto into ps // from empPhoto in ps.DefaultIfEmpty() // where emp.IDEmployee == id // select new // { // emp.IDEmployee, // emp.LastName, // emp.FirstName, // emp.MiddleName, // emp.Phones, // emp.Office, // emp.Floor, // emp.Room, // emp.Code, // emp.Birthday, // PositionName = pos.Name, // DepartmentName = dp.Name, // BlockName = block.Name, // DivizionName = div.Name, // OrganizationName = org.Name, // Photo = empPhoto.Photo, // }); // var v = request.First(); // var edm = new EmployeeDetailsModel(); // edm.IDEmployee = v.IDEmployee; // edm.FirstName = v.FirstName; // edm.LastName = v.LastName; // edm.MiddleName = v.MiddleName; // edm.Office = v.Office; // edm.Floor = v.Floor; // edm.Room = v.Room; // edm.Code = v.Code; // edm.PositionName = v.PositionName; // edm.DepartmentName = v.DepartmentName; // edm.BlockName = v.BlockName; // edm.DivizionName = v.DivizionName; // edm.OrganizationName = v.OrganizationName; // edm.Birthday = v.Birthday == null ? "" : ((DateTime) v.Birthday).ToString("dd MMMM"); // edm.Code = edm.Code.Replace(" ", string.Empty); // edm.Photo = v.Photo; // edm.Phones = v.Phones == null ? new string[0] : XElement.Parse(v.Phones).Elements("i").Select(i => (string) i.Attribute("num")).ToArray(); // //ICollection<Phone> phones = dc.Phones.Where(a => a.EmployeeID == id).OrderBy(a => a.LineNumber).ToList(); var db = new MySQLEntities(); SelectList masters = new SelectList(db.masters, "idMasters", "name"); ViewBag.Masters = masters; return(PartialView()); // } // } // #pragma warning disable CS0168 // The variable 'ex' is declared but never used // catch (Exception ex) // #pragma warning restore CS0168 // The variable 'ex' is declared but never used // { // return HttpNotFound(); //} }