public ActionResult UserSave(UserViewModel model)
{
using (DBEPREntities db = new DBEPREntities())
{
if (model.ID > 0)
{
USER user = db.USERS.SingleOrDefault(p => p.IsDeleted == false && p.ID == model.ID);
if (user != null)
{
user.ID = model.ID;
db.SaveChanges();
}
}
else
{
USER u = new USER();
u.Username = model.Username;
u.Name = model.Name;
u.Password = "******";//model.Password;
u.Email = model.Email;
u.Status = model.Status;
u.UzautosupplierID = model.UzautosupplierID;
u.Department = model.Department;
u.JobTitle = model.JobTitle;
u.Telephone = model.Telephone;
db.USERS.Add(u);
db.SaveChanges();
}
return(RedirectToAction("Users"));
}
}
public ActionResult MachinesSave(MachinesViewModel model)
{
using (DBEPREntities db = new DBEPREntities())
{
if (model.ID > 0)
{
MACHINE machine = db.MACHINES.SingleOrDefault(m => m.IsDeleted == false && m.ID == model.ID);
if (machine != null)
{
machine.Name = model.Name;
machine.Description = model.Description;
machine.Lifespan = model.Lifespan;
machine.InstalledDate = model.InstalledDate;
machine.PartNumber = model.PartNumber;
if (model.Status)
{
machine.IsActive = true;
}
else
{
machine.IsActive = false;
}
machine.ManufacturerID = model.ManufacturerID;
machine.UzAutoSupplierID = model.UzAutoSupplierID;
machine.TypeID = model.TypeID;
db.SaveChanges();
}
}
else
{
MACHINE machine = new MACHINE();
machine.Name = model.Name;
machine.Description = model.Description;
machine.Lifespan = model.Lifespan;
machine.InstalledDate = model.InstalledDate;
machine.PartNumber = model.PartNumber;
if (model.Status)
{
machine.IsActive = true;
}
else
{
machine.IsActive = false;
}
machine.ManufacturerID = model.ManufacturerID;
machine.UzAutoSupplierID = model.UzAutoSupplierID;
machine.TypeID = model.TypeID;
machine.IsDeleted = false;
db.MACHINES.Add(machine);
db.SaveChanges();
}
return(RedirectToAction("Machines"));
}
}
public JsonResult MachinesDelete(int machineID)
{
bool result = false;
using (DBEPREntities db = new DBEPREntities())
{
MACHINE machine = db.MACHINES.SingleOrDefault(m => m.IsDeleted == false && m.ID == machineID);
if (machine != null)
{
machine.IsDeleted = true;
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult PartsDelete(int partID)
{
bool result = false;
using (DBEPREntities db = new DBEPREntities())
{
PART part = db.PARTS.SingleOrDefault(p => p.IsDeleted == false && p.ID == partID);
if (part != null)
{
part.IsDeleted = true;
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult PartsSave(PartsViewModel model)
{
///////////////////////////////////////////
string connetionString;
SqlConnection cnn;
connetionString = @"Data Source=89.236.217.150;Initial Catalog=DBEPR;User ID=EPRuser;Password=Zxcv!123";
cnn = new SqlConnection(connetionString);
cnn.Open();
string sql = @"INSERT INTO testtable (id,test) VALUES ('xxxx','ZZZ')";
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
cnn.Close();
////////////////////////////////////////////
///
using (DBEPREntities db = new DBEPREntities())
{
if (model.ID > 0)
{
PART part = db.PARTS.SingleOrDefault(p => p.IsDeleted == false && p.ID == model.ID);
if (part != null)
{
part.ID = model.ID;
part.Name = model.Name;
part.NameRus = model.NameRus;
part.Description = model.Description;
part.DescriptionRus = model.DescriptionRus;
part.Code = model.DescriptionRus;
part.Currency = model.Currency;
part.Manufactured_Date = model.Manufactured_Date;
part.Modeli = model.Modeli;
part.OEMPartNumber = model.OEMPartNumber;
part.Price = model.Price;
part.SerialNumber = model.SerialNumber;
part.TechData = model.TechData;
part.Type = model.Type;
part.Unit = model.Unit;
part.MachineID = model.MachineID;
part.ManufacturerID = model.ManufacturerID;
part.SupplierID = model.SupplierID;
part.OEMID = model.OEMID;
part.UzAutoSupplierID = model.UzAutoSupplierID;
db.SaveChanges();
}
}
else
{
PART p = new PART();
p.Code = model.Code;
p.Description = model.Description;
p.DescriptionRus = model.DescriptionRus;
p.MachineID = model.MachineID;
p.SupplierID = model.SupplierID;
p.OEMID = model.OEMID;
p.ManufacturerID = model.ManufacturerID;
p.UzAutoSupplierID = model.UzAutoSupplierID;
p.PartNumber = model.PartNumber;
p.OEMPartNumber = model.OEMPartNumber;
//p.NamePlate = model.NamePlate;
p.Name = model.Name;
p.NameRus = model.NameRus;
p.Modeli = model.Modeli;
p.Type = model.Type;
p.SerialNumber = model.SerialNumber;
p.Manufactured_Date = model.Manufactured_Date;
p.TechData = model.TechData;
p.Unit = model.Unit;
p.Price = model.Price;
p.Currency = model.Currency;
p.IsDeleted = false;
db.PARTS.Add(p);
db.SaveChanges();
}
return(View(model));
}
}
