public ActionResult DoctorsReason(string Lid)
{
if (Lid == null)
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
//ViewBag.SelectedRegionCode = _objCurrentInfo.GetSRegionCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "NO";
}
else
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
MVCModels.DoctorMissedReason.ParameterMode dd = Newtonsoft.Json.JsonConvert.DeserializeObject <MVCModels.DoctorMissedReason.ParameterMode>(parameters);
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
//ViewBag.SelectedRegionCode = _objCurrentInfo.GetSRegionCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "YES";
}
return(View());
}
public ActionResult PSAndSSSalesEntry(string Lid)
{
//string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
//ParameterMode obj = Newtonsoft.Json.JsonConvert.DeserializeObject<ParameterMode>(parameters);
if (Lid == null)
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
ViewBag.CompanyId = _objCurrentInfo.GetCompanyId();
ViewBag.IsResponsive = "No";
}
else
{
string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(Lid));
MVCModels.PSAndSSSalesEntry.ParameterMode dd = Newtonsoft.Json.JsonConvert.DeserializeObject <MVCModels.PSAndSSSalesEntry.ParameterMode>(parameters);
ViewBag.subDomainName = dd.SubDomain_Name;
ViewBag.CompanyCode = dd.Company_Code;
ViewBag.LoginRegionCode = dd.Region_Code;
ViewBag.LoginUserCode = dd.User_Code;
ViewBag.CompanyId = dd.Company_Id;
ViewBag.IsResponsive = "YES";
}
return(View());
}
public string UpdateMsgReadStatus(string isRead, string msgDetails)
{
string result = string.Empty;
List <MVCModels.MessagingModel> lstMsg = new List <MVCModels.MessagingModel>();
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLMessaging objMsg = new DataControl.BLMessaging();
try
{
if (!string.IsNullOrEmpty(msgDetails))
{
string[] ar = msgDetails.Split('^');
if (ar.Length > 0)
{
for (int i = 0; i < ar.Length; i++)
{
if (!string.IsNullOrEmpty(Convert.ToString(ar[i]).Split('~')[0]))
{
string targetAddress = Convert.ToString(ar[i]).Split('~')[1];
MVCModels.MessagingModel objMsgModel = new MVCModels.MessagingModel();
objMsgModel.Company_Code = objCurInfo.GetCompanyCode();
objMsgModel.Msg_Code = Convert.ToString(ar[i]).Split('~')[0];
objMsgModel.Target_Address = targetAddress;
lstMsg.Add(objMsgModel);
}
}
int rowsAffected = 0;
rowsAffected = objMsg.UpdateMsgReadStatus(objCurInfo.GetCompanyCode(), lstMsg, isRead);
if (rowsAffected > 0)
{
if (isRead == "1")
{
result = "The conversation has been marked as read.";
}
else
{
result = "The conversation has been marked as unread.";
}
}
else
{
if (isRead == "1")
{
result = "Error while change the conversation as read.";
}
else
{
result = "Error while change the conversation as unread.";
}
}
}
}
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
}
return(result);
}//The conversation has been moved to the Trash.
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());
}
/// <summary>
/// Payslip inheritance
/// </summary>
/// <param name="sourceUserTypeCode"></param>
/// <param name="userTypes"></param>
/// <returns>copy the payslip meta data from the source region to destination region</returns>
public int PaySlipInheritance(string sourceUserTypeCode, string userTypes)
{
int rowsAffected = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLUser objUser = new DataControl.BLUser();
try
{
List <MVCModels.HiDoctor_Master.UserTypeModel> lstUserTypes = new List <MVCModels.HiDoctor_Master.UserTypeModel>();
if (!string.IsNullOrEmpty(userTypes))
{
string[] arUserTypes;
arUserTypes = userTypes.Split('^');
for (int i = 0; i < arUserTypes.Length; i++)
{
if (!string.IsNullOrEmpty(arUserTypes[i]))
{
MVCModels.HiDoctor_Master.UserTypeModel objUserType = new MVCModels.HiDoctor_Master.UserTypeModel();
objUserType.User_Type_Code = Convert.ToString(arUserTypes[i]);
objUserType.Company_Code = objCurInfo.GetCompanyCode();
lstUserTypes.Add(objUserType);
}
}
}
rowsAffected = objUser.PaySlipInheritance(objCurInfo.GetCompanyCode(), sourceUserTypeCode, lstUserTypes);
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("sourceUserTypeCode", sourceUserTypeCode);
dicObj.Add("userTypes", userTypes);
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
}
return(rowsAffected);
}
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 void ExcuteAsynReport(FormCollection collection)
{
BL_ReportRegion _objBLReport = new BL_ReportRegion();
string userCode = collection["hdnDownload"].ToString();
string startDate = collection["txtFromDate"].ToString();
//string startDate = DateTime.Parse(sd).ToString("yyyy-MM-dd");
//01/04/2016
string endDate = collection["txtToDate"].ToString();
// string endDate = DateTime.Parse(ed).ToString("yyyy-MM-dd");
// string unlistedDoctor = collection["type"].ToString();
string dateSelection = collection["reportType"].ToString();
string MissedDoc = "";
if (collection["missed"] == "MISSED")
{
MissedDoc = "1";
}
else
{
MissedDoc = "0";
}
string UnlistedDoc = "";
if (collection["Unlisted"] == "INCLUDE")
{
UnlistedDoc = "1";
}
else
{
UnlistedDoc = "0";
}
string UserSelection = string.Empty;
// string reportName = collection["title"].ToString();
//string missedDoctor = collection["missed"].ToString();
//string reportViewType = collection["reportViewType"].ToString();
if (userCode.ToUpper() == "ALL")
{
userCode = _objcurrentInfo.GetUserCode();
UserSelection = "ALL";
}
else
{
userCode = userCode.Replace(",,", ",");
}
//string userSelection = collection["type"].ToString();
string userSelection = string.Empty;
string[] stDate = startDate.Split('/');
string[] enDate = endDate.Split('/');
startDate = stDate[2] + "-" + stDate[1] + "-" + stDate[0];
endDate = enDate[2] + "-" + enDate[1] + "-" + enDate[0];
_objBLReport.ExcuteAsynLastSubmitted(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetUserCode(), userCode, startDate, endDate, userSelection, _objcurrentInfo.GetSubDomain(), MissedDoc, UnlistedDoc);
}
public ActionResult BatchCreation()
{
ViewBag.subDomainName = _objCurrentInfo.GetSubDomain();
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.LoginRegionCode = _objCurrentInfo.GetRegionCode();
ViewBag.LoginUserCode = _objCurrentInfo.GetUserCode();
return(View());
}
// Messages
public int GetUnreadMessageCount()
{
int msgCount = 0;
DataControl.BLMessaging objMsg = new DataControl.BLMessaging();
msgCount = objMsg.GetUnreadMessageCount(objCurr.GetCompanyCode(), objCurr.GetUserCode());
return(msgCount);
}
public ActionResult Index()
{
try
{
string managerApprovalPri = string.Empty;
managerApprovalPri = GetpendingDCR();
int TPPendingApprovalUserCount = GetPendingApprovedTPUsersCount();
int SSPendingApprovalUserCount = GetPendingApprovedSSUsersCount();
string regionCode = _objcurrentInfo.GetRegionCode();
ViewBag.CurrentDate = System.DateTime.Now.ToShortDateString();
bool isPayRollIntegrated = _objcurrentInfo.GetPayRollIntegratedStatus();
ViewBag.isPayRollIntegrated = isPayRollIntegrated;
string unApprovedDCRConfigValue = GetUnapprovedDCRCheckConfigValue();
ViewBag.unApprovedDCRCheck = unApprovedDCRConfigValue;
string singleActivityPerDay = GetSingleActivityperday();
string LeaveEntryMode = GetLeaveEntryMode();
ViewBag.singleActivityPerDay = singleActivityPerDay;
ViewBag.LeaveEntryMode = LeaveEntryMode;
ViewBag.TPPendingApprovalUserCount = TPPendingApprovalUserCount;
ViewBag.SSPendingApprovalUserCount = SSPendingApprovalUserCount;
ViewBag.Region_Code = regionCode;
ViewBag.Company_Code = _objcurrentInfo.GetCompanyCode();
//if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
//{
// return View("Index.Mobile");
//}
//if (!string.IsNullOrEmpty(managerApprovalPri))
//{
// return View("PendingApprovalScreen");
//}
//else
//{
// return View();
//}
if (!string.IsNullOrEmpty(managerApprovalPri) || TPPendingApprovalUserCount > 0 || SSPendingApprovalUserCount > 0)
{
if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
{
return(View("PendingApprovalScreen.Mobile"));
}
return(View("PendingApprovalScreen"));;
}
else
{
if (DataControl.CurrentInfo.IsMobile(Request.UserAgent))
{
return(View("Index.Mobile"));
}
return(View());
}
}
catch
{
throw;
}
}
public ActionResult Index()
{
ViewBag.LoginUserCode = _objcurrentInfo.GetUserCode();
ViewBag.todayDate = DateTime.Now.ToString("yyyy/MM/dd");
List <MVCModels.HiDoctor_Master.WeekendGroupModel> lstHolidayMethod = WeekendOffHolidayMethods(_objcurrentInfo.GetCompanyCode());
ViewBag.holidayMethod = lstHolidayMethod.ToArray();
return(View());
}
public bool InsertRegionTypeTree(FormCollection collection)
{
try
{
bool result = true;
string query = "", parentregionTypeCode = "";
int level = 0;
DataSet dsRegionType = new DataSet();
DataRow[] drFilter;
string companyCode = _objcurrentInfo.GetCompanyCode();
dsRegionType = _objSPData.GetRegionTypeMaster(companyCode);
if (dsRegionType.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsRegionType.Tables[0].Rows)
{
if (dr["Region_Type_Code"].ToString() == dr["Under_Region_Type"].ToString())
{
level++;
parentregionTypeCode = dr["Region_Type_Code"].ToString();
}
else
{
drFilter = dsRegionType.Tables[0].Select("Under_Region_Type='" + parentregionTypeCode + "' AND Region_Type_Code <> '" + parentregionTypeCode + "'");
if (drFilter.Length > 0)
{
parentregionTypeCode = drFilter[0]["Region_Type_Code"].ToString();
level++;
}
}
query += "UPDATE tbl_SFA_Region_Type_Master SET Region_Type_Level ='L" + level + "' ,Region_Type_Order =" + level + " WHERE Region_Type_Code='" + dr["Region_Type_Code"].ToString() + "' AND Region_Type_ID='" + dr["Region_Type_ID"].ToString() + "';";
}
if (!string.IsNullOrEmpty(query))
{
query = query.TrimEnd(';');
}
int results = _objSPData.ExecuteStoredProcedure("ExecQuery", query, companyCode);
if (results == 1)
{
result = true;
}
else
{
result = false;
}
return(result);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
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 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>
/// Bind the ExpenseEntityMaster with Html table
/// </summary>
/// <returns></returns>
public string GetExpenseEntityMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
BLMaster Master = new BLMaster();
DataSet dsExpenseEntityMaster = new DataSet();
dsExpenseEntityMaster = Master.GetExpenseEntityMaster(companyCode);
StringBuilder sb = new StringBuilder();
sb.Append("<table WIDTH='75%' id='tblsummary' class='table table-striped' >");
sb.Append("<thead class='active'>");
sb.Append("<tr style='background-color:grey;'>");
sb.Append("<td>Edit</td>");
sb.Append("<td>Change Status</td>");
sb.Append("<td>Entity Name</td>");
sb.Append("<td>Effective From</td>");
sb.Append("<td>Effective To</td>");
sb.Append("<td>Status</td>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
if (dsExpenseEntityMaster != null && dsExpenseEntityMaster.Tables[0] != null && dsExpenseEntityMaster.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsExpenseEntityMaster.Tables[0].Rows.Count; i++)
{
sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>");
sb.Append("<td style='display:none' id='Expense_Entity_Code" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Code"].ToString() + "</td>");
sb.Append("<td id='Expense_Entity_Name" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Name"].ToString() + "</td>");
sb.Append("<td id='Effective_From" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_From"].ToString() + "</td>");
sb.Append("<td id='Effective_To" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_To"].ToString() + "</td>");
sb.Append("<td id='Row_Status" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Row_Status"].ToString() + "</td></tr>");
}
}
else
{
sb.Append("<tr><td>No records To Display</td></tr>");
}
sb.Append("</body>");
sb.Append("</table>");
return(sb.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(ex.Message.ToString());
}
}
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));
}
/// <summary>
/// get the selected message details
/// </summary>
/// <param name="msgCode"></param>
/// <returns>returns the selected message details in the form of json </returns>
public string GetSelectedMsgDetails(string msgCode, string TargetAddress)
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLMessaging objMsg = new DataControl.BLMessaging();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataControl.Repository.AzureBlobUpload objAzureUpload = new DataControl.Repository.AzureBlobUpload();
DataControl.Abstraction.IFileProvider objPathProv = new DataControl.Impl.FileSystemProvider();
string accKey = objPathProv.GetConfigValue("NBFILES");
string blobURL = accKey + objCurInfo.GetCompanyCode().ToLower();
return(objJson.Serialize(objMsg.GetSelectedMsgDetails(objCurInfo.GetCompanyCode(), msgCode, TargetAddress)) + "~" + blobURL);
}
/// <summary>
/// Bind the RegionCategory with Html
/// </summary>
/// <returns></returns>
public string GetRegionCategoryMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
BLMaster Master = new BLMaster();
DataSet dsRegionCategory = new DataSet();
dsRegionCategory = Master.GetRegionCategory(companyCode);
StringBuilder sb = new StringBuilder();
//sb.Append("<table WIDTH='50%' id='tblsummary' class='table table-striped' >");
//sb.Append("<thead class='active'>");
//sb.Append("<tr style='background-color:#428bca;'>");
//sb.Append("<td>Edit</td>");
////sb.Append("<td>Change Status</td>");
//sb.Append("<td>Region Category Name</td>");
//sb.Append("<td>Status</td>");
//sb.Append("</tr>");
//sb.Append("</thead>");
//sb.Append("<tbody>");
////
//if (dsRegionCategory != null && dsRegionCategory.Tables[0] != null && dsRegionCategory.Tables[0].Rows.Count > 0)
//{
// for (int i = 0; i < dsRegionCategory.Tables[0].Rows.Count; i++)
// {
// sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>");
// // sb.Append("<tr><td class='td-b'><b id='D" + i + "' onclick='fnChange(this)'>Change Status</b></td>");
// sb.Append("<td style='display:none' id='Region_Classification_Code" + i + "'>" + dsRegionCategory.Tables[0].Rows[i]["Region_Classification_Code"] + "</td>");
// sb.Append("<td id='Region_Classification_Name" + i + "'>" + dsRegionCategory.Tables[0].Rows[i]["Region_Classification_Name"] + "</td>");
// sb.Append("<td id='Record_Status" + i + "'>" + dsRegionCategory.Tables[0].Rows[i]["Record_Status"] + "</td></tr>");
// }
//}
//else
//{
// sb.Append("<tr><td>No records To Display</td></tr>");
//}
//sb.Append("</tbody>");
//sb.Append("</table>");
DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
return(_objJson.Serialize(dsRegionCategory));
}
catch (Exception ex)
{
//Dictionary<string, string> dicContext = new Dictionary<string, string>();
//dicContext.Add("Filter:CompanyCode", companyCode);
//DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
//return ex.Message.;
throw (ex);
}
}
/// <summary>
/// Returns a table string of All SubRegion Master
/// </summary>
/// <returns></returns>
public string GetSubRegionMaster()
{
string companyCode = _objcurrentInfo.GetCompanyCode();
try
{
StringBuilder strTbl = new StringBuilder();
BLMaster _objBlMaster = new BLMaster();
List <SubRegionMasterModel> lstSubRegionMaster = _objBlMaster.GetSubRegionMaster(companyCode).ToList();
if (lstSubRegionMaster != null && lstSubRegionMaster.Count() > 0)
{
strTbl.Append("<div class='table-responsive'>");
strTbl.Append("<table class='table table-striped' id='tblSubRegion' cellspacing='0' cellpadding='0'>");
strTbl.Append("<thead>");
strTbl.Append("<tr>");
strTbl.Append("<th>Edit</th>");
strTbl.Append("<th>Change Status</th>");
strTbl.Append("<th>Sub Region Name</th>");
strTbl.Append("<th>Under Region</th>");
strTbl.Append("<th>Status</th></tr>");
strTbl.Append("</thead>");
strTbl.Append("<tbody>");
int rowCount = 0;
foreach (var subRegion in lstSubRegionMaster)
{
strTbl.Append("<tr id='" + rowCount + "'>");
strTbl.Append("<td ><a href='#' onclick='fnEditSubRegionMaster(\"" + subRegion.SubRegion_Code + "|" + subRegion.SubRegion_Name + "|" + subRegion.UnderRegion_Code + "|" + subRegion.UnderRegion + "\");'>Edit</a></td>");
strTbl.Append("<td ><a href='#' onclick='fnChangestatusSubRegionMaster(\"" + subRegion.SubRegion_Code + "|" + subRegion.SubRegion_Status + "\");'>Change Status</a></td>");
strTbl.Append("<td>" + subRegion.SubRegion_Name + "</td>");
strTbl.Append("<td>" + subRegion.UnderRegion + "</td>");
strTbl.Append("<td>" + subRegion.SubRegion_Status + "</td>");
strTbl.Append("<tr>");
}
}
else
{
strTbl.Append("No Records To Display.");
}
strTbl.Append("</tbody>");
strTbl.Append("</table></div>");
return(strTbl.ToString());
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return("FAIL^" + ex.Message);
}
}
public int InsertCampaignPlanner(string regionCode, string regionName, string cpName, string categoryCode, string categoryName,
string sfcDetails, string doctorDetails, string Mode, string CPCode, string workArea, string CPStatus, string EditPrivilege)
{
int rowsAffected = 0;
try
{
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
DataControl.BLCampaignPlanner _objBlCP = new DataControl.BLCampaignPlanner();
rowsAffected = _objBlCP.InsertCampaignPlanner(_objCurInfo.GetCompanyCode(), regionCode, regionName, cpName, categoryCode,
categoryName, sfcDetails, doctorDetails,
Mode, CPCode, _objCurInfo.GetUserName(), workArea, CPStatus, EditPrivilege);
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("regionCode", regionCode);
dicObj.Add("regionName", regionName);
dicObj.Add("cpName", cpName);
dicObj.Add("categoryCode", categoryCode);
dicObj.Add("categoryName", categoryName);
dicObj.Add("sfcDetails", sfcDetails);
dicObj.Add("doctorDetails", doctorDetails);
dicObj.Add("Mode", Mode);
dicObj.Add("CPCode", CPCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
}
return(rowsAffected);
}
public ActionResult RCPABatchIndex()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
ViewBag.Companycode = objCurInfo.GetCompanyCode();
ViewBag.ErrorCode = "";
return(View());
}
private DataTable ConvertCCMExcelToDataTable(System.Web.HttpPostedFileBase postedFile)
{
IFileProvider fileProvider = new FileSystemProvider();
IExcelFactory excelFactory = new ExcelFactory();
CurrentInfo objCurInfo = new CurrentInfo();
string containerName = objCurInfo.GetCompanyCode().ToLower();
string fileName = postedFile.FileName;
string[] excelRetrieveColumns = new string[] { "Row_No", "Customer_Name", "Sur_Name", "Speciality_Name", "Gender", "Qualification", "Address1",
"Address2", "Local_Area", "Pin_Code", "City", "State", "Country", "Phone", "Mobile", "Fax", "Email", "Hospital_Name", "Hospital_Classification",
"DOB", "Anniversary_Date", "Registration_No" };
_CCMExcelTemplateFileName = fileProvider.GetFilePathToSave(UPLOAD_PATH_KEY_NAME, fileName);
string whereQuery = " LEN(Customer_Name) >0 ";
DataControl.Repository.AzureBlobUpload objAzureUpload = new Repository.AzureBlobUpload();
DataControl.Abstraction.IFileProvider objPathProv = new DataControl.Impl.FileSystemProvider();
string accKey = objPathProv.GetConfigValue("UPLOADEDFILEBLOBACCKEY");
string blobURL = objAzureUpload.PutAzureBlobStorage(postedFile.InputStream, postedFile.FileName, accKey, containerName);
System.IO.Stream stream = objAzureUpload.AzureblockDownload(postedFile.FileName, accKey, containerName);
DataTable dt = new DataTable();
dt = objAzureUpload.ConvertStreamToDataTable(stream, "Customer_Name");
return(dt);
}
public PartialViewResult ChemistDetails()
{
ViewBag.CompanyCode = _objCurrentInfo.GetCompanyCode();
ViewBag.UserCode = _objCurrentInfo.GetUserCode();
ViewBag.RegionCode = _objCurrentInfo.GetRegionCode();
return(PartialView());
}
/// <summary>
/// Method is Used To get the User details for HidoctorStartDate
/// </summary>
/// <returns></returns>
private IEnumerable <MVCModels.HiDoctor_Master.UserModel> GetHidoctorStartDate()
{
try
{
MVCModels.HiDoctor_Master.UserModel objHidoctorstartdate = new MVCModels.HiDoctor_Master.UserModel();
BLMaster objMaster = new BLMaster();
objHidoctorstartdate.Company_Code = _objcurrentInfo.GetCompanyCode();
return(objMaster.GetHidoctorStartdateDetails(objHidoctorstartdate));
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
return(null);
}
}
public string RegionChangeStatus(string regionTypeCode, string ChangeStatus)
{
try
{
string result = "";
string statusChange = "0";
if (ChangeStatus == "0")
{
statusChange = "1";
}
else
{
statusChange = "0";
}
DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
string updatedDate = System.DateTime.Now.ToString("yyyy-MM-dd");
string status = _objBlmaster.RegionChangeStatus(_objCurrentInfo.GetCompanyCode(), regionTypeCode, statusChange, _objCurrentInfo.GetUserCode(), updatedDate);
result = status.ToString();
return(result);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:RegionTypeCode", regionTypeCode);
dicContext.Add("Filter:ChangeStatus", ChangeStatus);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
throw new Exception("Sorry an error occurred. Please try again later");
}
}
public ActionResult Index()
{
_objCurrentInfo = new CurrentInfo();
ViewBag.Company_Code = _objCurrentInfo.GetCompanyCode();
ViewBag.User_Code = _objCurrentInfo.GetUserCode();
return(View());
}
public string GetUnderUserTypes()
{
StringBuilder strContent = new StringBuilder();
try
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
string userCode = objCurInfo.GetUserCode();
string companyCode = objCurInfo.GetCompanyCode();
List <MVCModels.HiDoctor_Master.UserTypeModel> lstUserType = new List <MVCModels.HiDoctor_Master.UserTypeModel>();
lstUserType = _objBLDcrStatusMaster.GetUnderUserTypes(companyCode, userCode).ToList();
strContent.Append("<option value=''>-Select User Type-</option>");
if (lstUserType.Count > 0)
{
foreach (var dr in lstUserType)
{
strContent.Append("<option value='" + dr.User_Type_Code + "'>" + dr.User_Type_Name + "</option>");
}
}
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
}
return(strContent.ToString());
}
public JsonResult GetUserTypeActivityMap()
{
DataControl.BLUser _objBluser = new DataControl.BLUser();
DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
return(Json(_objBluser.GetUserTypeActivityMapdata(_objCurrentInfo.GetCompanyCode()), JsonRequestBehavior.AllowGet)); //GetUserTypeActivityMaptable(ds);
}
public string GetDoctorSufPreColumns()
{
IConfigSettings IConfig_Settings = new Config_Settings();
_objCurrentInfo = new CurrentInfo();
return(IConfig_Settings.GetConfigDefaultValue(_objCurrentInfo.GetCompanyCode(), CONFIG_TYPE.DCR, CONFIG_KEY.DCR_DOCTOR_SUFIX_COLUMNS));
}
public JsonResult GetNotification(FormCollection collection)
{
try
{
DataSet dsCategory = new DataSet();
objData.OpenConnection(objCurr.GetCompanyCode());
{
dsCategory = objData.ExecuteDataSet("exec SP_mhdGetNotification '" + objCurr.GetCompanyCode() + "','" + objCurr.GetUserCode() + "'");
}
return(Json(_objJson.Serialize(dsCategory), JsonRequestBehavior.AllowGet));
}
finally
{
objData.CloseConnection();
}
}
