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