public string Index(FormCollection form) { string result = ""; HttpPostedFileBase file = Request.Files[0]; DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); MVCModels.RCPA_Header objrcpaHeader = new MVCModels.RCPA_Header(); objrcpaHeader.Company_Id = Convert.ToInt32(_objCurInfo.GetCompanyId()); objrcpaHeader.Company_code = _objCurInfo.GetCompanyCode(); objrcpaHeader.user_code = _objCurInfo.GetUserCode(); // objrcpaHeader.Region_Code = _objCurInfo.GetRegionCode(); // objrcpaHeader.PeriodTo = DateTime.Now; //objrcpaHeader.PeriodFrom = DateTime.Now; try { DateTime dt = DateTime.ParseExact(Request.Form["txtPeriodFrom"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objrcpaHeader.PeriodFrom = Convert.ToDateTime(dt.ToString("yyyy-MM-dd")); dt = DateTime.ParseExact(Request.Form["txtPeriodTo"].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objrcpaHeader.PeriodTo = Convert.ToDateTime(dt); objrcpaHeader.Region_Code = Request.Form["hdnRegion_Code"].ToString(); string subDomain = _objCurInfo.GetSubDomain(); result = _objBLRCPACompetator.RCPAExcelBulkAddResult(subDomain, _objCurInfo.GetCompanyCode(), _objCurInfo.GetRegionCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode(), objrcpaHeader); ViewBag.ErrorCode = result; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); ViewBag.Companycode = objCurInfo.GetCompanyCode(); ViewBag.RegionCode = objCurInfo.GetRegionCode(); } catch (Exception ex) { result = ex.Message; } return(result); }
public ActionResult RCPABatchIndex() { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); ViewBag.Companycode = objCurInfo.GetCompanyCode(); ViewBag.ErrorCode = ""; return(View()); }
public string GetUserType() { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); string getusertypename = _objCurInfo.GetUserTypeName(); return(getusertypename); }
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 ActionResult Index() { _objCurrentInfo = new CurrentInfo(); ViewBag.Company_Code = _objCurrentInfo.GetCompanyCode(); ViewBag.User_Code = _objCurrentInfo.GetUserCode(); return(View()); }
public int GetDCREntryBasedOnPrivilege(string dcrDate, string flag) { int result = 1; try { _objSPData = new SPData(); _objcurrentInfo = new CurrentInfo(); string company_Code = _objcurrentInfo.GetCompanyCode(); string user_Code = _objcurrentInfo.GetUserCode(); if (flag == "FIELD" || flag == "FIELD_RCPA") { flag = "F"; } else if (flag == "ATTENDANCE") { flag = "A"; } else { flag = "L"; } result = _objSPData.GetDCREntryBasedOnPrivilege(company_Code, user_Code, dcrDate, flag); } catch (Exception ex) { throw ex; } return(result); }
public string TypeInsert(FormCollection collection) { string strQry = string.Empty; string result = string.Empty; string expenseGroup = collection["ExpenseGroup"]; int rowCount = int.Parse(collection["rowCount"]); string type = collection["Type"]; DataControl.CurrentInfo _ObjCurInfo = new DataControl.CurrentInfo(); Models.ExpensesMapping objExpensesMapping = new Models.ExpensesMapping(); if (type == "Region") { for (int i = 1; i <= rowCount - 1; i++) { strQry += "Exec SP_hdUpdateExpenseGroupInRegionMaster '" + collection["cbk_" + i.ToString()] + "','" + expenseGroup + "','" + collection["Checked_" + i.ToString()] + "','" + _ObjCurInfo.GetCompanyCode() + "';"; //objExpensesMapping.RegionExpenseInsert(collection["cbk_" + i.ToString()], ExpenseGroup, collection["Checked_" + i.ToString()]); } result = objExpensesMapping.ExpenseMappingInsert(strQry); } else if (type == "User") { for (int i = 1; i <= rowCount - 1; i++) { strQry += "Exec SP_hdUpdateExpenseGroupInUserMaster '" + collection["cbk_" + i.ToString()] + "','" + expenseGroup + "','" + collection["Checked_" + i.ToString()] + "','" + _ObjCurInfo.GetCompanyCode() + "';"; //objExpensesMapping.UserExpenseInsert(collection["cbk_" + i.ToString()], ExpenseGroup, collection["Checked_" + i.ToString()]); } result = objExpensesMapping.ExpenseMappingInsert(strQry); } return(result); }
public string InsertProjectActivityMapping(string projectcode, string activityCode, string startDate, string endDate) { try { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMaster _objBlMaster = new DataControl.BLMaster(); string createdBy = _objCurInfo.GetUserName(); return(_objBlMaster.InsertSalesActivityMapping(_objCurInfo.GetCompanyCode(), projectcode, activityCode, startDate, endDate, createdBy, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"))); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("ProjectCode", projectcode); dicObj.Add("ActivityCode", activityCode); dicObj.Add("StartDate", startDate); dicObj.Add("EndDate", endDate); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return("ERROR: " + ex.Message.ToString()); } }
public string UpdateSalesActivityMapping(string nprojectcode, string nactivityCode, string oprojectcode, string oactivityCode, string startDate, string endDate, string mode, string status) { try { DataControl.BLMaster _objBlMaster = new DataControl.BLMaster(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); return(_objBlMaster.UpdateSalesActivityMapping(_objCurInfo.GetCompanyCode(), nprojectcode, nactivityCode, oprojectcode, oactivityCode, mode, status, startDate, endDate, _objCurInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"))); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("NProjectCode", nprojectcode); dicObj.Add("NActivityCode", nactivityCode); dicObj.Add("OProjectCode", oprojectcode); dicObj.Add("OActivityCode", oactivityCode); dicObj.Add("Mode", mode); dicObj.Add("Status", status); dicObj.Add("StartDate", startDate); dicObj.Add("EndDate", endDate); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return("ERROR: " + ex.Message.ToString()); } }
public void GetHolidayExcelDownload(FormCollection coll) { string blobUrl = string.Empty, error = string.Empty; DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); string holidayDate = string.Empty; if (!string.IsNullOrEmpty(coll["hdnSearchDate"])) { holidayDate = Convert.ToString(coll["hdnSearchDate"]); } try { System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; DataControl.CurrentInfo _objCurr = new DataControl.CurrentInfo(); string content = GetSearchHolidayDetails(holidayDate); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string userName = _objCurr.GetUserName(); string subDomin = _objCurr.GetSubDomain(); string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(content.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); } }
public int HolidayInheritance(string sourceRegion, string destinationRegions) { int rowsAffected = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); try { List <MVCModels.HiDoctor_Master.RegionModel> lstRegion = new List <MVCModels.HiDoctor_Master.RegionModel>(); DataControl.BLRegion objRegion = new DataControl.BLRegion(); if (!string.IsNullOrEmpty(destinationRegions)) { string[] ar = destinationRegions.Split(','); foreach (var region in ar) { if (!string.IsNullOrEmpty(region)) { MVCModels.HiDoctor_Master.RegionModel objRegionModel = new MVCModels.HiDoctor_Master.RegionModel(); objRegionModel.Region_Code = region; lstRegion.Add(objRegionModel); } } rowsAffected = objRegion.HolidayInheritance(objCurInfo.GetCompanyCode(), sourceRegion, lstRegion, objCurInfo.GetUserName(), System.DateTime.Now.ToString("yyyy-MM-dd")); } } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); return(0); } return(rowsAffected); }
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 GetSearchHolidayDetails(string holidayDate) { int count = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLRegion objRegion = new DataControl.BLRegion(); IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null; string date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0]; lstHoliday = objRegion.GetHolidayDetailsByDate(objCurInfo.GetCompanyCode(), date); StringBuilder strContent = new StringBuilder(); strContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Date</td><td>Holiday Name</td>"); strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>"); if (lstHoliday != null) { int i = 0; foreach (var dr in lstHoliday) { i++; strContent.Append("<tr><td>" + i + "</td>"); strContent.Append("<td>" + dr.Holiday_Date + "</td>"); strContent.Append("<td>" + dr.Holiday_Name + "</td>"); strContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></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("</tbody></table>"); return(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 string GetLeaveEntryMode() { _objcurrentInfo = new CurrentInfo(); string Leave_Entry_Mode = _objcurrentInfo.GetPrivilegeValue("LEAVE_ENTRY_MODE", "FULL_DAY"); return(Leave_Entry_Mode); }
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 JsonResult CheckTPAvailableForSelectedDCRDates(string DCRDates) { try { _objSPData = new SPData(); _objcurrentInfo = new CurrentInfo(); string company_Code = _objcurrentInfo.GetCompanyCode(); string user_Code = _objcurrentInfo.GetUserCode(); string region_Code = _objcurrentInfo.GetRegionCode(); List <string> lstDCRDates = _objSPData.CheckTPAvailableForSelectedDCRDates(company_Code, user_Code, region_Code, DCRDates); // List<string> DCR_Dates = DCRDates.Split('^').ToList(); // DCR_Dates = DCR_Dates.Where(d => d != "").ToList(); // //compare two list and return not matching items using linq //List<string> lstDCRDatesWithoutPlan = DCR_Dates.Except(lstDCRDates).ToList(); if (lstDCRDates != null) { return(Json(lstDCRDates)); } return(null); } catch { throw; } }
/// <summary> /// Get the all type message count /// </summary> /// <returns>retuns the unread, drafted and trash count</returns> public string GetMsgCount() { string unreadCount = string.Empty; string draftedCount = string.Empty; string trashCount = string.Empty; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMessaging objMsg = new DataControl.BLMessaging(); try { DataSet ds = new DataSet(); ds = objMsg.GetMessageCount(objCurInfo.GetCompanyCode(), objCurInfo.GetUserCode()); if (ds.Tables.Count > 0) { unreadCount = Convert.ToString(ds.Tables[0].Rows[0][0]); if (ds.Tables.Count > 1) { draftedCount = Convert.ToString(ds.Tables[1].Rows[0][0]); if (ds.Tables.Count > 2) { trashCount = Convert.ToString(ds.Tables[2].Rows[0][0]); } } } } catch (Exception ex) { DataControl.Impl.ExceptionHandler.WriteLog(ex, null); } return(unreadCount + "~" + draftedCount + "~" + trashCount); }
/// <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 string UpdateAttachmentPath(string msgCode, string fileName, string columnName, string fileRemoved) { string result = string.Empty; try { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMessaging objMsg = new DataControl.BLMessaging(); int rowsAffected = objMsg.UpdateAttachmentPath(objCurInfo.GetCompanyCode(), fileName, columnName, msgCode, fileRemoved); if (rowsAffected > 0) { result = "SUCCESS:"; } else { result = "ERROR:"; } } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); result = "Sorry. Error while update the attachment file ..."; } return(result); }
/// <summary> /// Insert User ProductMapping /// </summary> /// <param name="userCodes"></param> /// <param name="productCodes"></param> /// <returns></returns> public string InsertUserProductMapping(string userCodes, string productCodes) { int result = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string companyCode = _objcurrentInfo.GetCompanyCode(); BLMaster _objMaster = new BLMaster(); StringBuilder strBuild = new StringBuilder(); string currentDate = DateTime.Now.ToString("yyyy-MM-dd"); try { result = _objMaster.InsertUserProduct(companyCode, userCodes, productCodes, currentDate); if (result > 0) { strBuild.Append("User Product Mapped Sucessfully."); } else { strBuild.Append("This User Product Already Mapped"); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("userCodes", userCodes); dicContext.Add("productCodes", productCodes); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(null); } return(strBuild.ToString()); }
public ActionResult OBOUserRegionMapping() { DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo(); ViewBag.Cur_Region_Code = _objcurrentInfo.GetRegionCode(); ViewBag.Cur_User_Code = _objcurrentInfo.GetUserCode(); return(View()); }
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 NewLeaveEntry(string SSID) { if (!string.IsNullOrEmpty(SSID)) { string parameters = System.Text.ASCIIEncoding.ASCII.GetString(System.Convert.FromBase64String(SSID)); DieticianModel obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DieticianModel>(parameters); ViewBag.CompanyCode = obj.Company_Code; ViewBag.RegionCode = obj.Region_Code; ViewBag.UserCode = obj.User_Code; ViewBag.UserTypeCode = obj.User_Type_Code; ViewBag.UserName = obj.User_Name; ViewBag.RegionName = obj.Region_Name; ViewBag.latitude = obj.latitude; ViewBag.longitude = obj.longitude; } else { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); ViewBag.Companycode = objCurInfo.GetCompanyCode(); ViewBag.Usercode = objCurInfo.GetUserCode(); ViewBag.RegionCode = objCurInfo.GetRegionCode(); ViewBag.UserTypecode = objCurInfo.GetUserTypeCode(); ViewBag.UserName = objCurInfo.GetUserName(); } return(View()); }
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 JsonResult GetUserTypeName() { DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo(); DataControl.BLMaster _objBlmaster = new DataControl.BLMaster(); DivisionUserProducts objDivUserProduct = new DivisionUserProducts(); objDivUserProduct.Company_Code = _objcurrentInfo.GetCompanyCode(); objDivUserProduct.User_Code = _objcurrentInfo.GetUserCode(); try { IEnumerable <DivisionUserProducts> lstDiv = _objBlmaster.GetUserTypeNames(objDivUserProduct); var division = (from div in lstDiv.AsEnumerable() select new DivisionUserProducts() { User_Type_Code = div.User_Type_Code.ToString(), User_Type_Name = div.User_Type_Name.ToString() }).ToList <DivisionUserProducts>(); return(Json(division)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", objDivUserProduct.Company_Code); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(Json("Sorry an error occured. Please try again later.")); } }
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 int InsertUserProduct(string userCode, string productCode, string minCounts, string maxCounts) { DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string companyCode = objCurInfo.GetCompanyCode(); userCode = userCode + ','; string currentDate = DateTime.Now.ToString("yyyy-MM-dd"); try { int result = _objMapping.InsertDivisionUserProductMapping(companyCode, userCode, productCode, minCounts, maxCounts); //int result = _objMapping.InsertDivUserProducts(companyCode, userCode, productCode, currentDate); return(result); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", companyCode); dicContext.Add("Filter:UserCode", userCode); dicContext.Add("Filter:ProductCode", productCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
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()); }
/// <summary> /// Retrieve the KYD List. /// </summary> /// <param name="dcrDate"></param> /// <param name="Key_Column"></param> /// <returns></returns> public List <KYDModel> GetKYDCustomerList(string dcrDate, string Key_Column) { try { // Creates instance. _blKYD = new BL_KYD(); _objCurr = new CurrentInfo(); string company_Code = _objCurr.GetCompanyCode(); string user_Code = _objCurr.GetUserCode(); // Reterievs the KYD Customer list. IEnumerable <KYDModel> IlstKYDCustomers = _blKYD.GetKYDCustomerList(company_Code, user_Code, dcrDate, Key_Column); if (IlstKYDCustomers != null) { List <KYDModel> lstKYDCustomers = IlstKYDCustomers.ToList(); return(lstKYDCustomers); } else { return(null); } } catch { throw; } }