public ActionResult FormDetail(int id) { try { using (DataService db = new DataService()) { var form = db.Context.ServiceForms.FirstOrDefault(x => x.ID == id); var model = new ServiceFormModel { Company = form.Company, //ServisTipi = form.ServiceType.Name, StartDate = form.StartDate, EndDate = form.EndDate, //Employee = form.Employee, ServiceDetails = form.ServiceDetails //Adam_Gun = form.Adam_Gun }; return(View(model)); } } catch (Exception ex) { return(null); } }
public ActionResult Service() { try { using (DataService db = new DataService()) { var pageModel = new ServiceFormModel { Companies = db.Context.Companies.ToList(), CompanyEmployees = db.Context.CompEmployees.ToList() //CompanyName = "Şirket Adı", //EmployeeName = "Çalışan Adı", //CompAddress = "Adres", //CompCity = "Şehir", //CompPostalCode = 1, //CompFaxNumber = 1, //CompPhoneNumber = 1, //CompEmail = "*****@*****.**", //AdamGun = 2, //Description = "Servis Açıklaması", //StartDate = DateTime.Now, //EndDate = DateTime.Now, //ServisTipi = Models.ServiceType.Arıza }; return(View(pageModel)); } } catch (Exception ex) { return(null); } }
public JsonResult CompanySelection(ServiceFormModel model, int ID) { try { using (DataService db = new DataService()) { model.Address = db.Context.Companies.SingleOrDefault(x => x.ID == ID).Address; var oper = db.Context.CompEmployees.AsQueryable(); oper = oper.Where(x => x.CompanyID == ID); //CompEmpModel[] coEmp = new CompEmpModel() { // ID=oper.Select(x.ID), //}; model.aaData = oper.Select(x => new CompEmpModel() { ID = x.ID, Name = x.Name, LastName = x.LastName, id = x.ID, text = x.Name + " " + x.LastName }).ToArray(); //for (int i = 0; i <oper.Length; i++) //{ // model.CoEmpId[i] = oper[i].ID; // model.ComEmp[i] = oper[i].Name + " " + oper[i].LastName; //} //model.CompE = coEmp; //for (int i = 0; i < coEmp.Length; i++) //{ // model.CoEmpId.Add(coEmp[i].ID); // model.ComEmp.Add(coEmp[i].Name + " " + coEmp[i].LastName); //} //foreach (var item in coEmp) //{ // model.CoEmpId.Add(item.ID); // model.ComEmp.Add(item.Name + " " + item.LastName); //} } } catch (Exception ex) { } return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult GetServiceForm(ServiceFormModel model, int ID) { try { using (DataService db = new DataService()) { var form = db.Context.ServiceForms.SingleOrDefault(x => x.ID == ID); var emp = db.Context.EmployeeDetails.SingleOrDefault(x => x.ID == form.EmployeeID); var coEmp1 = db.Context.CompEmployees.SingleOrDefault(x => x.ID == form.CompEmp1ID); var coEmp2 = db.Context.CompEmployees.SingleOrDefault(x => x.ID == form.CompEmp2ID); model.ID = form.ID; model.IsArıza = form.IsArıza; model.IsBakım = form.IsBakım; model.IsDelivering = form.IsDelivering; model.IsDevreyeAlma = form.IsDevreyeAlma; model.IsEducate = form.IsEducate; model.IsFirsManint = form.IsFirsManint; model.IsFree = form.IsFree; model.IsMeeting = form.IsMeeting; model.IsMontage = form.IsMontage; model.IsSecondMaint = form.IsSecondMaint; model.IsSupervice = form.IsSupervice; model.IsThirdMaint = form.IsThirdMaint; model.IsWarrantied = form.IsWarrantied; model.HVAC = form.HVAC; model.JobDescription = form.JobDescription; model.SerialNo = form.SerialNo; model.ServiceDetails = form.ServiceDetails; model.EndDate = form.EndDate; model.EmployeeName = emp.Name + " " + emp.LastName; model.CoEmp1 = coEmp1.Name; model.CoEmp2 = coEmp2.Name; } } catch (Exception ex) { return(null); } return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveServiceForm(ServiceFormModel Data) { var resultModel = new JsonResultModel <ServiceFormModel>(); var cookie = HttpContext.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); var gCode = Guid.Parse(ticket.UserData); try { using (DataService db = new DataService()) { var serviceForm = new ServiceForm(); var user = db.Context.Membership_User.FirstOrDefault(x => x.UserCode == gCode); serviceForm.CompanyID = Data.CompanyID; serviceForm.CompEmp1ID = Data.CompEmp1ID; serviceForm.CompEmp2ID = Data.CompEmp2ID; serviceForm.EmployeeID = user.ID; serviceForm.IsArıza = Data.IsArıza; serviceForm.IsBakım = Data.IsBakım; serviceForm.IsDelivering = Data.IsDelivering; serviceForm.IsDevreyeAlma = Data.IsDevreyeAlma; serviceForm.IsEducate = Data.IsEducate; serviceForm.IsFirsManint = Data.IsFirsManint; serviceForm.IsFree = Data.IsFree; serviceForm.IsMeeting = Data.IsMontage; serviceForm.IsSecondMaint = Data.IsSecondMaint; serviceForm.IsSupervice = Data.IsSupervice; serviceForm.IsThirdMaint = Data.IsThirdMaint; serviceForm.IsWarrantied = Data.IsWarrantied; serviceForm.IsMontage = Data.IsMontage; serviceForm.HVAC = Data.HVAC; serviceForm.JobDescription = Data.JobDescription; //serviceForm.SerialNo = Data.SerialNo; serviceForm.ServiceDetails = Data.ServiceDetails; serviceForm.StartDate = Data.StartDate; serviceForm.EndDate = Data.EndDate; //var compAdress = db.Context.Companies.FirstOrDefault(y => y.ID == Data.CompanyID).Address; //Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); //Microsoft.Office.Interop.Excel.Workbook sheet = excel.Workbooks.Open("/Content/ServiceFormTemplate.xlsx"); //Microsoft.Office.Interop.Excel.Worksheet z = excel.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet; //Excel.Range userRange = z.UsedRange; //userRange.Replace("", compAdress); //userRange.Replace("", ""); //sheet.SaveAs("YeniForm.pdf"); //return sheet; //System.IO.MemoryStream memory = new System.IO.MemoryStream(); //byte[] bytes= System.Text.Encoding.UTF8.GetBytes(sheet); //RedirectToAction("ReturnPdf", ID) db.Context.ServiceForms.Add(serviceForm); db.Context.SaveChanges(); resultModel.Status = JsonResultType.Success; resultModel.Message = "Yeni Sipariş Kaydedildi"; } } catch (Exception) { } return(Json(resultModel, JsonRequestBehavior.AllowGet)); }