public object GetUserInstantReport(FormCollection collection)
{
try
{
string companyCode = _objCurrentInfo.GetCompanyCode();
string dcrDate = collection["dcrActualDate"].ToString();
string dcrCode = "DCR" + collection["username"].ToString() + dcrDate.Split('-')[2].Trim() + dcrDate.Split('-')[1].Trim() + dcrDate.Split('-')[0].Trim();
DataSet dsDCRDetails = new DataSet();
if (collection["flag"].ToString() == "F" || collection["flag"].ToString() == "A")
{
dsDCRDetails = objSP.GetInstantReportDetails(companyCode, collection["usercode"].ToString(), collection["regioncode"].ToString(), collection["dcrActualDate"].ToString(), dcrCode, collection["flag"].ToString());
}
else
{
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
dsDCRDetails = objData.ExecuteDataSet("exec sp_hdGetDCRLeave '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "'");
}
objData.CloseConnection();
}
DataControl.JSONConverter jsonConvert = new DataControl.JSONConverter();
return(jsonConvert.Serialize(dsDCRDetails));
}
catch
{
throw;
}
}
public object GetUserInstantReport(string dcrActualDate, string flag)
{
string companyCode = _objCurrentInfo.GetCompanyCode();
string userCode = _objCurrentInfo.GetUserCode();
string regionCode = _objCurrentInfo.GetRegionCode();
string dcrCode = _objCurrentInfo.GetDCRCode(dcrActualDate);
DataSet dsDCRDetails = _objSPData.GetInstantReportDetails(companyCode, userCode, regionCode, dcrActualDate, dcrCode, flag);
DataControl.JSONConverter jsonConvert = new DataControl.JSONConverter();
return(jsonConvert.Serialize(dsDCRDetails));
}
