public JsonResult GetUserCodeDivisionwise(string userTypeCodes, string divisionCodes)
{
List <MVCModels.userList> lstUser = new List <MVCModels.userList>();
lstUser = _ObjNoticeBoard.GetUserDivisionWise(userTypeCodes, divisionCodes);
return(Json(json.Serialize(lstUser)));
}
public ActionResult PriceGroupExcelUpload(HttpPostedFileBase file, FormCollection collection)
{
List <MVCModels.HiDoctor_Master.ProductPriceModel> lstProdModel = _objBLProduct.PriceGroupExcelUpload(_objCurrentInfo.GetCompanyCode(), file);
ViewBag.ExcelData = Json(_objJson.Serialize(lstProdModel));
return(View());
}
public JsonResult GetAssertDetails(string regionCode, string speciality_Code, string category_Code, string period)
{
BL_EdReports _objRpt = new BL_EdReports();
DataSet ds = _objRpt.GetAssertDetails(regionCode, speciality_Code, category_Code, period, _objcurrentInfo.GetSubDomain());
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
public JsonResult GetChildUserCheck(FormCollection collection)
{
DataSet dsChildUsers = new DataSet();
dsChildUsers = objSP.dsChildUsers(objCurr.GetCompanyCode(), objCurr.GetUserCode());
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsChildUsers)));
}
public JsonResult GetChildUserDetails(FormCollection collection)
{
string userName = collection["userName"].ToString();
DataSet dsChildUsers = new DataSet();
dsChildUsers = objSP.dsChildUserSearch(objCurr.GetCompanyCode(), objCurr.GetUserCode(), userName);
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsChildUsers)));
}
public JsonResult GetAssetWiseEdetailing(string RegionCode, string Spl_Month, string Spl_Year, string IsTeam)
{
DataSet ds = new DataSet();
BL_EdReports _objRpt = new BL_EdReports();
string period = Spl_Year + "-" + Spl_Month + "-01";
ds = _objRpt.GetAssetWiseEdetailing(RegionCode, _objcurrentInfo.GetSubDomain(), period, IsTeam);
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet));
}
//fill grid
public string GetRequestmapValues()
{
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string companyCode = _objCurInfo.GetCompanyCode();
try
{
DataControl.JSONConverter json = new DataControl.JSONConverter();
List <RequestModel> lstRequestMap = new List <RequestModel>();
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
StringBuilder sbTableContent = new StringBuilder();
lstRequestMap = (List <RequestModel>)_objMapping.GetRequestMapDetails(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>Edit</td>");
sbTableContent.Append("<td>Change Status</td>");
sbTableContent.Append("<td>Request</td>");
sbTableContent.Append("<td>UserType</td>");
sbTableContent.Append("<td>Status</td>");
sbTableContent.Append("</tr>");
sbTableContent.Append("</thead>");
sbTableContent.Append("<tbody>");
int i = 0;
foreach (var item in lstRequestMap)
{
i++;
sbTableContent.Append("<tr><td><a href='#' onclick ='fnEdit(\"" + item.Request_Code.ToString() + "_" + item.User_Type_Code.ToString() + "_" + item.Request_Mapping_Code.ToString() + "\");'>Edit</a></td>");
sbTableContent.Append("<td><a href='#' onclick ='fnStatusChange(\"" + item.Request_Mapping_Code.ToString() + "_" + item.Record_Status.ToString() + "\");'>Change Status</a></td>");
sbTableContent.Append("<td>" + item.Request_Name.ToString() + "</td>");
sbTableContent.Append("<td>" + item.User_Type_Name.ToString() + "</td>");
sbTableContent.Append("<td>" + item.Status.ToString() + "</td></tr>");
}
}
sbTableContent.Append("</tbody>");
sbTableContent.Append("</table>");
return(sbTableContent.ToString() + "*" + json.Serialize(lstRequestMap));
}
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 GetDoctor360Details(string doctorCode)
{
DataSet dsTpHeader = new DataSet();
string userCode = doctorCode.Split('_')[1].ToString();
string regionCode = doctorCode.Split('_')[0].ToString();
string customerCode = doctorCode.Split('_')[2].ToString();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsTpHeader = objData.ExecuteDataSet("exec SP_hdGetDoctor360Details '" + objCurr.GetCompanyCode() + "','" + customerCode + "','"
+ regionCode + "','" + userCode + "'");
}
objData.CloseConnection();
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsTpHeader)));
}
public JsonResult GetTPHeader(string userCode)
{
if (userCode.ToUpper() == "MINE")
{
userCode = objCurr.GetUserCode();
}
DataSet dsTpHeader = new DataSet();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsTpHeader = objData.ExecuteDataSet("exec SP_mhdGetTPReport '" + objCurr.GetCompanyCode() + "','" + userCode + "'");
}
objData.CloseConnection();
DataControl.JSONConverter json = new DataControl.JSONConverter();
return(Json(json.Serialize(dsTpHeader)));
}
public JsonResult GetWeekendGroup(FormCollection collection)
{
try
{
string RegionCode = string.Empty;
RegionCode = collection["RegionCode"];
string mode = string.Empty;
mode = collection["Mode"];
DataSet dsReport = new DataSet();
DataControl.JSONConverter json = new DataControl.JSONConverter();
_objData.OpenConnection(_objcurrentInfo.GetCompanyCode());
dsReport = _objSPData.GetWeekendgroupdetail(_objcurrentInfo.GetCompanyCode(), RegionCode, mode);
//dsReport = _objData.ExecuteDataSet("EXEC SP_hdGETRegionWeekengGroupMapping " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + RegionCode + "'");
return(Json(json.Serialize(dsReport), JsonRequestBehavior.AllowGet));
}
finally
{
_objData.CloseConnection();
}
}
public JsonResult GetAllSaleProducts()
{
List <MVCModels.HiDoctor_Master.ProductModel> lstProdModel = _objBLProduct.GetAllSaleProducts(_objCurrentInfo.GetCompanyCode());
return(Json(_objJson.Serialize(lstProdModel)));
}
public JsonResult GetWeekendGroupHeader()
{
List <MVCModels.HiDoctor_Master.WeekendGroup> lstWeekendGroupModel = _objBLWeekendGroup.GetWeekendGroupHeader();
return(Json(_objJson.Serialize(lstWeekendGroupModel)));
}
