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");
}
}