public JsonResult GetSchRequisionViewListDataToExcel(string startDate, string endDate, string circleId = "") { SARASWATIPRESSNEW.UserSec objUser; try { objUser = Session["UserSec"] != null ? ((SARASWATIPRESSNEW.UserSec)Session["UserSec"]) : new SARASWATIPRESSNEW.UserSec(); } catch (Exception) { objUser = new SARASWATIPRESSNEW.UserSec(); } string usertype = objUser.UserType; string filename = string.Empty; try { clsDirectoryDeleteStatus clsDirectoryDeleteStatus = new clsDirectoryDeleteStatus { status = true, StatusMessage = "Init" }; string str = Server.MapPath("~/Report/Requisition/"); string text2 = str + GlobalSettings.oUserData.UserUniqueId + "\\"; //Int16 CircleId = Convert.ToInt16(!string.IsNullOrWhiteSpace(GlobalSettings.oUserData.CircleID) ? GlobalSettings.oUserData.CircleID : "0"); Int16 CircleId = default(short); if (!string.IsNullOrWhiteSpace(circleId) && circleId != "-1") { CircleId = Convert.ToInt16(circleId); } else { CircleId = Convert.ToInt16(!string.IsNullOrWhiteSpace(GlobalSettings.oUserData.CircleID) ? GlobalSettings.oUserData.CircleID : "0"); } Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId); DataTable dt = objDbTrx.GetRequisitionViewNew(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), CircleId, AccadYear); if (dt != null && dt.Rows.Count > default(int)) { //var a = string.Join(",", dt.Columns.AsEnumerable().Select(column => column.ColumnName).ToArray()); dt.Columns.Add("STATUS", typeof(String)); dt.Columns.Add("DISTRICT APPROVAL", typeof(String)); dt.Columns.Add("DIRECTOR APPROVAL", typeof(String)); dt.Columns.Add("ADMIN APPROVAL", typeof(String)); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["STATUS"] = Convert.ToInt32(dt.Rows[i]["SAVE_STATUS"].ToString()) == 1 ? "Confirmed" : "Yet to confirm"; dt.Rows[i]["DISTRICT APPROVAL"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED_DIST"].ToString()) == 1 ? "Approved" : "Pending"; dt.Rows[i]["DIRECTOR APPROVAL"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED"].ToString()) == 1 ? "Approved" : "Pending"; dt.Rows[i]["ADMIN APPROVAL"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED_ADMIN"].ToString()) == 1 ? "Approved" : "Pending"; } if (Directory.Exists(text2)) { clsDirectoryDeleteStatus = Utility.DeleteDirectory(text2); } if (usertype == "7") { if (clsDirectoryDeleteStatus.status) { List <string> deleteColumnsList = new List <string> { "REQUISITION_ID", "SAVE_STATUS", "ISAPPROVED", "APPROVED_BY", "APPROVED_TS", "CIRCLE_ID", "SCHOOL_ID", "CATEGORY_ID", "LANGUAGE_ID", "CREATED_TS", "CREATED_BY", "UPDATED_TS", "UPDATED_BY", "REQ_SESSION_CODE", "ISAPPROVED_DIST", "APPROVED_BY_DIST", "APPROVED_TS_DIST", "ISAPPROVED_ADMIN" }; dt.Columns["REQ_CODE"].ColumnName = "REQUISITION_CODE"; //dt.Columns["ISAPPROVED"].ColumnName = "DIRECTOR APPROVAL"; string text = DateTime.Now.ToString("ddMMyyyyHHmm"); Directory.CreateDirectory(text2); Utility.GenerateExcel2007(text2 + text + ".xlsx", dt, deleteColumnsList); filename = text; } } else { if (clsDirectoryDeleteStatus.status) { List <string> deleteColumnsList = new List <string> { "REQUISITION_ID", "SAVE_STATUS", "ISAPPROVED", "APPROVED_BY", "APPROVED_TS", "CIRCLE_ID", "SCHOOL_ID", "CATEGORY_ID", "LANGUAGE_ID", "CREATED_TS", "CREATED_BY", "UPDATED_TS", "UPDATED_BY", "ISAPPROVED_ADMIN", "REQ_SESSION_CODE", "ISAPPROVED_DIST", "APPROVED_BY_DIST", "APPROVED_TS_DIST", "ADMIN APPROVAL" }; dt.Columns["REQ_CODE"].ColumnName = "REQUISITION_CODE"; //dt.Columns["ISAPPROVED"].ColumnName = "DIRECTOR APPROVAL"; string text = DateTime.Now.ToString("ddMMyyyyHHmm"); Directory.CreateDirectory(text2); Utility.GenerateExcel2007(text2 + text + ".xlsx", dt, deleteColumnsList); filename = text; } } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(new { Filename = filename }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetSchRequisionViewListDataToExcel(string startDate, string endDate, string districtId = "", string circleId = "", int isapproved = 0) { string filename = string.Empty; try { clsDirectoryDeleteStatus clsDirectoryDeleteStatus = new clsDirectoryDeleteStatus { status = true, StatusMessage = "Init" }; string str = Server.MapPath("~/Report/Requisition/"); string text2 = str + GlobalSettings.oUserData.UserUniqueId + "\\"; int CircleId = default(int); int DistrictId = default(int); int.TryParse(districtId, out DistrictId); string usertype = string.Empty; try { usertype = (GlobalSettings.oUserData).UserType; } catch { } if (!string.IsNullOrWhiteSpace(circleId)) { CircleId = Convert.ToInt32(circleId); } else { CircleId = Convert.ToInt32(!string.IsNullOrWhiteSpace(GlobalSettings.oUserData.CircleID) ? GlobalSettings.oUserData.CircleID : "-1"); } Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId); //DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId, isapproved, AccadYear); DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000") , Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId , (usertype == "5" ? isapproved : 0), AccadYear, IsForDistApproval: (usertype == "5" ? 0 : (usertype == "2" ? 1 : 0)) , DistApprovalstatus: (usertype == "2" ? isapproved : 0), IsForAdminApproval: (usertype == "5" ? 0 : (usertype == "3" ? 1 : 0)), AdminApprovalstatus: (usertype == "5" ? 0 : (usertype == "3" ? isapproved : 0))); if (dt != null && dt.Rows.Count > default(int)) { dt.Columns.Add("DISTRICT_APPROVAL_STATUS", typeof(String)); dt.Columns.Add("DIRECTOR_APPROVAL_STATUS", typeof(String)); // dt.Columns.Add("ADMIN_APPROVAL_STATUS", typeof(String)); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["DISTRICT_APPROVAL_STATUS"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED_DIST"].ToString()) == 1 ? "Approved" : "Not Approved"; } for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["DIRECTOR_APPROVAL_STATUS"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED"].ToString()) == 1 ? "Approved" : "Not Approved"; } //for (int i = 0; i < dt.Rows.Count; i++) //{ // dt.Rows[i]["ADMIN_APPROVAL_STATUS"] = Convert.ToInt32(dt.Rows[i]["ISAPPROVED_ADMIN"].ToString()) == 1 ? "Approved" : "Not Approved"; //} if (Directory.Exists(text2)) { clsDirectoryDeleteStatus = Utility.DeleteDirectory(text2); } if (usertype == "3") // admin { if (clsDirectoryDeleteStatus.status) { List <string> deleteColumnsList = new List <string> { "REQUISITION_ID", "SAVE_STATUS", "ISAPPROVED", "APPROVED_BY", "APPROVED_TS", "ISAPPROVED_DIST", "APPROVED_BY_DIST", "APPROVED_TS_DIST", "CIRCLE_ID", "SCHOOL_ID", "CATEGORY_ID", "LANGUAGE_ID", "CREATED_TS", "CREATED_BY", "UPDATED_TS", "UPDATED_BY", "REQ_SESSION_CODE" //"ISAPPROVED_ADMIN" }; dt.Columns["REQ_CODE"].ColumnName = "REQUISITION_CODE"; string text = DateTime.Now.ToString("ddMMyyyyHHmm"); Directory.CreateDirectory(text2); Utility.GenerateExcel2007(text2 + text + ".xlsx", dt, deleteColumnsList); filename = text; } } else { if (clsDirectoryDeleteStatus.status) { List <string> deleteColumnsList = new List <string> { "REQUISITION_ID", "SAVE_STATUS", "ISAPPROVED", "APPROVED_BY", "APPROVED_TS", "ISAPPROVED_DIST", "APPROVED_BY_DIST", "APPROVED_TS_DIST", "CIRCLE_ID", "SCHOOL_ID", "CATEGORY_ID", "LANGUAGE_ID", "CREATED_TS", "CREATED_BY", "UPDATED_TS", "UPDATED_BY", "REQ_SESSION_CODE", "ISAPPROVED_ADMIN" //"ADMIN_APPROVAL_STATUS" }; dt.Columns["REQ_CODE"].ColumnName = "REQUISITION_CODE"; string text = DateTime.Now.ToString("ddMMyyyyHHmm"); Directory.CreateDirectory(text2); Utility.GenerateExcel2007(text2 + text + ".xlsx", dt, deleteColumnsList); filename = text; } } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(new { Filename = filename }, JsonRequestBehavior.AllowGet)); }