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