internal DataSet GetDataForReport(DocumentDownloadSection data, string EmpId)
{
DataSet ds = _objDAl.GetDataForReport(data, Convert.ToInt32(EmpId));
ds.Tables[0].TableName = "dsSalaryAllowance";
return(ds);
}
private Dictionary <string, object> getParam(DocumentDownloadSection _model)
{
_paramList = new Dictionary <string, object>();
_paramList.Add("@Option", _model.OperationName);
_paramList.Add("@Option1", _model.TaxStatus);
return(_paramList);
}
internal string GetDataForReport(DocumentDownloadSection data, string EmpCode)
{
string error = string.Empty;
error = _objDAl.GetDataForReport(data, EmpCode);
return(error);
}
private Dictionary <string, object> getParam(DocumentDownloadSection _model)
{
_paramList = new Dictionary <string, object>();
_paramList.Add("@OperationName", _model.OperationName);
_paramList.Add("@EMP_ID", _model.EMP_ID);
return(_paramList);
}
private DataTable GetRowForReport(DataTable dt, DocumentDownloadSection data)
{
DataRow row = dt.NewRow();
row["OperationName"] = data.OperationName;
row["EMP_CODE"] = data.EMP_CODE;
row["EmpName"] = data.EmpName;
row["EmpSection"] = data.EmpSection;
row["Empdesignation"] = data.Empdesignation;
row["DeptEName"] = data.DeptEName;
row["UnitEName"] = data.UnitEName;
row["UnitEAddress"] = data.UnitEAddress;
row["DOJ"] = data.DOJ;
row["Date"] = data.Date;
row["TimeFrom"] = data.TimeFrom;
row["TimeTo"] = data.TimeTo;
row["TotalDays"] = data.TotalDays;
row["ApplicationDate"] = data.ApplicationDate;
row["LeaveType"] = data.LeaveType;
row["Reason"] = data.Reason;
row["AddressDuringLeave"] = data.AddressDuringLeave;
row["JoinAfterLeave"] = data.JoinAfterLeave;
row["ConcernPersonnameDesig"] = data.ConcernPersonnameDesig;
row["OutstationPlaceName"] = data.OutstationPlaceName;
if (data.lstLeaveStatus != null)
{
row["TotalEntitle"] = data.lstLeaveStatus[0].MaxBalance;
row["AlreadyEnjoy"] = data.lstLeaveStatus[0].Avail;
row["Balance"] = data.lstLeaveStatus[0].MaxBalance - data.lstLeaveStatus[0].Avail;
}
dt.Rows.Add(row);
return(dt);
}
private Dictionary <string, object> getParam(DocumentDownloadSection _model)
{
_paramList = new Dictionary <string, object>();
_paramList.Add("@MonthName", _model.FromMonth);
_paramList.Add("@EMP_CODE", _model.EMP_CODE);
_paramList.Add("@FinYearNo", _model.FinYear);
return(_paramList);
}
internal DataTable GetData(int EmpID)
{
_model = new DocumentDownloadSection();
_model.OperationName = "GetEmpInfoByEmpId";
_model.EMP_ID = EmpID;
_paramList = getParam(_model);
return(Models.DAL.GetDataTable(SearchStoreProcedureName.GetLeaveFromData, _paramList, DBName.SearchET));
}
internal DataSet SetDataForReport(DocumentDownloadSection data)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("Table");
dt = GetColumnForReport(dt);
dt = GetRowForReport(dt, data);
ds.Tables.Add(dt);
return(ds);
}
public DataTable GetMonthByFinYear(string finYear, int EmpID)
{
_model = new DocumentDownloadSection();
_model.OperationName = "GetAdvanceMonth";
_model.FinYear = Convert.ToInt32(finYear);
_model.EMP_ID = EmpID;
_paramList = getParam(_model);
return(Models.DAL.GetDataTable(SearchStoreProcedureName.GetMonthFinYear, _paramList, DBName.SearchET));
}
public JsonResult GetInitialData()
{
DocumentDownloadSection obj = new DocumentDownloadSection();
if (Session["UserName"] != null)
{
obj = _objBLL.GetData(Session["EMP_ID"].ToString());
}
return(Json(obj, JsonRequestBehavior.AllowGet));
}
internal DataSet GetDataForReport(DocumentDownloadSection data, int EmpID)
{
_model = new DocumentDownloadSection();
_model.OperationName = "E.EMP_ID=" + EmpID + " and " + "TC.TaxFinYearNo=" + data.TaxFinYearNo;
_model.TaxStatus = data.TaxStatus;
_paramList = getParam(_model);
DataSet ds = Models.DAL.GetDataSet(HRStoredProcedureName.IncomeTaxCertificate, _paramList, DBName.HR);
return(ds);
}
public FileResult DownloadFile(string Param, string ReportType)
{
DocumentDownloadSection data = JsonConvert.DeserializeObject <DocumentDownloadSection>(Param);
DataSet ds = _objBLL.GetDataForReport(data, Session["EMP_ID"].ToString());
var rf = ReportFormat.getReport(ReportType, ds, data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
return(File(rf.stream, "application/pdf", data.OperationName + DateTime.Now.ToString("dd-MM-yyyy hhmm") + ".pdf"));
}
public JsonResult SendMail(DocumentDownloadSection data)
{
string error = string.Empty;
try
{
error = _objBLL.GetDataForReport(data, Session["EMP_CODE"].ToString());
}
catch (Exception ex)
{
error = ex.Message.ToString();
}
return(Json(error, JsonRequestBehavior.AllowGet));
}
public FileResult OpenFile(string Param, string ReportType)
{
try
{
DocumentDownloadSection data = JsonConvert.DeserializeObject <DocumentDownloadSection>(Param);
DataSet ds = _objBLL.GetDataForReport(data, Session["EMP_ID"].ToString());
var rf = ReportFormat.getReport(ReportType, ds, data);
return(File(rf.stream, rf.mimeType));
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
return(null);
}
internal string GetDataForReport(DocumentDownloadSection data, string empCode)
{
string error = string.Empty;
data.EMP_CODE = empCode;
_paramList = getParam(data);
try
{
var num = Models.DAL.storedProc(HRStoredProcedureName.GetEmpPaySlipForEmail, _paramList, DBName.HR);
error = "Send";
}
catch (Exception ex)
{
error = ex.Message.ToString();
}
return(error);
}
internal string GetDataForReport(DocumentDownloadSection data, string empCode)
{
string error = string.Empty;
_paramList = new Dictionary <string, object>();
_paramList.Add("@MonthName", data.FromMonth);
_paramList.Add("@EMP_CODE", empCode);
_paramList.Add("@FinYearNo", data.FinYear);
try
{
var num = Models.DAL.storedProc(HRStoredProcedureName.AdvancePaySlipForEmail, _paramList, DBName.HR);
error = "Send";
}
catch (Exception ex)
{
error = ex.Message.ToString();
}
return(error);
}
internal DocumentDownloadSection GetData(string EmpId)
{
DocumentDownloadSection obj = new DocumentDownloadSection();
dt = new DataTable();
dt = _objDAl.GetData(Convert.ToInt32(EmpId));
if (dt.Rows.Count > 0)
{
obj.lstLeaveStatus = dt.DataTableToList <LeaveStatus>();
obj.EMP_CODE = dt.Rows[0]["EMP_CODE"].ToString();
obj.EmpName = dt.Rows[0]["EMP_ENAME"].ToString();
obj.DeptEName = dt.Rows[0]["DeptEName"].ToString();
obj.EmpSection = dt.Rows[0]["SectEName"].ToString();
obj.Empdesignation = dt.Rows[0]["DesigEName"].ToString();
obj.UnitEName = dt.Rows[0]["UnitEName"].ToString();
obj.UnitEAddress = dt.Rows[0]["UnitEAddress"].ToString();
obj.GroupEName = dt.Rows[0]["GroupEName"].ToString();
obj.DOJ = dt.Rows[0]["DOJ"].ToString();
}
return(obj);
}
