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 bool AddUserToExpertise(int expertiseId, int userId)
{
t_Expertise expertise = _db.t_Expertise.SingleOrDefault(s => s.ExpertiseId == expertiseId);
if (expertise != null)
{
t_User userNew = _db.t_User.Find(userId);
if (userNew != null)
{
expertise.t_User.Add(userNew);
_db.SaveChanges();
return(true);
}
return(false);
}
return(false);
}
public bool ReplaceUserForExpertise(int expertiseId, int userId)
{
t_Expertise expertise = _db.t_Expertise.SingleOrDefault(s => s.ExpertiseId == expertiseId);
if (expertise != null)
{
t_User userOld = _db.t_Expertise.Find(expertiseId).t_User.FirstOrDefault();
if (userOld != null)
{
expertise.t_User.Remove(userOld);
_db.SaveChanges();
}
t_User userNew = _db.t_User.Find(userId);
if (userNew != null)
{
expertise.t_User.Add(userNew);
_db.SaveChanges();
return(true);
}
return(false);
}
return(false);
}
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));
}
