public double CalculateSFCFare(Models.FareCalculationDTO fareCalcPassed, double distance, string travelmode, string entity, string sumDistance) { double totalFare = 0.0; DataControl.BL_DCRStockiestExpense objExp = new DataControl.BL_DCRStockiestExpense(); DataControl.CurrentInfo objCurr = new DataControl.CurrentInfo(); DataSet dsDistanceMatrix = new DataSet(); string companyCode = objCurr.GetCompanyCode(); string userTypeCode = objCurr.GetUserTypeCode(); double fromKm = 0.0; double toKm = 0.0; double fare = 0.0; double total = 0.0; int j = 0; dsDistanceMatrix = objExp.GetDistanceMatrixForFareCalculation(companyCode, userTypeCode, fareCalcPassed.Entity, travelmode, fareCalcPassed.DcrDate); if (dsDistanceMatrix.Tables[0].Rows.Count > 0) { total = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[0][1].ToString()) * Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[0][2].ToString()); dsDistanceMatrix.Tables[0].Rows[0]["Fare"] = total.ToString(); dsDistanceMatrix.Tables[0].AcceptChanges(); total = 0.0; // This For loop is to calculate total for (j = 1; j <= dsDistanceMatrix.Tables[0].Rows.Count - 1; j++) { // ((70-30)*1.75)+60 = 130 fromKm = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[j - 1]["To_Km"].ToString()); // from km=30 toKm = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[j]["To_Km"].ToString()); // to km=70 fare = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[j]["Fare_Amount"].ToString()); // amount for this limit =1.75 total = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[j - 1]["Fare"].ToString()); // total of previous limit = 60 total = ((toKm - fromKm) * fare) + total; // total of current limit = 130 dsDistanceMatrix.Tables[0].Rows[j]["Fare"] = total.ToString(); dsDistanceMatrix.Tables[0].AcceptChanges(); } } // fare calculation for (int k = 0; k <= dsDistanceMatrix.Tables[0].Rows.Count - 1; k++) { // ((66-30)*1.75)+60 = 123 fromKm = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[k]["From_Km"].ToString().Trim()); toKm = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[k]["To_Km"].ToString().Trim()); if (distance >= fromKm && distance <= toKm) { if (k != 0) { fare = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[k]["Fare_Amount"].ToString().Trim()); // 1.75 toKm = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[k - 1]["To_Km"].ToString().Trim()); // 30 total = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[k - 1]["Fare"].ToString().Trim()); // 60 total = ((distance - toKm) * fare) + total; // 123 totalFare += total; break; } else { if (entity.Trim().ToUpper() == "HQ") { if (dsDistanceMatrix.Tables[0].Rows[0]["Is_Amount_Fixed"].ToString().Trim() == "1") { distance = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[0]["To_Km"].ToString().Trim()); } } fare = Convert.ToDouble(dsDistanceMatrix.Tables[0].Rows[0]["Fare_Amount"].ToString().Trim()); total = distance * fare; totalFare += total; break; } } } return(totalFare); }
/// <summary> /// Converts DCR Activity Lock list to HTML Table format. /// </summary> /// <param name="lstDCRActivityLockModel"></param> /// <returns></returns> private StringBuilder ActivityLockHTMLString(List <DCRActivityLockModel> lstDCRActivityLockModel) { StringBuilder activityLockString = new StringBuilder(); string type = "[null, { type: 'date-range' }, { type: 'text' }, { type: 'text' }]"; if (lstDCRActivityLockModel != null && lstDCRActivityLockModel.Count > 0) { //activityLockString.Append("<a href='#'id='lnkFilter' onclick='fnToggleFilter()'>Show Filter</a>"); activityLockString.Append("<table cellspacing='0' cellpadding='0' class='data display datatable' width='105%' id='tblActivityLock' >"); activityLockString.Append("<thead>"); activityLockString.Append("<tr id='lockFilter' style='display:none' >"); activityLockString.Append("<th ></th>"); activityLockString.Append("<th >User Name</th>"); activityLockString.Append("<th >Locked Date</th>"); activityLockString.Append("<th >DCR Date</th>"); activityLockString.Append("<th >Actvity Type</th>"); activityLockString.Append("<th >Unapproval Reason</th>"); activityLockString.Append("<th >Unapproved By</th>"); activityLockString.Append("<th style='text-align:left'>Request Released By</th>"); activityLockString.Append("<th style='text-align:left;padding-right:7%;'>Released Reason</th>"); activityLockString.Append("</tr>"); activityLockString.Append("<tr >"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'><input type='checkbox' id='chk_0' onclick='fnSelectAll()' /><label for='chk_0'></label></th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>User Name</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>Locked Date</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>DCR Date</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>Actvity Type</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>Unapproval Reason</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>Unapproved By</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;'>Request Released By</th>"); activityLockString.Append("<th style='background: #5E87B0 !important;color: #fff !important;text - align:center !important;padding-right:7%;'>Released Reason</th>"); activityLockString.Append("</tr>"); activityLockString.Append("</thead>"); activityLockString.Append("<tbody>"); List <MVCModels.ReportedUser> lstReported = new List <MVCModels.ReportedUser>(); DataControl.HD_MasterFactoryClasses.BL_UsercreationWizard _objUserCreation = new DataControl.HD_MasterFactoryClasses.BL_UsercreationWizard(); DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo(); lstReported = _objUserCreation.GetReportedMangers(_objcurrentInfo.GetCompanyCode(), lstDCRActivityLockModel[0].User_Code, _objcurrentInfo.GetUserCode()).ToList(); string list = ""; foreach (var item in lstReported) { if (item.User_Code == _objcurrentInfo.GetUserCode()) { list += "<option selected='selected' value='" + item.User_Code + "'>" + item.User_Name + "</option>"; } else { list += "<option value='" + item.User_Code + "'>" + item.User_Name + "</option>"; } } int index = 0; foreach (DCRActivityLockModel activityLock in lstDCRActivityLockModel) { index++; activityLockString.Append("<tr id='trActivity_" + index + "'>"); activityLockString.Append("<td valign='top' align='left' width='3%' > "); activityLockString.Append("<input name='chkUserSelect' class='checkboxclass' type='checkbox' id='chk_" + index.ToString() + "' name='checkbox'>"); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' id='dcruser_" + index.ToString() + "' width='10%'>"); activityLockString.Append(activityLock.User_Name); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' id='dcrlock_" + index.ToString() + "' width='10%'>"); activityLockString.Append(activityLock.Locked_Date); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' id='dcrDate_" + index.ToString() + "' width='10%'>"); activityLockString.Append(activityLock.DCR_Actual_Date); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' id='dcrFlag_" + index.ToString() + "' width='10%'>"); activityLockString.Append(activityLock.Activity_Flag); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' width='18%'>"); activityLockString.Append(activityLock.Unapprove_Reason); activityLockString.Append("</td>"); activityLockString.Append("<td align='left' width='10%'>"); activityLockString.Append(activityLock.Unapproved_by); activityLockString.Append("</td>"); string ddl = "<select id='ddluser_code_" + index.ToString() + "'><option value='0'>-Select-</option>" + list; ddl += "</select>"; activityLockString.Append("<td>" + ddl + "</td>"); activityLockString.Append("<td><textarea id='txtReason_" + index.ToString() + "' maxlength='250'>-Nil-</textarea></td>"); activityLockString.Append("</tr>"); } activityLockString.Append("</tbody></table>"); } StringBuilder strTableHTMLString = new StringBuilder(); if (activityLockString.Length > 0) { strTableHTMLString.Append(activityLockString); strTableHTMLString.Append("$$"); strTableHTMLString.Append(type); } return(strTableHTMLString); }
public string GetAllNoticesReadDetail() { DataControl.CurrentInfo objCur = new DataControl.CurrentInfo(); string companyCode = objCur.GetCompanyCode(); string userCode = objCur.GetUserCode(); try { StringBuilder sbTableContent = new StringBuilder(); DataControl.HiDoctor_ActivityFactoryClasses.BL_NoticeBoard _objBlActivity = new DataControl.HiDoctor_ActivityFactoryClasses.BL_NoticeBoard(); DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo(); IEnumerable <MVCModels.NoticeBoardContentModel> lstdata = null; lstdata = _objBlActivity.GetNoticeBoarddetail(companyCode, userCode); sbTableContent.Append("</div>"); sbTableContent.Append("<table id='NoticeBoardRead' class='table table-striped' >"); sbTableContent.Append("<thead class='active'>"); sbTableContent.Append("<tr><td>Title</td>"); sbTableContent.Append("<td>ActiveFrom</td>"); sbTableContent.Append("<td>ActiveTo</td>"); sbTableContent.Append("<td>Author</td>"); sbTableContent.Append("<td>IsRead</td></tr>"); sbTableContent.Append("</thead>"); if (lstdata.ToList().Count > 0) { foreach (var item in lstdata) { if (item.Is_Read.ToString() == "No") { sbTableContent.Append("<tr style='font-weight:bold;font-style:italic;color:rgb(52, 172, 52)'><td><span onclick=\"GetNoticepopup('" + item.Msg_Code + "')\" style='text-decoration:underline;cursor:pointer'>" + item.Title + "</span></td>"); sbTableContent.Append("<td>" + item.Active_From + "</td>"); sbTableContent.Append("<td>" + item.Active_To + "</td>"); sbTableContent.Append("<td>" + item.Employee_Name + "(" + item.Author + ")</td>"); sbTableContent.Append("<td>" + item.Is_Read + "</td></tr>"); } else { sbTableContent.Append("<tr><td><span onclick=\"GetNoticepopup('" + item.Msg_Code + "')\" style='text-decoration:underline;cursor:pointer'>" + item.Title + "</span></td>"); sbTableContent.Append("<td>" + item.Active_From + "</td>"); sbTableContent.Append("<td>" + item.Active_To + "</td>"); sbTableContent.Append("<td>" + item.Employee_Name + "(" + item.Author + ")</td>"); sbTableContent.Append("<td>" + item.Is_Read + "</td></tr>"); } } } else { sbTableContent.Append("No records found"); } return(sbTableContent.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:CompanyCode", companyCode); dicContext.Add("Filter:UserCode", userCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); throw new Exception("Sorry an error occurred. Please try again later"); throw ex; } }
public JsonResult GetPriceGroupMappedCustomers(string regionCode, string entity) { StringBuilder strContent = new StringBuilder(); DataControl.BL_Customer objCutomer = new DataControl.BL_Customer(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); List <MVCModels.HiDoctor_Master.DoctorModel> lstCustomer = new List <MVCModels.HiDoctor_Master.DoctorModel>(objCutomer.GetCustomersByRegionAndEntity(objCurInfo.GetCompanyCode(), regionCode, entity)); return(Json(_objJson.Serialize(lstCustomer))); }
public double CalculateSFCFare(Models.FareCalculationDTO fareCalcPassed) { try { double totalFare = 0.0; string hopNeed = fareCalcPassed.IntermediatePlace; string entity = fareCalcPassed.Entity; string dcrCode = fareCalcPassed.DcrCode; string dcrDate = fareCalcPassed.DcrDate; string dcrFlag = fareCalcPassed.DcrFalg; Controllers.MasterController objMaster = new Controllers.MasterController(); DataControl.CurrentInfo objCurr = new DataControl.CurrentInfo(); DataControl.Data objData = new DataControl.Data(); string companyCode = objCurr.GetCompanyCode(); string userCode = objCurr.GetUserCode(); string regionCode = objCurr.GetRegionCode(); if (entity == "HQ") { DataSet dsHop = new DataSet(); objData.OpenConnection(companyCode); { dsHop = objData.ExecuteDataSet("exec SP_hdGetHopPlaces '" + companyCode + "','" + dcrCode + "','" + userCode + "','" + dcrDate + "','" + dcrFlag + "'"); } objData.CloseConnection(); if (dsHop.Tables[0].Rows.Count > 0) { try { objData.OpenConnection(companyCode); { totalFare = Convert.ToDouble(objData.ExecuteScalar("exec SP_hdGetSFCAmount '" + companyCode + "','" + dsHop.Tables[0].Rows[0]["SFC_Region_Code"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["From_Place"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["To_Place"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["SFC_Category_Name"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["Travel_Mode"].ToString().Trim() + "','" + dcrDate + "','" + userCode + "','" + regionCode + "','" + entity + "'")); } objData.CloseConnection(); } catch { totalFare = 0.0; } } } else { DataSet dsTravelPlace = new DataSet(); double fareAmount = 0.0; double travelDistance = 0.0; dsTravelPlace = objMaster.GetTrvelPlace(companyCode, dcrCode, dcrFlag, userCode, dcrDate); if (dsTravelPlace.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTravelPlace.Tables[0].Rows) { travelDistance = Convert.ToDouble(dr["Distance"].ToString().Trim()); try { objData.OpenConnection(companyCode); { fareAmount = Convert.ToDouble(objData.ExecuteScalar("exec SP_hdGetSFCAmount '" + companyCode + "','" + dr["SFC_Region_Code"].ToString().Trim() + "','" + dr["From_Place"].ToString().Trim() + "','" + dr["To_Place"].ToString().Trim() + "','" + dr["SFC_Category_Name"].ToString().Trim() + "','" + dr["Travel_Mode"].ToString().Trim() + "','" + dcrDate + "','" + userCode + "','" + regionCode + "','" + entity + "'")); } objData.CloseConnection(); } catch { fareAmount = 0.0; } totalFare += fareAmount; } } } return(totalFare); } catch (Exception ex) { throw ex; } }
public string GetForgotpassword(FormCollection collection) { try { string userName = string.Empty; userName = collection["UserName"]; string result = ""; DataSet dsReport = new DataSet(); DataControl.JSONConverter json = new DataControl.JSONConverter(); try { _objData.OpenConnection(_objcurrentInfo.GetCompanyCode()); dsReport = _objData.ExecuteDataSet("EXEC SP_HdGetCheckUsername " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + userName + "'"); } finally { _objData.CloseConnection(); } if (dsReport.Tables[0].Rows.Count != 0) { string strEmailid = dsReport.Tables[0].Rows[0]["Email_Id"].ToString(); string UserName = dsReport.Tables[0].Rows[0]["User_Name"].ToString(); string strUserpass = dsReport.Tables[0].Rows[0]["User_Pass"].ToString(); if (!string.IsNullOrEmpty(strEmailid)) { //string strSubject = "Dear Sir/Madam, \n\n Please keep a note of the following information which is critical for ensuring uninterrupted access to HiDOCTOR \n\n Your User Id: " + UserName + " \n Your Password: "******" \n\n In case of any clarifications, please reach out to our support desk ([email protected] or 095600005628).\n\n Assuring you of our best services at all times.\n\n Warm Regards \n Customer Service "; string companyName = ""; string employeeName = ""; string phoneNo = "Not yet registered in HiDOCTOR"; string mobileNo = "Not yet registered in HiDOCTOR"; DataSet dsEmpInfo = new DataSet(); try { _objData.OpenConnection(_objcurrentInfo.GetCompanyCode()); dsEmpInfo = _objData.ExecuteDataSet("EXEC SP_HdGetEmployeeDetail " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + userName + "'"); } finally { _objData.CloseConnection(); } if (dsEmpInfo.Tables[0].Rows.Count > 0) { companyName = dsEmpInfo.Tables[0].Rows[0]["Company_Name"].ToString().Trim(); employeeName = dsEmpInfo.Tables[0].Rows[0]["Employee_Name"].ToString().Trim(); if (dsEmpInfo.Tables[0].Rows[0]["Phone"].ToString().Trim().Length > 0) { phoneNo = dsEmpInfo.Tables[0].Rows[0]["Phone"].ToString().Trim(); } if (dsEmpInfo.Tables[0].Rows[0]["Mobile"].ToString().Trim().Length > 0) { mobileNo = dsEmpInfo.Tables[0].Rows[0]["Mobile"].ToString().Trim(); } } string server = ConfigurationManager.AppSettings["SMTPSERVER"]; string frommail = ConfigurationManager.AppSettings["FROMMAIL"]; string strSubject = Resources.Password_Policy_Messages.PasswordLockReleaseMail.ToString(); string strSubjectNew = strSubject.Replace("@Name", UserName).Replace("@Pass", strUserpass); strSubjectNew = strSubjectNew.Replace("@CompanyName", companyName); strSubjectNew = strSubjectNew.Replace("@EmployeeName", employeeName); strSubjectNew = strSubjectNew.Replace("@PhoneNo", phoneNo); strSubjectNew = strSubjectNew.Replace("@MobileNo", mobileNo); bool Issmtpmail = false; Issmtpmail = _objSPData.SendMail(strEmailid, "Check your HiDOCTOR Password", strSubjectNew); return("SUCCESS"); } else { return("MAIL"); } } else { return("FAILED"); } } catch { return("FAILED"); } }