public JsonResult GetExpenseEntity() { DataControl.BLCampaignPlanner _objBlCP = new DataControl.BLCampaignPlanner(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); List <MVCModels.ExpenseEntity> lstExpEntity = new List <MVCModels.ExpenseEntity>(); lstExpEntity = _objBlCP.GetExpenseEntity(_objCurInfo.GetCompanyCode()); return(Json(_objJson.Serialize(lstExpEntity))); }
public JsonResult GetUsers(string effective_from, string effective_to) { _objBLPromotionalInput = new BLPromotionalInput(); _objCurrentInfo = new CurrentInfo(); List <MVCModels.PromotionalInputUserModel> lstusers = new List <MVCModels.PromotionalInputUserModel>(); lstusers = _objBLPromotionalInput.GetUsers(_objCurrentInfo.GetCompanyCode(), _objCurrentInfo.GetUserCode(), effective_from, effective_to).ToList(); return(Json(_objJson.Serialize(lstusers))); }
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 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 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(); } }
/// <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 GetDCRAppliedUsers(FormCollection collection) { try { DataSet dsCategory = new DataSet(); objData.OpenConnection(_objCurrentInfo.GetCompanyCode()); { dsCategory = objData.ExecuteDataSet("exec SP_mhdGetDCRAppliedUsers '" + _objCurrentInfo.GetCompanyCode() + "','" + _objCurrentInfo.GetUserCode() + "','" + collection["DCRActualMonth"].ToString() + "','" + collection["DCRActualYear"].ToString() + "','" + collection["Status"].ToString() + "','" + collection["Selection"].ToString() + "','" + collection["UserName"].ToString() + "'"); } return(Json(_objJson.Serialize(dsCategory), JsonRequestBehavior.AllowGet)); } 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 GetRegionMasterDetails(FormCollection collection) { DataSet ds = new DataSet(); ds = _objSPData.GetRegionMasterDetails(); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet)); }
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 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 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 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 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 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))); }
/// <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))); }
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 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))); }
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))); }
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 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 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)); }
/// <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 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)); }
//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))); }