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();
//}
}
