public JsonResult InsertExpenseGroup(FormCollection coll)
{
try
{
string result = string.Empty;
DataSet ds = new DataSet();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
result = _objSP.InsertExpenseGroup(coll["insertExpense"].ToString(), coll["grpName"].ToString());
if (result == "SUCCESS")
{
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
ds = _objData.ExecuteDataSet("exec SP_hdGetExpenseGroup '" + _objCurr.GetCompanyCode() + "'");
}
}
return(Json(objJson.Serialize(ds)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_objData.CloseConnection();
}
}
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;
}
}
/// <summary>
///
/// </summary>
/// <param name="bp_Type"></param>
/// <returns></returns>
public JsonResult GetBPHeader(string bp_Type, string Effective_from, string Effective_to, int Value)
{
string userCode = _objCurrentInfo.GetUserCode();
string companyCode = _objCurrentInfo.GetCompanyCode();
// StringBuilder bpHeaderRowsHTMLFormat = new StringBuilder();
DataSet ds = _objSPData.GetBatchProcessingHeader(companyCode, bp_Type, userCode, Effective_from, Effective_to, Value);
//if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
//{
// DataRowCollection drCollection = ds.Tables[0].Rows;
// Bind Error Details
// bpHeaderRowsHTMLFormat.Append("<table class='bpTable' border='0' cellspacing='0' cellpadding='0' style='margin-top:2%;'><thead><tr><th>File Name</th>");
// bpHeaderRowsHTMLFormat.Append("<th>Date of Upload</th><th>Uploaded By</th><th>Status of upload</th><th>Reupload</th></thead><tbody>");
// foreach (DataRow dr in drCollection)
// {
// string errorClass = string.Empty;
// errorClass = dr["Status"].ToString().ToUpper() == "ERROR" ? "ERR_ROW" : "";
// string fileName = string.Empty;
// if (dr["Upload_File_Name"].ToString().Contains("\\"))
// {
// fileName = dr["Upload_File_Name"].ToString().Substring(dr["Upload_File_Name"].ToString().LastIndexOf('\\')).Replace("\\", "");
// }
// else
// {
// fileName = dr["Upload_File_Name"].ToString();
// }
// bpHeaderRowsHTMLFormat.Append("<tr class='" + errorClass + "'><td>" + fileName + "</td>");
// bpHeaderRowsHTMLFormat.Append("<td>" + dr["Upload_Date"].ToString() + "</td>");
// bpHeaderRowsHTMLFormat.Append("<td>" + dr["User_Name"].ToString() + "</td>");
// if (errorClass.Trim().Length > 0)
// {
// bpHeaderRowsHTMLFormat.Append("<td><a href='#' onclick='BPPopup(\"" + dr["BP_ID"].ToString() + "\")'> " + dr["Status"].ToString() + "</a></td>");
// }
// else
// {
// if (!string.IsNullOrEmpty(dr["DB_Error"].ToString()))
// {
// bpHeaderRowsHTMLFormat.Append("<td>" + dr["Status"].ToString() + "-" + dr["DB_Error"].ToString() + "</td>");
// }
// else
// {
// bpHeaderRowsHTMLFormat.Append("<td>" + dr["Status"].ToString() + "</td>");
// }
// // bpHeaderRowsHTMLFormat.Append("<td>" + dr["Status"].ToString() + "</td>");
// }
// bpHeaderRowsHTMLFormat.Append("<td><a href='#' onclick='fnRedirectToUploadScreen()'>" + dr["Reupload"].ToString() + "</a></td>");
// bpHeaderRowsHTMLFormat.Append("</tr>");
// }
// bpHeaderRowsHTMLFormat.Append("</tbody></table>");
//}
//else
//{
// bpHeaderRowsHTMLFormat.Append("<span> No Uploaded Found.</span>");
//}
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public string GetRegionsForHolidaySearch()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.RegionModel> lstRegion = null;
IEnumerable <MVCModels.HiDoctor_Master.RegionModel> lstUnMappedRegion = null;
lstRegion = objRegion.GetHolidayMappedRegions(objCurInfo.GetCompanyCode());
lstUnMappedRegion = objRegion.GetHolidayUnMappedRegions(objCurInfo.GetCompanyCode());
StringBuilder strContent = new StringBuilder();
strContent.Append("<table class='table table-striped' id='tblUnMappedRegion'><thead><tr><td>S.No</td><td><input type='checkbox' name='chkAllUnMappedRegion' onclick='fnSelectAllUnMappedRegions();'/></td>");
strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstUnMappedRegion != null)
{
int i = 0;
foreach (var dr in lstUnMappedRegion)
{
i++;
strContent.Append("<tr><td>" + i + "</td>");
strContent.Append("<td><input type='checkbox' id='chkSelect_" + i + "' name='chkUnMappedRegion' value='" + dr.Region_Code + "'/></td>");
strContent.Append("<td>" + dr.Region_Name + "</td>");
strContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strContent.Append("</tr>");
}
}
strContent.Append("</table>");
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(objJson.Serialize(lstRegion) + "~" + strContent.ToString());
}
public string GetUserProjectDetails(int pageNo)
{
int totalPageNo = 1;
const int PAGESIZE = 10;
DataControl.JSONConverter json = new DataControl.JSONConverter();
List <UserProjectMapping> lstUserProject = new List <UserProjectMapping>();
List <UserProjectMapping> lstUserProjectFiler = new List <UserProjectMapping>();
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string companyCode = _objCurInfo.GetCompanyCode();
StringBuilder sbTableContent = new StringBuilder();
lstUserProject = (List <UserProjectMapping>)_objMapping.GetUserProjectMapDetails(companyCode, pageNo, PAGESIZE, ref totalPageNo);
lstUserProjectFiler = (List <UserProjectMapping>)_objMapping.GetUserProjectMapallDetails(companyCode);
try
{
if (lstUserProject != null && lstUserProject.Count > 0)
{
sbTableContent.Append(Pager.Paging(pageNo, totalPageNo));
sbTableContent.Append("<table id='tblUserProject' class='table table-striped' >");
sbTableContent.Append("<thead class='active'>");
sbTableContent.Append("<tr style='background-color: #428bca'>");
sbTableContent.Append("<td>Edit</td>");
sbTableContent.Append("<td>Delete</td>");
sbTableContent.Append("<td>Project</td>");
sbTableContent.Append("<td>User</td>");
sbTableContent.Append("<td>Start Date</td>");
sbTableContent.Append("<td>End Date</td>");
sbTableContent.Append("</tr>");
sbTableContent.Append("</thead>");
sbTableContent.Append("<tbody>");
int i = 0;
foreach (var item in lstUserProject)
{
i++;
sbTableContent.Append("<tr><td><a href='#' onclick ='fnEdit(\"" + item.Project_Code.ToString() + "_" + item.User_Code.ToString() + "_" + item.Mapping_Code.ToString() + "_" + item.StartDate.ToString() + "_" + item.EndDate.ToString() + "\");'>Edit</a></td>");
sbTableContent.Append("<td><a href='#' onclick ='fnDelete(\"" + item.Project_Code.ToString() + "_" + item.User_Code.ToString() + "_" + item.Mapping_Code.ToString() + "\");'>Delete</a></td>");
sbTableContent.Append("<input type='hidden' id='hduserCode_" + i + "' value='" + item.User_Code.ToString() + "' />");
sbTableContent.Append("<input type='hidden' id='hdprojectCode_" + i + "' value='" + item.Project_Code.ToString() + "' />");
sbTableContent.Append("<td>" + item.Project_Name.ToString() + "</td>");
sbTableContent.Append("<td>" + item.User_Name.ToString() + "</td>");
sbTableContent.Append("<td>" + item.StartDate.ToString() + "</td>");
sbTableContent.Append("<td>" + item.EndDate.ToString() + "</td></tr>");
}
}
sbTableContent.Append("</tbody>");
sbTableContent.Append("</table>");
return(sbTableContent.ToString() + "*" + json.Serialize(lstUserProjectFiler));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return("Sorry an error occured. Please try again later.");
}
}
public JsonResult GetCompetitorBrandProducts(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsProduct = new DataSet();
string month = string.Empty, year = string.Empty;
DateTime dtdcrDate = Convert.ToDateTime(coll["dcrDate"]);
DateTime dtPrevDate = dtdcrDate.AddMonths(-1);
month = dtPrevDate.Month.ToString();
year = dtPrevDate.Year.ToString();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsProduct = objData.ExecuteDataSet("exec SP_hdGetCompetitorBrandProducts '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + year + "','" + month + "','" + coll["customerCode"].ToString() + "'");
}
return(Json(objJson.Serialize(dsProduct)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objData.CloseConnection();
}
}
public JsonResult GetActicitySummary(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsActivity = new DataSet();
string toDate = DateTime.Now.ToShortDateString();
string fromDate = string.Empty;
//fromDate = toDate.Split('-')[0] + "-" + toDate.Split('-')[1] + "-01";
fromDate = DateTime.Now.Month + "/01/" + DateTime.Now.Year;
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsActivity = objData.ExecuteDataSet("exec SP_hdGetActivitySummaryIR '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + fromDate + "','" + toDate + "'");
}
return(Json(objJson.Serialize(dsActivity)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objData.CloseConnection();
}
}
public string GetAPIServiceDefinInputDetail(string APIServiceId)
{
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string companyCode = _objCurInfo.GetCompanyCode();
string[] APIparameter;
try
{
DataControl.JSONConverter json = new DataControl.JSONConverter();
List <APIServiceModel> lstServiceMap = new List <APIServiceModel>();
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
StringBuilder sbTableContent = new StringBuilder();
lstServiceMap = (List <APIServiceModel>)_objMapping.GetAPIServiceDetail(APIServiceId);
if (lstServiceMap != null && lstServiceMap.Count > 0)
{
int i = 0;
sbTableContent.Append("<table id='tblAPIInputs' class='table table-striped' >");
sbTableContent.Append("<thead class='active'>");
sbTableContent.Append("<tr style='background-color: #428bca'>");
sbTableContent.Append("<td>Service Parameters</td>");
sbTableContent.Append("<td>Display Order</td>");
sbTableContent.Append("<td>Get Session</td>");
sbTableContent.Append("<td>Session Key</td>");
sbTableContent.Append("<td>Show in UI</td>");
sbTableContent.Append("<td>Control type</td>");
sbTableContent.Append("<td>Description</td>");
sbTableContent.Append("</tr>");
sbTableContent.Append("</thead>");
sbTableContent.Append("<tbody>");
foreach (var item in lstServiceMap)
{
APIparameter = item.ServiceParams.Split(',');
foreach (string splitParam in APIparameter)
{
i++;
sbTableContent.Append("<tr ><td id='ParamName" + i + "'><span id='splitParam_" + i + "'>" + splitParam + "</span></td>");
sbTableContent.Append("<td id='textbox " + i + "'><input id='paramOrder_" + i + "'value='" + i + "' type='TextBox'></td>");
sbTableContent.Append("<td id='checkboxSession " + i + "'><input type='checkbox' onclick='fnGetSession()' id='Chk_getsession_" + i + "' name='chk_session' /></td>");
sbTableContent.Append("<td id='ddl " + i + "'><select id='ddlSessionSelection_" + i + "'><option value='0'>-Select Mode-</option> <option value='Comp_Code'>Comp_Code</option><option value='User_Code'>User_Code</option><option value='Region_Code'>Region_Code</option><option value='User_Type_Code'>User_Type_Code</option></select></td>");
sbTableContent.Append("<td id='checkUI " + i + "'><input type='checkbox' onclick='fnGetUI()' id='Chk_UI_" + i + "' Value='Y' name='chk_UI' /></td>");
sbTableContent.Append("<td id='ddlControl_ " + i + "'><select id='ddlControl_" + i + "'><option value='0'>-Select Mode-</option> <option value='TEXT'>TEXT</option><option value='DATE'>DATE</option><option value='TEXT_CSV'>TEXT_CSV</option></select></td>");
sbTableContent.Append("<td id='textarea " + i + "'><textarea id='Description_" + i + "'></textarea></td>");
}
sbTableContent.Append("<td></td></tr>");
}
}
sbTableContent.Append("</tbody>");
sbTableContent.Append("</table>");
return(sbTableContent.ToString() + "*" + json.Serialize(lstServiceMap));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return("Sorry an error occured. Please try again later.");
}
}
public JsonResult GetDocTypes()
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
List <MVCModels.MyDocumentsModel> lstMydocTypes = null;
lstMydocTypes = _objBlMaster.GetMyDocTypes(_objcurrentInfo.GetCompanyCode()).ToList();
return(Json(objJson.Serialize(lstMydocTypes)));
}
public JsonResult GetRegionMasterDetails(FormCollection collection)
{
DataSet ds = new DataSet();
ds = _objSPData.GetRegionMasterDetails();
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
//For excell
public void PutRequestCategoryMasterIntoExcel()
{
string blobUrl = string.Empty;
string error = string.Empty;
StringBuilder sbTableContent = new StringBuilder();
DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
string companyCode = _objCurrentInfo.GetCompanyCode();
StringBuilder sb = new StringBuilder();
DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
try
{
DataControl.JSONConverter json = new DataControl.JSONConverter();
List <RequestCategoryMasterModel> lstRequestMap = new List <RequestCategoryMasterModel>();
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
lstRequestMap = (List <RequestCategoryMasterModel>)_objMapping.GetRequestCategoryDetail(companyCode);
if (lstRequestMap != null && lstRequestMap.Count > 0)
{
sbTableContent.Append("<table id='tblrequest' class='table table-striped' >");
sbTableContent.Append("<thead class='active'>");
sbTableContent.Append("<tr style='background-color: #428bca'>");
sbTableContent.Append("<td>Request Category Name</td>");
sbTableContent.Append("<td>Status</td>");
sbTableContent.Append("</tr>");
sbTableContent.Append("</thead>");
sbTableContent.Append("<tbody>");
foreach (var item in lstRequestMap)
{
sbTableContent.Append("<tr><td>" + item.Request_Category_Name + "</td>");
sbTableContent.Append("<td>" + item.Request_Category_Status + "</td></tr>");
}
}
sbTableContent.Append("</tbody>");
sbTableContent.Append("</table>");
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = _objCurrentInfo.GetUserName();
string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;;
string fileName = "RequestCategoryMaster " + " - " + subdomainName + " - " + userName + ".xls";
blobUrl = objAzureBlob.AzureBlobUploadText(sbTableContent.ToString(), accKey, fileName, "bulkdatasvc");
objFileDownload.DownloadFile(blobUrl, fileName, out error);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();;
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
}
}
public JsonResult GetRegionTypes()
{
DAL_Reports_CategoryWiseDrVisitAnalysis objDAL = new DAL_Reports_CategoryWiseDrVisitAnalysis();
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
string companyCode = _objcurrentInfo.GetCompanyCode();
dsRegionType = objDAL.GetRegionTypes(companyCode);
DataRow[] rowFilter;
rowFilter = dsRegionType.Tables[0].Select("Region_Type_Code = Under_Region_Type");
if (rowFilter.Length > 0)
{
foreach (DataRow dr in rowFilter)
{
regionTypeLevelNo = 1;
dr["Level_No"] = regionTypeLevelNo.ToString();
dsRegionType.Tables[0].AcceptChanges();
}
foreach (DataRow dr in rowFilter)
{
GenerateRegionTypeLevel(dr["Region_Type_Code"].ToString());
}
}
DataSet ds = new DataSet();
string regionCode = string.Empty;
string regionTypeCode = string.Empty;
regionCode = _objcurrentInfo.GetRegionCode();
regionTypeCode = objDAL.GetRegionTypeCode(companyCode, regionCode);
ds = dsRegionType.Clone();
rowFilter = dsRegionType.Tables[0].Select("Region_Type_Code = '" + regionTypeCode + "'");
if (rowFilter.Length > 0)
{
regionTypeLevelNo = Convert.ToInt16(rowFilter[0]["Level_No"].ToString());
rowFilter = dsRegionType.Tables[0].Select("Level_No >= '" + regionTypeLevelNo + "'");
foreach (DataRow dr in rowFilter)
{
ds.Tables[0].ImportRow(dr);
ds.Tables[0].AcceptChanges();
}
}
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetExpenseMappingMasterData()
{
Models.ExpensesMapping objExpensesMapping = new Models.ExpensesMapping();
DataSet ds = new DataSet();
ds = objExpensesMapping.GetExpenseMappingMasterData();
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductiveCallAverage(string Division_Code, string flag)
{
DataSet ds = new DataSet();
string User_Code = _objCurrentInfo.GetUserCode();
ds = _objSPData.GetProductiveCallAverage(User_Code, Division_Code, flag);
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetDailyCallPlannerDoctorDetails(FormCollection coll)
{
try
{
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataSet dsDailyPlanDoctor = new DataSet();
string fromDate = string.Empty, month = string.Empty, year = string.Empty;
#region FromDate calculation
if (coll["YTDType"].ToString() == "APRIL")
{
if (DateTime.Now.Month < 4)
{
fromDate = (DateTime.Now.Year - 1).ToString() + "-04-01";
}
else
{
fromDate = DateTime.Now.Year.ToString() + "-04-01";
}
}
else
{
if (DateTime.Now.Month < 3)
{
fromDate = (DateTime.Now.Year - 1).ToString() + "-03-01";
}
else
{
fromDate = DateTime.Now.Year.ToString() + "-03-01";
}
}
#endregion FromDate calculation
DateTime dtdcrDate = Convert.ToDateTime(coll["dcrDate"]);
DateTime dtPrevDate = dtdcrDate.AddMonths(-1);
month = dtPrevDate.Month.ToString();
year = dtPrevDate.Year.ToString();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsDailyPlanDoctor = objData.ExecuteDataSet("exec SP_hdGetDailyPlanDoctorYTD '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "','" + objCurr.GetRegionCode() + "','" + month + "','" + year + "','" + fromDate + "','" + coll["dcrDate"].ToString() + "'");
}
return(Json(objJson.Serialize(dsDailyPlanDoctor)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objData.CloseConnection();
}
}
public JsonResult GetSpecialitywiseDoctorCount(string Division_Code = "ALL")
{
DataSet ds = new DataSet();
string UserCode = _objCurrentInfo.GetUserCode();
string RegionCode = _objCurrentInfo.GetRegionCode();
ds = _objSPData.GetSpecialitywiseDoctorCount(UserCode, RegionCode, Division_Code);
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetActivityDetails()
{
DataControl.BLUser _objBluser = new DataControl.BLUser();
DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
DataSet ds = new DataSet();
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
ds = _objBluser.GetActivitydetail(_objCurrentInfo.GetCompanyCode());
return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetUploadSummary(FormCollection collection)
{
Dt = new DataTable();
Dt = Bl.GetUploadSummary(collection["region"], collection["depot"], collection["customer"], collection["document_no"], collection["from"], collection["to"], collection["ProductCode"], collection["Mode"]);
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(new LargeJsonResult()
{
Data = json.Serialize(Dt), MaxJsonLength = int.MaxValue
});
}
public JsonResult GetRequestCategoryNames()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
BLMaster _objMaster = new BLMaster();
List <DCRRestrictionModel> lstrequestCategoryNames = new List <DCRRestrictionModel>();
lstrequestCategoryNames = _objMaster.GetRequestCategoryName(_objcurrentInfo.GetCompanyCode()).ToList();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstrequestCategoryNames)));
}
public JsonResult GetAllActiveProducts()
{
DataControl.BLProduct _objProduct = new DataControl.BLProduct();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
List <MVCModels.HiDoctor_Master.ProductModel> lstProduct = new List <MVCModels.HiDoctor_Master.ProductModel>();
lstProduct = _objProduct.GetAllActiveProducts(_objCurInfo.GetCompanyCode());
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(lstProduct)));
}
public JsonResult GetGetDivisionEntityDetails(string divisionCode, string entityType)
{
DataControl.BLDivision _objMapping = new DataControl.BLDivision();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
IEnumerable <MVCModels.DivisionEntityMapping> lstMapping = new List <MVCModels.DivisionEntityMapping>();
lstMapping = _objMapping.GetDivisionEntityDetails(_objCurInfo.GetCompanyCode(), divisionCode, entityType);
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(lstMapping)));
}
public JsonResult GetReportsMenu(FormCollection collection)
{
DataSet dsReport = new DataSet();
DataControl.JSONConverter json = new DataControl.JSONConverter();
dsReport = _objSPData.GetSFAWAReportsMenu(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetUserTypeCode());
return(Json(json.Serialize(dsReport), JsonRequestBehavior.AllowGet));
}
public JsonResult GetApprovedDoctorsByRegion(string regionCode)
{
DataControl.BL_Customer _objCus = new DataControl.BL_Customer();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
List <MVCModels.HiDoctor_Master.DoctorModel> lstDoctor = new List <MVCModels.HiDoctor_Master.DoctorModel>();
lstDoctor = _objCus.GetApprovedDoctorsByRegion(_objCurInfo.GetCompanyCode(), regionCode);
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(lstDoctor)));
}
/// <summary>
///
/// </summary>
/// <param name="bp_Type"></param>
/// <returns></returns>
public JsonResult GetBPHeaderForPSAutomation(string bp_Type, string Effective_from, string Effective_to, int Value)
{
string userCode = _objCurrentInfo.GetUserCode();
string companyCode = _objCurrentInfo.GetCompanyCode();
// StringBuilder bpHeaderRowsHTMLFormat = new StringBuilder();
DataSet ds = _objSPData.GetBatchProcessingHeaderForPSAutomation(companyCode, bp_Type, userCode, Effective_from, Effective_to, Value);
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetDivisions()
{
DataControl.BLMessaging _objBlMsg = new DataControl.BLMessaging();
DataControl.CurrentInfo _objcurInfo = new DataControl.CurrentInfo();
DataControl.JSONConverter _objJsoncon = new DataControl.JSONConverter();
List <MVCModels.MsdDivisionModel> lstDivisions = new List <MVCModels.MsdDivisionModel>();
lstDivisions = (List <MVCModels.MsdDivisionModel>)_objBlMsg.GetDivisions(_objcurInfo.GetCompanyCode());
return(Json(_objJsoncon.Serialize(lstDivisions)));
}
/// <summary>
/// Get user type which is mapped in the payslip
/// </summary>
/// <returns></returns>
public JsonResult GetPaySlipMappedUserTypes()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLUser objUser = new DataControl.BLUser();
IEnumerable <MVCModels.HiDoctor_Master.UserTypeModel> lstUserType = null;
lstUserType = objUser.GetPaySlipMappedUserTypes(objCurInfo.GetCompanyCode());
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstUserType)));
}
//GetRegionTypeDetail
public JsonResult GetRegionTypeDetail()
{
DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
DataSet ds = new DataSet();
ds = _objBlmaster.GetRegiontypeDetailsAll(_objCurrentInfo.GetCompanyCode());
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetUsersbyUserTypeCode(string userTypeCode)
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
BLUser _objUser = new BLUser();
List <MVCModels.HiDoctor_Master.UserModel> lstUsers = new List <MVCModels.HiDoctor_Master.UserModel>();
lstUsers = _objUser.GetUsersByUserType(_objcurrentInfo.GetCompanyCode(), userTypeCode).ToList();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstUsers)));
}
public JsonResult GetUserType()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
BLMaster _objMaster = new BLMaster();
List <DivisionUserProducts> lstUserType = new List <DivisionUserProducts>();
lstUserType = _objMaster.GetUserTypeNamesforProductMapping(_objcurrentInfo.GetCompanyCode()).ToList();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstUserType)));
}
/// <summary>
/// Get Entity code based on division
/// </summary>
/// <returns></returns>
public JsonResult GetEntitycodebyDivision()
{
DataControl.BLMessaging _objBlMsg = new DataControl.BLMessaging();
DataControl.CurrentInfo _objcurInfo = new DataControl.CurrentInfo();
DataControl.JSONConverter _objJsoncon = new DataControl.JSONConverter();
List <MVCModels.DivisionBasedModel> lstEntityDivisions = new List <MVCModels.DivisionBasedModel>();
lstEntityDivisions = _objBlMsg.GetEntityCodebyDivision(_objcurInfo.GetCompanyCode()).ToList();
return(Json(_objJsoncon.Serialize(lstEntityDivisions)));
}
