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