public ActionResult InventoryAdminONM() { List <string> status = new List <string>() { "COMPLETED", "PARTIALLY COMPLETED" }; ViewBag.Status = status; List <OperationAndMaintenanceModel> oNmList = new List <OperationAndMaintenanceModel>(); var invOnM = db.tbl_OandM.Where(o => o.Status == "PARTIALLY APPROVED").Select(o => o).Distinct().ToList(); foreach (var item in invOnM) { OperationAndMaintenanceModel oNm = new OperationAndMaintenanceModel(); var empId = Convert.ToInt32(item.AssignedTo); oNm.AssignedEmployee = db.tbl_employee.Where(e => e.EmployeeID == empId).Select(e => e.EmployeeName).FirstOrDefault(); oNm.BeneficiaryName = item.tbl_beneficiary.BeneficiaryName; oNm.Block = item.tbl_beneficiary.Block; oNm.CompletionDate = item.DateOfCompletion; oNm.Contact = item.tbl_beneficiary.ContactNo; oNm.District = item.tbl_beneficiary.District; oNm.ProblemDescription = item.ProblemType; oNm.ReportedDate = item.ProblemreportedOn; oNm.Status = item.Status; oNm.SystemCapacity = item.tbl_beneficiary.systemCapacity; oNm.Village = item.tbl_beneficiary.Village; oNm.WorkOrderNo = item.WorkOrderID; oNmList.Add(oNm); } return(View(oNmList)); }
public void ExportToExcelOandM() { DataTable dt = new DataTable(); dt.TableName = "tbl_OandM"; //List<OperationAndMaintenanceModel> oNmList = OperationAndMaintenanceModel.Deserialize(modelString); List <OperationAndMaintenanceModel> ONMModel = TempData["ONMList"].CastTo <List <OperationAndMaintenanceModel> >(); var beneficiaryDetails = db.tbl_beneficiary.Select(b => b).ToList(); List <OperationAndMaintenanceModel> downloadONMList = new List <OperationAndMaintenanceModel>(); foreach (var item in ONMModel) { OperationAndMaintenanceModel mntnceDetails = new OperationAndMaintenanceModel(); mntnceDetails.AssignedEmployee = item.AssignedEmployee; mntnceDetails.BeneficiaryName = item.BeneficiaryName; mntnceDetails.Block = item.Block; mntnceDetails.CompletionDate = item.CompletionDate; mntnceDetails.Contact = item.Contact; mntnceDetails.District = item.District; mntnceDetails.ProblemDescription = item.ProblemDescription; mntnceDetails.ReportedDate = item.ReportedDate; mntnceDetails.Status = item.Status; mntnceDetails.SystemCapacity = item.SystemCapacity; mntnceDetails.Village = item.Village; mntnceDetails.WorkOrderNo = item.WorkOrderNo; downloadONMList.Add(mntnceDetails); } DataTable dataTable = ToDataTable(downloadONMList); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dataTable); wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename= BeneficiaryList.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } //return Json("Success"); }
public ActionResult OandMSheet() { ViewBag.EmployeeList = db.tbl_employee.Where(e => e.Role == "Field Assitant").Select(e => e).ToList(); ViewBag.ItemList = db.tbl_Items.Select(i => i).ToList(); ViewBag.PumpTypeList = db.tbl_beneficiary.Select(b => b.PumpType).Distinct().ToList(); ViewBag.Status = new List <string>() { "Submitted", "PARTIALLY COMPLETED", "PENDING" }; var list = db.tbl_OandM.Select(o => o).Distinct().ToList(); if (Session["role"].ToString() == "Field Assitant") { list = list.Where(o => o.AssignedTo == Session["ID"].ToString()).Select(o => o).ToList(); } else if (Session["role"].ToString() == "Manager") { list = list.Where(o => o.Created_By == Session["ID"].ToString()).Select(o => o).ToList(); } else if (Session["role"].ToString() == "Admin") { list = list; } List <OperationAndMaintenanceModel> oNmList = new List <OperationAndMaintenanceModel>(); foreach (var maintenanceDetails in list) { int assignedTo = Convert.ToInt32(maintenanceDetails.AssignedTo); OperationAndMaintenanceModel oNmObj = new OperationAndMaintenanceModel(); oNmObj.BeneficiaryName = maintenanceDetails.tbl_beneficiary.BeneficiaryName; oNmObj.BeneficiaryID = maintenanceDetails.tbl_beneficiary.BeneficiaryID; oNmObj.Block = maintenanceDetails.tbl_beneficiary.Block; oNmObj.CompletionDate = maintenanceDetails.DateOfCompletion; oNmObj.Contact = maintenanceDetails.tbl_beneficiary.ContactNo; oNmObj.District = maintenanceDetails.tbl_beneficiary.District; oNmObj.ProblemDescription = maintenanceDetails.ProblemType; oNmObj.ReportedDate = maintenanceDetails.ProblemreportedOn; oNmObj.SystemCapacity = maintenanceDetails.tbl_beneficiary.systemCapacity; oNmObj.Status = maintenanceDetails.Status; oNmObj.Village = maintenanceDetails.tbl_beneficiary.Village; oNmObj.WorkOrderNo = maintenanceDetails.WorkOrderID; oNmObj.AssignedTo = assignedTo;/*db.tbl_employee.Where(e=>e.EmployeeName.Trim() == assignedTo.Trim()).Select(e=>e.EmployeeID).FirstOrDefault() ;*/ oNmObj.AssignedEmployee = db.tbl_employee.Where(e => e.EmployeeID == assignedTo).Select(e => e.EmployeeName).FirstOrDefault(); oNmList.Add(oNmObj); } TempData["ONMList"] = oNmList; return(View(oNmList)); }