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 checkVisitTimePrivilge()
{
string companyCode = _objCurr.GetCompanyCode();
string usertypecode = _objCurr.GetUserTypeCode();
BLUser _objUser = new BLUser();
List <VisitTimePrivValues> lstVisitTimePrivVal = new List <VisitTimePrivValues>();
lstVisitTimePrivVal = _objDCRBL.checkVisitTimePrivilge(companyCode, usertypecode).ToList();
return(Json(lstVisitTimePrivVal, JsonRequestBehavior.AllowGet));
}
public JsonResult GetPrivileges()
{
try
{
DataControl.CurrentInfo objCurr = new DataControl.CurrentInfo();
string companyCode = objCurr.GetCompanyCode();
string userTypeCode = objCurr.GetUserTypeCode();
string userCode = objCurr.GetUserCode();
DataSet ds = new DataSet();
string cmdText = "SP_hdGetPrivilegeMapping";
SqlCommand cmd = new SqlCommand(cmdText);
cmd.CommandType = CommandType.StoredProcedure;
// Added the parameter to SqlCommand.
AddParamToSqlCommand(cmd, "@companyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
AddParamToSqlCommand(cmd, "@userTypeCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userTypeCode);
AddParamToSqlCommand(cmd, "@userCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
AddParamToSqlCommand(cmd, "@Result", ParameterDirection.Output, SqlDbType.VarChar, 30, "");
try
{
objData.OpenConnection(companyCode);
ds = objData.ExecuteDataSet(cmd);
}
finally
{
objData.CloseConnection();
}
List <Models.MasterModel> lst = new List <Models.MasterModel>();
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
lst = (from item in dt.AsEnumerable()
select new Models.MasterModel()
{
PrivilegeName = item["Privilege_Name"].ToString(),
PrivilegeValue = item["Privilege_Value_Name"].ToString(),
UsertypeCode = item["User_Type_Code"].ToString()
}).ToList <Models.MasterModel>();
}
return(Json(lst, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
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));
}
public ActionResult UsertypeActivityMapping()
{
ViewBag.UserCode = _objcurrentInfo.GetUserCode();
ViewBag.UserTypeCode = _objcurrentInfo.GetUserTypeCode();
return(View());
}
public JsonResult GetHeaderDetails(string dcrStatus, string dcrDate, string source, string flag)
{
DataSet dsPreFill = new DataSet();
DataSet dsSFC = new DataSet();
List <Models.DCRHeaderModel> lstPreFillData = new List <Models.DCRHeaderModel>();
List <Models.DCRHeaderModel> lstIntermediate = new List <Models.DCRHeaderModel>();
List <Models.DCRAttendance> lstAttendance = new List <Models.DCRAttendance>();
try
{
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
dsPreFill = _objData.ExecuteDataSet("exec SP_hdGetHeaderPrefillData '" + _objCurr.GetCompanyCode() + "','" + _objCurr.GetUserCode() + "','" + dcrStatus + "','" + dcrDate + "','" + _objCurr.GetDCRCode(dcrDate) + "','" + source + "','" + flag + "'");
}
}
finally
{
_objData.CloseConnection();
}
#region Generate Prefill Json
if (dsPreFill.Tables.Count > 0)
{
if (dsPreFill.Tables[0].Rows.Count > 0)
{
#region drafted
string accName = "";
string accRegion = "";
// For unapproved or drafted DCR, it will select the saved data from dcr master.
if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB")
{
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString())))
{
accName = dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString())))
{
accName += dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString())))
{
accName += dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString())))
{
accName += dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString() + "^";
}
//accompanist region
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString())))
{
accRegion = dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString())))
{
accRegion += dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString())))
{
accRegion += dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString() + "^";
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString())))
{
accRegion += dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString() + "^";
}
}
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
// dsSFC = _objData.ExecuteDataSet("exec SP_hdGetAccompanistCodeAndSFCData '" + _objCurr.GetCompanyCode() + "','" + accName + "','" + _objCurr.GetRegionCode() + "','" + _objCurr.GetUserTypeCode() + "'");
dsSFC = _objData.ExecuteDataSet("exec SP_hdGetAccompanistCodeAndSFCData '" + _objCurr.GetCompanyCode() + "','" + accName + "','" + accRegion + "','" + _objCurr.GetRegionCode() + "','" + _objCurr.GetUserTypeCode() + "'");
}
_objData.CloseConnection();
#endregion drafted
}
if (flag.ToUpper() == "A")
{
if (dsPreFill.Tables[2].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsPreFill.Tables[2];
if (dcrStatus == "1" && source != "TAB")
{
lstAttendance = (from item in dt.AsEnumerable()
select new Models.DCRAttendance()
{
Activity_Name = item["Activity_Name"].ToString(),
Activity_Code = item["Activity_Code"].ToString(),
Project_Code = item["Project_Code"].ToString(),
Start_Time = "",
End_Time = "",
Remarks = "",
Category = item["Expense_Entity_Code"].ToString()
}).ToList <Models.DCRAttendance>();
}
else if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB")
{
lstAttendance = (from item in dt.AsEnumerable()
select new Models.DCRAttendance()
{
Activity_Name = item["Activity_Name"].ToString(),
Activity_Code = item["Activity_Code"].ToString(),
Project_Code = item["Project_Code"].ToString(),
Start_Time = item["Start_Time"].ToString(),
End_Time = item["End_Time"].ToString(),
Remarks = item["Remarks"].ToString()
}).ToList <Models.DCRAttendance>();
}
}
}
}
#region drafted
// For unapproved or drafted DCR, it will select the saved data from dcr master.
if (dcrStatus == "3" || dcrStatus == "0" || source == "TAB")
{
DataRow[] dr;
dsPreFill.Tables[0].Columns.Add("Acc1_Code", typeof(string));
dsPreFill.Tables[0].Columns.Add("Acc2_Code", typeof(string));
dsPreFill.Tables[0].Columns.Add("Acc3_Code", typeof(string));
dsPreFill.Tables[0].Columns.Add("Acc4_Code", typeof(string));
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString())))
{
dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc1_Name"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc1_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc1_Code"] = dr[0]["Region_Code"].ToString();
}
}
else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString())))
{
dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc1_Only_For_Doctor"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc1_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc1_Code"] = dr[0]["Region_Code"].ToString();
}
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString())))
{
dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc2_Name"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc2_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc2_Code"] = dr[0]["Region_Code"].ToString();
}
}
else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString())))
{
dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc2_Only_For_Doctor"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc2_Name"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc2_Code"] = dr[0]["Region_Code"].ToString();
}
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString())))
{
dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc3_Person"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc3_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc3_Code"] = dr[0]["Region_Code"].ToString();
}
}
else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString())))
{
dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc3_Only_For_Doctor"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc3_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc3_Code"] = dr[0]["Region_Code"].ToString();
}
}
if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString())))
{
dr = dsSFC.Tables[1].Select("User_Name='" + dsPreFill.Tables[0].Rows[0]["Acc4_Person"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc4_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc4_Code"] = dr[0]["Region_Code"].ToString();
}
}
else if (!(string.IsNullOrEmpty(dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString())))
{
dr = dsSFC.Tables[1].Select("Region_Code='" + dsPreFill.Tables[0].Rows[0]["Acc4_Only_For_Doctor"].ToString() + "'");
if (dr.Length > 0)
{
dsPreFill.Tables[0].Rows[0]["Acc4_Person"] = dr[0]["Region_Name"].ToString() + "," + dr[0]["User_Name"].ToString() + "(" + dr[0]["User_Type_Name"].ToString() + ")";
dsPreFill.Tables[0].Rows[0]["Acc4_Code"] = dr[0]["Region_Code"].ToString();
}
}
DataTable dt = new DataTable();
dt = dsPreFill.Tables[0];
lstPreFillData = (from item in dt.AsEnumerable()
select new Models.DCRHeaderModel()
{
Work_Place = item["Place_Worked"].ToString().ToUpper(),
Category_Name = item["Category"].ToString(),
From_Place = item["From_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""),
To_Place = item["To_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""),
Travel_Mode = item["Travel_Mode"].ToString(),
Distance = item["Travelled_Kms"].ToString(),
CP_No = item["CP_Name"].ToString(),
CP_Code = item["CPM_No"].ToString(),
Start_Time = item["User_Start_Time"].ToString(),
End_Time = item["User_End_Time"].ToString(),
Acc1_Only_For_Doctor = item["Acc1_Only_For_Doctor"].ToString(),
Acc1_Name = item["Acc1_Name"].ToString(),
Acc1_Code = item["Acc1_Code"].ToString(),
Acc1_Start_Time = item["Accomp_Start_Time"].ToString(),
Acc1_End_Time = item["Accomp_End_Time"].ToString(),
Acc2_Name = item["Acc2_Name"].ToString(),
Acc2_Code = item["Acc2_Code"].ToString(),
Acc2_Start_Time = item["Acc2_Start_Time"].ToString(),
Acc2_End_Time = item["Acc2_End_Time"].ToString(),
Acc2_Only_For_Doctor = item["Acc2_Only_For_Doctor"].ToString(),
Acc3_Name = item["Acc3_Person"].ToString(),
Acc3_Code = item["Acc3_Code"].ToString(),
Acc3_Start_Time = item["Acc3_Time"].ToString(),
Acc3_Only_For_Doctor = item["Acc3_Only_For_Doctor"].ToString(),
Acc4_Name = item["Acc4_Person"].ToString(),
Acc4_Code = item["Acc4_Code"].ToString(),
Acc4_Start_Time = item["Acc4_Time"].ToString(),
Acc4_Only_For_Doctor = item["Acc4_Only_For_Doctor"].ToString(),
Category = item["Entity_Code"].ToString(),
Distance_Fare_Code = item["Distance_Fare_code"].ToString(),
Route_Way = item["Route_Way"].ToString(),
UnApprovalReason = item["Unapproval_Reason"].ToString(),
UnApproveBy = item["Approved_By"].ToString(),
TPDeviation = item["TP_Deviation"].ToString(),
CPDeviation = item["CP_Deviation"].ToString(),
Tp_Code = item["TP_Code"].ToString()
}).ToList <Models.DCRHeaderModel>();
// Intermediate place
if (dsPreFill.Tables[1].Rows.Count > 0)
{
DataTable dt1 = new DataTable();
dt1 = dsPreFill.Tables[1];
lstIntermediate = (from item in dt1.AsEnumerable()
select new Models.DCRHeaderModel()
{
From_Place = item["From_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""),
To_Place = item["To_Place"].ToString().ToUpper().Replace("\n", "").Replace("\r", ""),
Distance = item["Distance"].ToString(),
Travel_Mode = item["Travel_Mode"].ToString(),
Distance_Fare_Code = item["Distance_Fare_Code"].ToString(),
Route_Way = item["Route_Way"].ToString()
}).ToList <Models.DCRHeaderModel>();
}
}
#endregion drafted
List <JsonResult> lstPreFill;
if (flag == "A")
{
lstPreFill = new List <JsonResult> {
Json(lstPreFillData, JsonRequestBehavior.AllowGet), Json(lstIntermediate, JsonRequestBehavior.AllowGet), Json(lstAttendance, JsonRequestBehavior.AllowGet)
};
}
else
{
lstPreFill = new List <JsonResult> {
Json(lstPreFillData, JsonRequestBehavior.AllowGet), Json(lstIntermediate, JsonRequestBehavior.AllowGet)
};
}
return(Json(lstPreFill, JsonRequestBehavior.AllowGet));
#endregion Generate Prefill Json
}
public JsonResult ExpenseDetails(FormCollection collection)
{
try
{
DataSet dsExpense = new DataSet();
DataTable dsExpenseAutoFill = new DataTable();
DataTable dsExpensePreFill = new DataTable();
string companyCode = _objCurr.GetCompanyCode();
string userTypeCode = _objCurr.GetUserTypeCode();
string regionCode = _objCurr.GetRegionCode();
string entity = collection["entity"].ToString();
string dcrDate = collection["dcrDate"].ToString();
string dcrCode = _objCurr.GetDCRCode(dcrDate);
string dcrStatus = collection["dcrStatus"].ToString();
string interMediatePlace = collection["InterMediate_Places_Needed"].ToString();
double travelKm = Convert.ToDouble(collection["Travel_Km"]);
string flag = collection["flag"].ToString();
string isExpenseGroup = string.Empty;
List <Models.DCRExpenseModel> lstExpenseAuto = new List <Models.DCRExpenseModel>();
List <Models.DCRExpenseModel> lstExpensePre = new List <Models.DCRExpenseModel>();
List <Models.DCRExpenseModel> lstDraftedExpense = new List <Models.DCRExpenseModel>();
// check whether the expense group has mapped
try
{
_objData.OpenConnection(companyCode);
{
isExpenseGroup = Convert.ToString(_objData.ExecuteScalar("exec SP_hdCheckExpenseGroupMapping '" + companyCode + "','" + _objCurr.GetUserCode() + "','" + regionCode + "'"));
}
}
finally
{
_objData.CloseConnection();
}
if (isExpenseGroup != "NO_GROUP")
{
// Get Expense Data
try
{
_objData.OpenConnection(companyCode);
{
dsExpense = _objData.ExecuteDataSet("exec SP_hdGetExpenseNG '" + companyCode + "','" + dcrDate + "','" + isExpenseGroup + "','" + entity + "'");
}
}
finally
{
_objData.CloseConnection();
}
dsExpenseAutoFill = dsExpense.Tables[0];
dsExpensePreFill = GetFareCalculatedExpense(dsExpense.Tables[1], entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
}
else
{
//old logic
// Get Expense data
try
{
_objData.OpenConnection(companyCode);
{
dsExpense = _objData.ExecuteDataSet("exec SP_hdGetExpense '" + companyCode + "','" + regionCode + "','" + userTypeCode + "','" + entity + "'");
}
}
finally
{
_objData.CloseConnection();
}
// auto fill Data
dsExpenseAutoFill = GetExpenseData(dsExpense.Tables[0], "A", entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
// PrefillData
dsExpensePreFill = GetExpenseData(dsExpense.Tables[1], "P", entity, dcrCode, dcrDate, interMediatePlace, travelKm, flag);
}
if (dcrStatus == "3" || dcrStatus == "0")
{
DataSet dsDraftedExpense = new DataSet();
string userCode = _objCurr.GetUserCode();
// Get Expense Drafted item
try
{
_objData.OpenConnection(companyCode);
{
dsDraftedExpense = _objData.ExecuteDataSet("exec SP_hdGetDraftedExpense '" + companyCode + "','" + dcrCode + "','" + userCode + "','" + dcrDate + "','" + flag + "'");
}
}
finally
{
_objData.CloseConnection();
}
if (dsDraftedExpense.Tables.Count > 0)
{
if (dsDraftedExpense.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsDraftedExpense.Tables[0];
lstDraftedExpense = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseRemark = item["Expense_Remarks"].ToString(),
ExpenseAmount = item["Expense_Amount"].ToString()
}).ToList <Models.DCRExpenseModel>();
}
}
}
if (dsExpenseAutoFill.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsExpenseAutoFill;
lstExpenseAuto = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseMode = item["Expense_Mode"].ToString(),
ExpenseEntity = item["Expense_Entity"].ToString(),
ExpenseEntityCode = item["Expense_Entity_Code"].ToString(),
EligibilityAmount = item["Eligibility_Amount"].ToString(),
CanSplitAmount = item["Can_Split_Amount"].ToString(),
IsValidationOnEligibility = item["Is_Validation_On_Eligibility"].ToString(),
//IsPeriodBoundaryCheck = item["Is_Period_Boundary_Check"].ToString(),
SFC_Type = item["SFC_Type"].ToString(),
IsPrefill = item["Is_Prefill"].ToString(),
ExpenseGroupId = isExpenseGroup
}).ToList <Models.DCRExpenseModel>();
}
if (dsExpensePreFill.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsExpensePreFill;
lstExpensePre = (from item in dt.AsEnumerable()
select new Models.DCRExpenseModel()
{
ExpenseTypeCode = item["Expense_Type_Code"].ToString(),
ExpenseTypeName = item["Expense_Type_Name"].ToString(),
ExpenseMode = item["Expense_Mode"].ToString(),
ExpenseEntity = item["Expense_Entity"].ToString(),
ExpenseEntityCode = item["Expense_Entity_Code"].ToString(),
EligibilityAmount = item["Eligibility_Amount"].ToString(),
CanSplitAmount = item["Can_Split_Amount"].ToString(),
IsValidationOnEligibility = item["Is_Validation_On_Eligibility"].ToString(),
//IsPeriodBoundaryCheck = item["Is_Period_Boundary_Check"].ToString(),
SFC_Type = item["SFC_Type"].ToString(),
IsPrefill = item["Is_Prefill"].ToString(),
TotalFare = Convert.ToDouble(item["Total_Fare"]),
ExpenseGroupId = isExpenseGroup
}).ToList <Models.DCRExpenseModel>();
}
List <JsonResult> lstExpense = new List <JsonResult> {
Json(lstExpenseAuto, JsonRequestBehavior.AllowGet), Json(lstExpensePre, JsonRequestBehavior.AllowGet), Json(lstDraftedExpense, JsonRequestBehavior.AllowGet)
};
return(Json(lstExpense, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetLeaveBalance(FormCollection collection)
{
DataSet dsLeaveBalance = new DataSet();
DataSet dsLeaveTypeValues = new DataSet();
//string startDate = DateTime.Now.Year.ToString() + "-01-01";
//string endDate = DateTime.Now.Year.ToString() + "-12-31";
string leaveValidationNeed = collection["leaveValidationLeaves"].ToString();
string dcrDate = collection["dcrDate"].ToString();
// Added the parameter to SqlCommand.
try
{
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
//dsLeaveBalance = _objData.ExecuteDataSet("exec SP_hdGetUserLeaveBalance '" + _objCurr.GetCompanyCode() + "','" + _objCurr.GetUserCode() + "','" + _objCurr.GetUserTypeCode() + "','" + startDate + "','" + endDate + "','" + dcrDate + "'");
dsLeaveBalance = _objData.ExecuteDataSet("exec SP_hdGetUserLeaveBalance '" + _objCurr.GetCompanyCode() + "','" + _objCurr.GetUserCode() + "','" + _objCurr.GetUserTypeCode() + "','" + dcrDate + "'");
}
}
finally
{
_objData.CloseConnection();
}
List <Models.DCRLeaveEntryModel> lstLeaveBalance = new List <Models.DCRLeaveEntryModel>();
List <Models.DCRLeaveEntryModel> lstLeaveValidation = new List <Models.DCRLeaveEntryModel>();
#region Leave Balance
if (dsLeaveBalance.Tables.Count > 0)
{
if (dsLeaveBalance.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsLeaveBalance.Tables[0];
lstLeaveBalance = (from item in dt.AsEnumerable()
select new Models.DCRLeaveEntryModel()
{
Leave_Type_Code = item["Leave_Type_Code"].ToString(),
Leave_Type_Name = item["Leave_Type_Name"].ToString(),
Balance_CF = (item["Balance_CF"] != System.DBNull.Value) ? Convert.ToDouble(item["Balance_CF"]) : 0.0,
Leave_Eligible = (item["Leave_Eligible"] != System.DBNull.Value) ? Convert.ToDouble(item["Leave_Eligible"]) : 0.0,
Leave_Balance = (item["Leave_Balance"] != System.DBNull.Value) ? Convert.ToDouble(item["Leave_Balance"]) : 0.0,
Lapsed = (item["Lapsed"] != System.DBNull.Value) ? Convert.ToDouble(item["Lapsed"]) : 0.0,
Opening_Balance = (item["Opening_Balance"] != System.DBNull.Value) ? Convert.ToDouble(item["Opening_Balance"]) : 0.0,
Leave_Taken = (item["Leave_Taken"] != System.DBNull.Value) ? Convert.ToDouble(item["Leave_Taken"]) : 0.0,
leave_Eligibleforyear = Convert.ToInt32(item["leave_Eligibleforyear"]),
leave_confirmation_days = item["leave_confirmation_days"].ToString(),
leave_Oncompletion = item["leave_Oncompletion"].ToString(),
No_of_days = Convert.ToInt32(item["No_of_days"].ToString()),
leave_application_days = Convert.ToInt32(item["leave_application_days"].ToString()),
Confirmation_date = item["Confirmation_date"].ToString(),
}).ToList <Models.DCRLeaveEntryModel>();
}
}
// Get the leave validation details
if (!(string.IsNullOrEmpty(leaveValidationNeed)))
{
try
{
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
dsLeaveTypeValues = _objData.ExecuteDataSet("exec SP_hdGetUserLeaveTypeValues '" + _objCurr.GetCompanyCode() + "','" + _objCurr.GetUserCode() + "','" + _objCurr.GetUserTypeCode() + "','" + dcrDate + "'");
}
}
finally
{
_objData.CloseConnection();
}
if (dsLeaveTypeValues.Tables.Count > 0)
{
if (dsLeaveTypeValues.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = dsLeaveTypeValues.Tables[0];
lstLeaveValidation = (from item in dt.AsEnumerable()
select new Models.DCRLeaveEntryModel()
{
Leave_Type_Code = item["Leave_Type_Code"].ToString(),
IS_Added_Weekend_Holiday = (item["IS_Added_Weekend_Holiday"] != System.DBNull.Value) ? Convert.ToChar(item["IS_Added_Weekend_Holiday"]) : 'Y',
Min_Leave = (item["Min_Leave"] != System.DBNull.Value) ? Convert.ToDouble(item["Min_Leave"]) : 0.0,
Max_Leave = (item["Max_Leave"] != System.DBNull.Value) ? Convert.ToDouble(item["Max_Leave"]) : 0.0,
Effective_From = item["Effective_From"].ToString(),
Effective_To = item["Effective_To"].ToString(),
User_Leave_Type_Code = item["User_Leave_Type_Code"].ToString(),
IS_Added_Holiday = (item["IS_Added_Holiday"] != System.DBNull.Value) ? Convert.ToChar(item["IS_Added_Holiday"]) : 'Y'
}).ToList <Models.DCRLeaveEntryModel>();
}
}
}
#endregion Leave Balance
List <JsonResult> lstLeave = new List <JsonResult> {
Json(lstLeaveBalance, JsonRequestBehavior.AllowGet), Json(lstLeaveValidation, JsonRequestBehavior.AllowGet)
};
return(Json(lstLeave, JsonRequestBehavior.AllowGet));
}
