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