//Fill DDL Division , Region-Type , Region-Classification , User-Type , Expense-Header-Group
#region Get ExpenseMapping Master Data
public DataSet GetExpenseMappingMasterData()
{
DataSet ds = new DataSet();
objData.OpenConnection(_ObjCurInfo.GetCompanyCode());
{
string StrSQL = "EXEC SP_hdGetExpenseMappingMasterData " + _ObjCurInfo.GetCompanyCode();
ds = objData.ExecuteDataSet(StrSQL);
objData.CloseConnection();
}
return(ds);
}
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 DataSet GetAllExpense()
{
DataSet dssub = new DataSet();
objData.OpenConnection(objCurrentInfo.GetCompanyCode());
{
string StrSQL = "EXEC SP_hd_ExpenseType_Select " + objCurrentInfo.GetCompanyCode();
dssub = objData.ExecuteDataSet(StrSQL);
objData.CloseConnection();
}
return(dssub);
}
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");
}
}