public DecisionMessage(int EquipmentID)
{
db = new TExpEntities();
Equipment = db.t_Equipment.Find(EquipmentID);
Message = db.t_Message.FirstOrDefault();
CostOfRepair = db.t_CostOfRepair.Find(EquipmentID);
}
// POST: api/Equipment
public IHttpActionResult Post([FromBody] EquipmentModelInput equipmentModelInput)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
#if DEBUG
Debug.WriteLine("Model is valid!");
Debug.WriteLine("equipmentModelInput.Name=" + equipmentModelInput.Name);
Debug.WriteLine("equipmentModelInput.Price=" + equipmentModelInput.Price.ToString());
#endif
t_Equipment equipment = new t_Equipment();
equipment.EquipmentId = 0;
equipment.InventoryNumber = equipmentModelInput.InventoryNumber;
equipment.MaterialAccount = equipmentModelInput.MaterialAccount;
equipment.MOL = equipmentModelInput.MOL;
equipment.Name = equipmentModelInput.Name;
equipment.Price = equipmentModelInput.Price;
equipment.SerialNumber = equipmentModelInput.SerialNumber;
equipment.StartupDate = Convert.ToDateTime(equipmentModelInput.StartupDate);
//equipment.StartupDate = (System.DateTime?) DateTime.Parse(equipmentModelInput.StartupDate).ToShortDateString();
db.t_Equipment.Add(equipment);
db.SaveChanges();
return(Ok());
}
public IHttpActionResult Put(int id, [FromBody] EquipmentModelInput equipmentModelInput)
{
#if DEBUG
Debug.WriteLine("I'm in PUT");
#endif
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
#if DEBUG
Debug.WriteLine("Put id=" + id.ToString());
#endif
t_Equipment equipment = new t_Equipment();
equipment.EquipmentId = equipmentModelInput.EquipmentId;
equipment.InventoryNumber = equipmentModelInput.InventoryNumber;
equipment.MaterialAccount = equipmentModelInput.MaterialAccount;
equipment.MOL = equipmentModelInput.MOL;
equipment.Name = equipmentModelInput.Name;
equipment.Price = equipmentModelInput.Price;
equipment.SerialNumber = equipmentModelInput.SerialNumber;
equipment.StartupDate = Convert.ToDateTime(equipmentModelInput.StartupDate);
db.Entry(equipment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DBConcurrencyException)
{
#if DEBUG
Debug.WriteLine("Catch is occuried!");
#endif
return(NotFound());
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Put(int id, DecommissionModel decommission)
{
t_Equipment equipment = db.t_Equipment.Find(id);
if (equipment == null)
{
return(NotFound());
}
equipment.DateOfDecommission = decommission.DateOfDecommission;
equipment.Decommission = decommission.StateOfDecommission;
db.Entry(equipment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DBConcurrencyException)
{
#if DEBUG
Debug.WriteLine("Catch is occuried!");
#endif
return(NotFound());
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage Get(int id)
{
PDFDocument pdfDocument = new PDFDocument();
t_Expertise expertise = _db.t_Expertise.Find(id);
if (expertise != null)
{
if (expertise.DateExp == null)
{
expertise.DateExp = DateTimeOffset.Now;
}
pdfDocument.DateExp = expertise.DateExp.Value.ToString("d");
pdfDocument.Conclusion = expertise.Conclusion;
pdfDocument.IsForWriteoff = expertise.IsForWriteoff;
pdfDocument.IsOrganizationRepair = expertise.IsOrganizationRepair;
pdfDocument.IsPartsSupply = expertise.IsPartsSupply;
pdfDocument.IsServiceable = expertise.IsServiceable;
pdfDocument.IsServiceableEquipment = expertise.IsServiceableEquipment;
pdfDocument.IsWarrantyRepair = expertise.IsWarrantyRepair;
pdfDocument.NumberExp = expertise.NumberExp;
pdfDocument.Reason = expertise.Reason;
pdfDocument.RequestId = expertise.RequestId;
pdfDocument.Staff = expertise.Staff;
pdfDocument.Staff2 = expertise.Staff2;
t_Equipment equipment = expertise.t_Equipment.FirstOrDefault();
if (equipment != null)
{
pdfDocument.InventoryNumber = equipment.InventoryNumber;
pdfDocument.SerialNumber = equipment.SerialNumber;
pdfDocument.StartupDate = equipment.StartupDate.Value.Year.ToString(); //.ToShortDateString();
pdfDocument.Name = equipment.Name;
}
t_User user = expertise.t_User.FirstOrDefault();
if (user != null)
{
pdfDocument.ImgData = user.Sign;
}
}
MemoryStream stream = new MemoryStream(pdfDocument.GetPDFDocument());
HttpResponseMessage result = new HttpResponseMessage(statusCode: HttpStatusCode.OK);
result.Content = new StreamContent(stream);
result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/pdf");
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
result.Content.Headers.ContentDisposition.FileName = pdfDocument.GetFileName() + ".pdf";
//var transactionViewQuerable = (IQueryable<TransactionFileReportModel>)queryOptions.ApplyTo(transactionView);
return(result); // await transactionViewQuerable.ToArrayAsync();
}
public IHttpActionResult Get(int id)
{
DecommissionModel decommission = new DecommissionModel();
t_Equipment equipment = db.t_Equipment.Find(id);
if (equipment == null)
{
return(NotFound());
}
decommission.StateOfDecommission = equipment.Decommission;
decommission.DateOfDecommission = equipment.DateOfDecommission;
return(Ok(decommission));
}
public EquipmentTypeOfEquipmentModel Get(int id)
{
t_Equipment equipment = new t_Equipment();
equipment = db.t_Equipment.Find(id);
EquipmentModel equipmentModel = db.t_Equipment.Where(w => w.EquipmentId == id).Select(s => new EquipmentModel()
{
Name = s.Name, StartupDate = s.StartupDate, Price = s.Price, InventoryNumber = s.InventoryNumber, SerialNumber = s.SerialNumber
}).FirstOrDefault();
selectTypeOfEquipmentModel selectedTypeOfEquipment = equipment.t_TypeOfEquipment.Select(s => new selectTypeOfEquipmentModel()
{
TypeId = s.TypeId, Name = s.Name
}).FirstOrDefault(); //).AsQueryable(); //.Join(db.t_TypeOfEquipment, sw => sw.TypeId, s => s.TypeId, (sw, s) => s.TypeId).FirstOrDefault();
//Debug.WriteLine("selectedTypeOfEquipment=" + selectedTypeOfEquipment.ToString());
EquipmentTypeOfEquipmentModel equipmentTypeOfEquipmentModel = new EquipmentTypeOfEquipmentModel();
equipmentTypeOfEquipmentModel.equipment = equipmentModel;
equipmentTypeOfEquipmentModel.selectTypeOfEquipment = selectedTypeOfEquipment;
return(equipmentTypeOfEquipmentModel);
}
public void Put(int id, int typeId)
{
t_Equipment equipment = db.t_Equipment.Find(id);
var selectedEquipments = equipment.t_TypeOfEquipment.ToList();
if (selectedEquipments != null)
{
foreach (t_TypeOfEquipment selectedEquipment in selectedEquipments)
{
equipment.t_TypeOfEquipment.Remove(selectedEquipment);
db.SaveChanges();
}
}
t_TypeOfEquipment typeOfEquipment = db.t_TypeOfEquipment.Find(typeId);
if (typeOfEquipment != null)
{
equipment.t_TypeOfEquipment.Add(typeOfEquipment);
db.SaveChanges();
}
}
public EquipmentMalfunctionModel Get(int id, int equipmentId)
{
EquipmentMalfunctionModel equipmentMalfunction = new EquipmentMalfunctionModel();
//t_Malfunction malfunction; // = new malfunction();
t_TypeOfEquipment typeOfEquipment = db.t_TypeOfEquipment.Where(w => w.TypeId == id).FirstOrDefault();
t_Equipment equipment = db.t_Equipment.Find(equipmentId);
#if DEBUG
Debug.WriteLine("typeOfEquipment.Name=" + typeOfEquipment.Name + " typeOfEquipment.TypeId=" + typeOfEquipment.TypeId.ToString());
#endif
//typeOfEquipmentMalfunction.Malfunctions= (malfunction.t_TypeOfEquipment.Where(s => s.TypeId == id)).ToList();
//typeOfEquipmentMalfunction.selectedMalfunctions = (typeOfEquipment.ref_Malfunction).ToList();
IList <int> typeOfEquipments = (equipment.t_Malfunction.Join(db.t_Malfunction, sw => sw.FaultId, s => s.FaultId, (sw, s) => s.FaultId).ToList());
#if DEBUG
Debug.WriteLine("typeOfEquipments.count=" + typeOfEquipments.Count.ToString());
#endif
equipmentMalfunction.selectedMalfunctions = db.t_Malfunction.Where(w => typeOfEquipments.Contains(w.FaultId)).Select(s => new MalfunctionModel()
{
FaultId = s.FaultId, Name = s.Name
}).ToList();
//typeOfEquipmentMalfunction.selectedMalfunctions = (from m in db.t_Malfunction where typeOfEquipments.Contains(m.FaultId) select new t_Malfunction() {FaultId=m.FaultId,Name=m.Name }).ToList(); //typeOfEquipments.Contains(1)
equipmentMalfunction.Malfunctions = typeOfEquipment.t_Malfunction.Select(s => new MalfunctionModel()
{
FaultId = s.FaultId, Name = s.Name
}).ToList(); //db.t_Malfunction.ToList(); .Select(s => new t_Malfunction() { FaultId = s.FaultId, Name = s.Name })
//equipmentMalfunction.TypeId = id;
//typeOfEquipmentMalfunction.Malfunctions = db.t_TypeOfEquipment;
#if DEBUG
Debug.WriteLine("Начало выбора Malfunction");
foreach (MalfunctionModel item in equipmentMalfunction.selectedMalfunctions)
{
Debug.WriteLine("FaultId={0},Name={1}", item.FaultId.ToString(), item.Name);
}
#endif
return(equipmentMalfunction);
}
public EquipmentMalfunctionOps(int EquipmentID)
{
db = new TExpEntities();
Equipment = db.t_Equipment.Find(EquipmentID);
}
public ExpertiseModel Get(int id, int expertiseId)
{
ExpertiseModel expertise = db.t_Expertise.Where(w => w.ExpertiseId == expertiseId).Select(s => new ExpertiseModel()
{
ExpertiseId = s.ExpertiseId, Staff = s.Staff, Reason = s.Reason,
Conclusion = s.Conclusion, NumberExp = s.NumberExp, DateExp = s.DateExp,
RequestId = s.RequestId,
Staff2 = s.Staff2,
IsServiceableEquipment = s.IsServiceableEquipment,
IsWarrantyRepair = s.IsWarrantyRepair,
IsOrganizationRepair = s.IsOrganizationRepair,
IsPartsSupply = s.IsPartsSupply,
IsServiceable = s.IsServiceable,
IsForWriteoff = s.IsForWriteoff
}).FirstOrDefault();
if (expertise == null)
{
expertise = new ExpertiseModel();
//expertise.ExpertiseId = id;
StringBuilder nameOfMalfunctions = new StringBuilder();
t_Equipment equipment = db.t_Equipment.Find(id);
IEnumerable <string> malfunctions = equipment.t_Malfunction.Select(s => s.Name).ToList();
//nameOfMalfunctions.Append("Выявлены неисправности следующих деталей:\n");
foreach (string Name in malfunctions)
{
nameOfMalfunctions.Append(Name + "\n");
}
expertise.Reason = nameOfMalfunctions.ToString();
DecisionMessage decisionMessage = new DecisionMessage(id);
expertise.Conclusion = decisionMessage.Text;
expertise.NumberExp =
db.t_Message.Select(s => s.LastNumber + 1).FirstOrDefault();
expertise.DateExp = DateTimeOffset.Now;
// insert Position and FIO of staff
var user = _userManager.FindByName(_userName);
if (user != null)
{
expertise.Staff = user.Position + " " + user.FIO;
}
}
/*else
* {
* expertise.NumberExp =
* db.t_Message.Select(s => s.LastNumber).FirstOrDefault();
* expertise.DateExp = DateTime.Today;
* }*/
if (expertise != null && String.IsNullOrWhiteSpace(expertise.Conclusion))
{
DecisionMessage decisionMessage = new DecisionMessage(id);
expertise.Conclusion = decisionMessage.Text;
}
if (expertise != null && String.IsNullOrWhiteSpace(expertise.Reason))
{
StringBuilder nameOfMalfunctions = new StringBuilder();
t_Equipment equipment = db.t_Equipment.Find(id);
IEnumerable <string> malfunctions = equipment.t_Malfunction.Select(s => s.Name).ToList();
//nameOfMalfunctions.Append("Выявлены неисправности следующих деталей:\n");
foreach (string Name in malfunctions)
{
nameOfMalfunctions.Append(Name + "\n");
}
expertise.Reason = nameOfMalfunctions.ToString();
}
// Изменить ИД пользователя на другого в t_UserExpertise
if (expertise != null && String.IsNullOrWhiteSpace(expertise.Staff))
{
/* var user = db.t_User.SingleOrDefault(w => w.UserName == _userName);
* if (user != null)
* {
* expertise.Staff = user.Position + " " + user.FIO;
*
* var expertiseUser = db.t_Expertise.Find(expertiseId).t_User.FirstOrDefault();
*
* if (expertiseUser != null)
* {
* db.t_Expertise.Find(expertiseId).t_User.Remove(expertiseUser);
* db.SaveChanges();
* db.t_Expertise.Find(expertiseId).t_User.Add(user);
* db.SaveChanges();
* }
* }*/
var user = _userManager.FindByName(_userName);
ExpertiseUser expertiseUser = new ExpertiseUser();
if (expertiseUser.ReplaceUserForExpertise(expertiseId, user.UserID))
{
expertise.Staff = user.Position + " " + user.FIO;
}
}
return(expertise);
}
public IHttpActionResult Put(int id, ExpertiseModel expertiseModel)
{
#if DEBUG
Debug.WriteLine(String.Format("Id={0},Staff={1}", expertiseModel.ExpertiseId.ToString(), expertiseModel.Staff));
#endif
//ExpertiseModel expertise = db.t_Expertise.Where(w => w.EquipmentId == expertiseModel.EquipmentId).Select(s => new ExpertiseModel() {EquipmentId=s.EquipmentId,Staff=s.Staff,Reason=s.Reason,Conclusion=s.Conclusion }).FirstOrDefault();
t_Expertise expertise = db.t_Expertise.Find(expertiseModel.ExpertiseId);
//t_Expertise expertise = db.t_Expertise.Find(id);
// if expertise is null then new act of expertise
if (expertise == null)
{
expertise = new t_Expertise();
//expertise.EquipmentId = id;
expertise.Conclusion = expertiseModel.Conclusion;
expertise.Reason = expertiseModel.Reason;
expertise.Staff = expertiseModel.Staff; //user
expertise.NumberExp = expertiseModel.NumberExp;
#if DEBUG
Debug.WriteLine("expertise == null expertiseModel.DateExp=" + expertiseModel.DateExp);
//Debug.WriteLine(DateTimeOffset.Parse(expertiseModel.DateExp).ToString());
#endif
expertise.DateExp = expertiseModel.DateExp; //new DateTimeOffset()
expertise.Staff2 = expertiseModel.Staff2; // customer
expertise.RequestId = expertiseModel.RequestId;
#if DEBUG
Debug.WriteLine("expertiseModel.IsServiceableEquipment=" + expertiseModel.IsServiceableEquipment.ToString());
//Debug.WriteLine("^^^^^ FIO=" + user.FIO);
#endif
expertise.IsServiceableEquipment = expertiseModel.IsServiceableEquipment;
expertise.IsWarrantyRepair = expertiseModel.IsWarrantyRepair;
expertise.IsOrganizationRepair = expertiseModel.IsOrganizationRepair;
expertise.IsPartsSupply = expertiseModel.IsPartsSupply;
expertise.IsServiceable = expertiseModel.IsServiceable;
expertise.IsForWriteoff = expertiseModel.IsForWriteoff;
db.t_Expertise.Add(expertise);
db.SaveChanges();
db.Entry(expertise).GetDatabaseValues();
t_Equipment equipment = db.t_Equipment.Find(id);
if (equipment != null)
{
equipment.t_Expertise.Add(expertise);
db.SaveChanges();
}
#if DEBUG
else
{
Debug.WriteLine("equipment is null!");
}
#endif
// fill table t_UserExpertise
var user = _userManager.FindByName(_userName);
if (user != null)
{
ExpertiseUser expertiseUser = new ExpertiseUser();
expertiseUser.AddUserToExpertise(expertise.ExpertiseId, user.UserID);
}
#if DEBUG
else
{
Debug.WriteLine("user is null!");
}
#endif
try
{
t_Message message = db.t_Message.FirstOrDefault();
if (message != null)
{
message.LastNumber = expertiseModel.NumberExp;
db.Entry(message).State = EntityState.Modified;
db.SaveChanges();
}
#if DEBUG
else
{
Debug.WriteLine("message is null");
}
#endif
}
catch (Exception)
{
throw;
}
}
else
{
expertise.Conclusion = expertiseModel.Conclusion;
expertise.Reason = expertiseModel.Reason;
expertise.Staff = expertiseModel.Staff;
expertise.NumberExp = expertiseModel.NumberExp;
expertise.DateExp = expertiseModel.DateExp;
expertise.Staff2 = expertiseModel.Staff2;
expertise.RequestId = expertiseModel.RequestId;
expertise.IsServiceableEquipment = expertiseModel.IsServiceableEquipment;
expertise.IsWarrantyRepair = expertiseModel.IsWarrantyRepair;
expertise.IsOrganizationRepair = expertiseModel.IsOrganizationRepair;
expertise.IsPartsSupply = expertiseModel.IsPartsSupply;
expertise.IsServiceable = expertiseModel.IsServiceable;
expertise.IsForWriteoff = expertiseModel.IsForWriteoff;
db.Entry(expertise).State = EntityState.Modified;
db.SaveChanges();
}
return(StatusCode(HttpStatusCode.NoContent));
}
