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