public JsonResult GetChildUsers() { MasterController mc = new MasterController(); JsonResult childUsersJson = mc.GetChildUsersJSON(objCurr.GetCompanyCode(), objCurr.GetUserCode()); return(childUsersJson); }
public JsonResult GetRegionWiseUser(string regionCode) { DataSet ds = null; ds = new DataSet(); CurrentInfo objCurInfo = new CurrentInfo(); MasterController objMaster = new MasterController(); ds = objMaster.GetRegionWiseUser(objCurInfo.GetCompanyCode(), regionCode); JSONConverter objJson = new JSONConverter(); return(Json(objJson.Serialize(ds), JsonRequestBehavior.AllowGet)); }
public string GetCPDetails(string regionCode) { string blobUrl = string.Empty; DataControl.BLCampaignPlanner _objBlCP = new DataControl.BLCampaignPlanner(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); StringBuilder strContent = new StringBuilder(); DataSet ds = new DataSet(); try { ds = _objBlCP.GetCPDetails(_objCurInfo.GetCompanyCode(), regionCode); strContent.Append("<table class='table table-striped'>"); strContent.Append("<thead><tr><td>Edit</td><td>CP Name</td><td>Status</td> <td>Category Name</td>"); strContent.Append("<td>Work Area</td><td>Place From</td> <td>Place To</td><td>SFC Category</td>"); strContent.Append("<td >Distance</td><td>Fare</td><td >Travel Mode</td>"); strContent.Append("<td>Doctor Name</td>");//<td>MDL/SVL No</td>"); strContent.Append("<td>Unapprove Reason</td></tr></thead><tbody>"); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string cpCode = Convert.ToString(ds.Tables[0].Rows[i]["CP_Code"]); DataRow[] drHop = ds.Tables[1].AsEnumerable().Where(a => Convert.ToString(a["CP_Code"]) == cpCode).ToArray(); DataRow[] drDoctors = ds.Tables[2].AsEnumerable().Where(a => Convert.ToString(a["CP_Code"]) == cpCode).ToArray(); #region cp details //StringBuilder strWorkArea = new StringBuilder(); StringBuilder strFromPlace = new StringBuilder(); StringBuilder strToPlace = new StringBuilder(); StringBuilder strSFCCategory = new StringBuilder(); StringBuilder strDistance = new StringBuilder(); StringBuilder strTravelMode = new StringBuilder(); StringBuilder strFare = new StringBuilder(); // strWorkArea.Append("<table>"); strFromPlace.Append("<table>"); strToPlace.Append("<table>"); strSFCCategory.Append("<table>"); strDistance.Append("<table>"); strTravelMode.Append("<table>"); strFare.Append("<table>"); if (drHop.Length > 0) { for (int j = 0; j < drHop.Length; j++) { //strWorkArea.Append("<tr><td>" + drHop[j]["Work_Place"] + "</td></tr>"); if (drHop[j]["Route_Way"].ToString() == "D") { strFromPlace.Append("<tr><td>" + drHop[j]["From_Place"] + "</td></tr>"); strToPlace.Append("<tr><td>" + drHop[j]["To_Place"] + "</td></tr>"); strSFCCategory.Append("<tr><td>" + drHop[j]["SFC_Category_Name"] + "</td></tr>"); } else { strFromPlace.Append("<tr><td>" + drHop[j]["To_Place"] + "</td></tr>"); strToPlace.Append("<tr><td>" + drHop[j]["From_Place"] + "</td></tr>"); strSFCCategory.Append("<tr><td>" + drHop[j]["SFC_Category_Name"] + "</td></tr>"); } strDistance.Append("<tr><td>" + drHop[j]["Distance"] + "</td></tr>"); strTravelMode.Append("<tr><td>" + drHop[j]["Travel_Mode"] + "</td></tr>"); strFare.Append("<tr><td>" + drHop[j]["Amount"] + "</td></tr>"); } } else { // strWorkArea.Append("<tr><td>" + ds.Tables[0].Rows[i]["Work_Area"] + "</td></tr>"); if (ds.Tables[0].Rows[i]["Route_Way"].ToString() == "D") { strFromPlace.Append("<tr><td>" + ds.Tables[0].Rows[i]["Place_From"] + "</td></tr>"); strToPlace.Append("<tr><td>" + ds.Tables[0].Rows[i]["Place_To"] + "</td></tr>"); strSFCCategory.Append("<tr><td>" + ds.Tables[0].Rows[i]["SFC_Category_Name"] + "</td></tr>"); } else { strFromPlace.Append("<tr><td>" + ds.Tables[0].Rows[i]["Place_To"] + "</td></tr>"); strToPlace.Append("<tr><td>" + ds.Tables[0].Rows[i]["Place_From"] + "</td></tr>"); strSFCCategory.Append("<tr><td>" + ds.Tables[0].Rows[i]["SFC_Category_Name"] + "</td></tr>"); } strDistance.Append("<tr><td>" + ds.Tables[0].Rows[i]["Distance"] + "</td></tr>"); strTravelMode.Append("<tr><td>" + ds.Tables[0].Rows[i]["Travel_Mode"] + "</td></tr>"); strFare.Append("<tr><td>" + ds.Tables[0].Rows[i]["Fare_Amount"] + "</td></tr>"); } //strWorkArea.Append("</table>"); strFromPlace.Append("</table>"); strToPlace.Append("</table>"); strSFCCategory.Append("</table>"); strDistance.Append("</table>"); strTravelMode.Append("</table>"); strFare.Append("</table>"); #endregion cp details #region cp doctor details StringBuilder strDoctorName = new StringBuilder(); if (drDoctors.Length > 0) { foreach (DataRow drr in drDoctors) { if (drr["Qualification"] != "") { strDoctorName.Append(drr["Customer_Name"] + "_" + drr["MDL_Number"] + "_" + drr["Speciality_Name"] + "_" + drr["Qualification"] + "</br>"); } else { strDoctorName.Append(drr["Customer_Name"] + "_" + drr["MDL_Number"] + "_" + drr["Speciality_Name"] + "</br>"); } } } #endregion cp doctor details if (Convert.ToString(ds.Tables[0].Rows[i]["Status"]).ToUpper() == "APPROVED") { strContent.Append("<tr><td></td>"); } else { strContent.Append("<tr><td><a onclick='fnEditCPDetails(\"" + cpCode + "\");'>Edit</a></td>"); } strContent.Append("<td>" + Convert.ToString(ds.Tables[0].Rows[i]["CP_Name"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(ds.Tables[0].Rows[i]["Status"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(ds.Tables[0].Rows[i]["Expense_Entity_Name"]) + "</td>"); // strContent.Append("<td>" + Convert.ToString(strWorkArea) + "</td>"); strContent.Append("<td>" + Convert.ToString(ds.Tables[0].Rows[i]["Work_Area"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(strFromPlace) + "</td>"); strContent.Append("<td>" + Convert.ToString(strToPlace) + "</td>"); strContent.Append("<td>" + Convert.ToString(strSFCCategory) + "</td>"); strContent.Append("<td>" + Convert.ToString(strDistance) + "</td>"); strContent.Append("<td>" + Convert.ToString(strFare) + "</td>"); strContent.Append("<td>" + Convert.ToString(strTravelMode) + "</td>"); strContent.Append("<td>" + Convert.ToString(strDoctorName) + "</td>"); strContent.Append("<td>" + Convert.ToString(ds.Tables[0].Rows[i]["Unapprove_Reason"]) + "</td></tr>"); } } } strContent.Append("</tbody></table>"); MasterController objMaster = new MasterController(); string compCode = _objCurInfo.GetCompanyCode(); DataSet dsUser = null; string userName = string.Empty; dsUser = new DataSet(); dsUser = objMaster.GetRegionWiseUser(compCode, regionCode); if (dsUser != null && dsUser.Tables[0].Rows.Count > 0) { userName = dsUser.Tables[0].Rows[0]["User_Name"].ToString(); } else { userName = _objCurInfo.GetUserName(); } DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string fileName = "CampaignPlanner_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("regionCode", regionCode); dicObj.Add("strContent", strContent.ToString()); dicObj.Add("blobUrl", blobUrl); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); } return(strContent.ToString() + "$" + _objJson.Serialize(ds) + "^" + blobUrl); }
// // GET: /DCRCalendar/ public JsonResult GetCalendarDetails(string startDate, string endDate) { List <JsonResult> dcrJSON = new List <JsonResult>(); _objcurrentInfo = new CurrentInfo(); MasterController masterController = new MasterController(); DataSet dsParentRegions = new DataSet(); string companyCode = _objcurrentInfo.GetCompanyCode(); string regionCode = _objcurrentInfo.GetRegionCode(); string userCode = _objcurrentInfo.GetUserCode(); string GreytipLeaveConfigValue = ""; dsParentRegions = masterController.GetParentRegionsDataSet(regionCode); bool payRollIntegratedStatus = _objcurrentInfo.GetPayRollIntegratedStatus(); DataTable dtRegion = dsParentRegions.Tables[0]; GreytipLeaveConfigValue = GetGreyTipPayRollShortNameConfigValue();; string parentRegions = string.Empty; for (int i = 0; i < dtRegion.Rows.Count; i++) { if (dtRegion.Rows[i]["Region_Code"].ToString() != regionCode) { parentRegions += dtRegion.Rows[i]["Region_Code"] + "^"; } } DataSet dsMasterDetails = _objSPData.GetCalendarDetails(startDate, endDate, userCode, regionCode, parentRegions); DataTable dtHeaderDetails = dsMasterDetails.Tables[0]; DataTable dtLockDetails = dsMasterDetails.Tables[1]; DataTable dtLockhelpInfo = dsMasterDetails.Tables[2]; DataTable dtTPInfo = dsMasterDetails.Tables[3]; DataTable dtActivityLock = dsMasterDetails.Tables[4]; DataTable dtWAData = dsMasterDetails.Tables[5]; DataTable dtSSData = dsMasterDetails.Tables[6]; List <DCRCalendarModel> lstDCRHeaderDetails = (from Master_Data in dtHeaderDetails.AsEnumerable() select new DCRCalendarModel { year = Master_Data["Year"].ToString(), month = Master_Data["Month"].ToString(), day = Master_Data["Day"].ToString(), start = Master_Data["Month"].ToString() + "/" + Master_Data["Day"].ToString() + "/" + Master_Data["Year"].ToString(), title = Convert.ToInt32(Master_Data["Status"]) == -1 ? "WA-" + masterController.GetFlagFullName(Master_Data["Flag"].ToString()) : Convert.ToInt32(Master_Data["Status"]) == -2 ? "Off-" + masterController.GetFlagFullName(Master_Data["Flag"].ToString()) : Master_Data["Flag"].ToString() == "L" ? Master_Data["Source_Of_Entry"].ToString() == "PAY_WS" ? masterController.GetFlagFullName(Master_Data["Flag"].ToString()) + " " + Enum.GetName(typeof(DCRStatus), Convert.ToInt32(Master_Data["Status"])) + " (" + GreytipLeaveConfigValue + ")" : masterController.GetFlagFullName(Master_Data["Flag"].ToString()) + " " + Enum.GetName(typeof(DCRStatus), Convert.ToInt32(Master_Data["Status"])) : masterController.GetFlagFullName(Master_Data["Flag"].ToString()) + " " + Enum.GetName(typeof(DCRStatus), Convert.ToInt32(Master_Data["Status"])), isTP = "", url = "#", className = "DCR" + "-" + Enum.GetName(typeof(DCRStatus), Convert.ToInt32(Master_Data["Status"])) + "-" + Master_Data["Flag"].ToString(), Activity_Count = Master_Data["Activity_Count"] == null ? "0" : Master_Data["Activity_Count"].ToString(), // DCR_Lock_Status = Master_Data["DCR_Lock_Status"].ToString(), Record_Status = Master_Data["Record_Status"] == null ? "0" : Master_Data["Record_Status"].ToString() }).ToList <DCRCalendarModel>(); List <DCRLockModel> lstDCRLockDetails = (from Master_Data in dtLockDetails.AsEnumerable() select new DCRLockModel { Locked_Date = Master_Data["Locked_Date"].ToString(), LockType = Master_Data["Lock_Type"].ToString(), TP_Define_Month = Master_Data["TP_Define_Month"].ToString(), TP_Define_Year = Master_Data["TP_Define_Year"].ToString(), TP_Approval_Month = Master_Data["TP_Approval_Month"].ToString(), TP_Approval_Year = Master_Data["TP_Approval_Year"].ToString(), Lock_Reason = Master_Data["Lock_Reason"].ToString(), Reason = Master_Data["Reason"].ToString(), DCR_Actual_Date = Master_Data["DCR_Actual_Date"].ToString() }).ToList <DCRLockModel>(); List <DCRLockModel> lstDCRLockHelpInfo = (from Master_Data in dtLockhelpInfo.AsEnumerable() select new DCRLockModel { // IsTPDefineNextMonth = Master_Data["IsTPDefineNextMonth"].ToString(), MissedDCRDate = Master_Data["MissedDCRDate"].ToString(), //IsRegionLock = Master_Data["RegionLock"].ToString(), HidoctorStartDate = Master_Data["JoinDate"].ToString(), Leave_Entry_Mode = Master_Data["Leave_Entry_Mode"].ToString(), // TP_Approval_Lock = Convert.ToInt32(Master_Data["TP_Approval_Lock"]), Is_WA_User = Master_Data["Is_WA_User"].ToString(), Is_WA_TABLET_USER = Convert.ToBoolean(Master_Data["Is_WA_TABLET_USER"]), WA_REGIS_DATE = Master_Data["WA_REGIS_DATE"].ToString() }).ToList <DCRLockModel>(); dcrJSON.Add(Json(lstDCRLockDetails)); dcrJSON.Add(Json(lstDCRLockHelpInfo)); dcrJSON.Add(Json(lstDCRHeaderDetails)); DataSet dsLockLevaeDetails = _objSPData.GetLockLeaveDetails(startDate, endDate); DataTable dtLockLevaeDetails = dsLockLevaeDetails.Tables[0]; List <DCRCalendarModel> lstDCRLockLeaveDetails = (from lock_leaveData in dtLockLevaeDetails.AsEnumerable() select new DCRCalendarModel { year = lock_leaveData["Year"].ToString(), month = lock_leaveData["Month"].ToString(), day = lock_leaveData["Day"].ToString(), LeaveType = lock_leaveData["Leave_Type"].ToString(), start = lock_leaveData["Month"].ToString() + "/" + lock_leaveData["Day"].ToString() + "/" + lock_leaveData["Year"].ToString(), title = lock_leaveData["Flag"].ToString() + "-" + lock_leaveData["Status"].ToString(), DCR_Lock_Status = lock_leaveData["Status"].ToString(), isTP = "", url = "#", className = lock_leaveData["ClassName"].ToString(), Record_Status = lock_leaveData["Record_Status"].ToString(), Released_Date = lock_leaveData["Released_Date"].ToString() }).ToList <DCRCalendarModel>(); dcrJSON.Add(Json(lstDCRLockLeaveDetails)); DataSet dsHolidays = masterController.GetHolidays(companyCode, startDate, endDate, parentRegions, regionCode); DataTable dtHoliday = dsHolidays.Tables[0]; List <DCRCalendarModel> lstDCRHolidayDetails = (from hoilday_data in dtHoliday.AsEnumerable() select new DCRCalendarModel { year = hoilday_data["Year"].ToString(), month = hoilday_data["Month"].ToString(), day = hoilday_data["Day"].ToString(), start = hoilday_data["Month"].ToString() + "/" + hoilday_data["Day"].ToString() + "/" + hoilday_data["Year"].ToString(), title = hoilday_data["Flag"].ToString() + " " + hoilday_data["Status"].ToString(), isTP = "", url = "#", className = hoilday_data["ClassName"].ToString() }).ToList <DCRCalendarModel>(); dcrJSON.Add(Json(lstDCRHolidayDetails)); List <DCRCalendarModel> lstTPInfo = (from tp_data in dtTPInfo.AsEnumerable() select new DCRCalendarModel { year = tp_data["Year"].ToString(), month = tp_data["Month"].ToString(), day = tp_data["Day"].ToString(), start = tp_data["Month"].ToString() + "/" + tp_data["Day"].ToString() + "/" + tp_data["Year"].ToString(), title = tp_data["Flag"].ToString() + "-" + tp_data["Status"].ToString(), isTP = "", url = "#", className = tp_data["Status"].ToString() }).ToList <DCRCalendarModel>(); dcrJSON.Add(Json(lstTPInfo)); List <DCRActivityLock> lstActivityLock = (from activity_lock_data in dtActivityLock.AsEnumerable() select new DCRActivityLock { User_Code = activity_lock_data["User_Code"].ToString(), Lock_Status = activity_lock_data["Lock_Status"].ToString(), DCR_Actual_Date = activity_lock_data["DCR_Actual_Date"].ToString(), Flag = activity_lock_data["Activity_Flag"].ToString(), UnapproveReason = activity_lock_data["Unapproval_Reason"].ToString(), }).ToList <DCRActivityLock>(); dcrJSON.Add(Json(lstActivityLock)); List <DCRCalendarModel> lstWAData = (from wa_data in dtWAData.AsEnumerable() select new DCRCalendarModel { year = wa_data["Year"].ToString(), month = wa_data["Month"].ToString(), day = wa_data["Day"].ToString(), start = wa_data["Month"].ToString() + "/" + wa_data["Day"].ToString() + "/" + wa_data["Year"].ToString(), title = Convert.ToInt32(wa_data["Status"]) == -1 ? "WA-" + masterController.GetFlagFullName(wa_data["Flag"].ToString()) : Convert.ToInt32(wa_data["Status"]) == -2 ? "Off-" + masterController.GetFlagFullName(wa_data["Flag"].ToString()) : masterController.GetFlagFullName(wa_data["Flag"].ToString()) + " " + Enum.GetName(typeof(DCRStatus), Convert.ToInt32(wa_data["Status"])), isTP = "", url = "#", className = wa_data["Status"].ToString() }).ToList <DCRCalendarModel>(); dcrJSON.Add(Json(lstWAData)); BLRegion objBLRegion = new BLRegion(); List <WeekendDaysForARegion> lstWeekEnd = objBLRegion.GetWeekendDaysForARegion(companyCode, regionCode, startDate, endDate); dcrJSON.Add(Json(lstWeekEnd)); if (dtSSData.Rows.Count > 0) { List <DCRLockModel> lstSSDCRLock = (from Master_Data in dtSSData.AsEnumerable() select new DCRLockModel { SS_Applied_Lock = Master_Data["Lock_Status"].ToString(), Previous_Month_Year = Convert.ToDateTime(Master_Data["Previous_Month_Year"]).ToString("dd-MM-yyyy"), SS_Id = Convert.ToInt32(Master_Data["SS_Id"]) }).ToList <DCRLockModel>(); dcrJSON.Add(Json(lstSSDCRLock)); } return(Json(dcrJSON)); }