public int HolidayInheritance(string sourceRegion, string destinationRegions)
{
int rowsAffected = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
try
{
List <MVCModels.HiDoctor_Master.RegionModel> lstRegion = new List <MVCModels.HiDoctor_Master.RegionModel>();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
if (!string.IsNullOrEmpty(destinationRegions))
{
string[] ar = destinationRegions.Split(',');
foreach (var region in ar)
{
if (!string.IsNullOrEmpty(region))
{
MVCModels.HiDoctor_Master.RegionModel objRegionModel = new MVCModels.HiDoctor_Master.RegionModel();
objRegionModel.Region_Code = region;
lstRegion.Add(objRegionModel);
}
}
rowsAffected = objRegion.HolidayInheritance(objCurInfo.GetCompanyCode(), sourceRegion, lstRegion,
objCurInfo.GetUserName(), System.DateTime.Now.ToString("yyyy-MM-dd"));
}
}
catch (Exception ex)
{
Dictionary <string, string> dicObj = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
return(0);
}
return(rowsAffected);
}
public string GetRegionsForHolidaySearch()
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.RegionModel> lstRegion = null;
IEnumerable <MVCModels.HiDoctor_Master.RegionModel> lstUnMappedRegion = null;
lstRegion = objRegion.GetHolidayMappedRegions(objCurInfo.GetCompanyCode());
lstUnMappedRegion = objRegion.GetHolidayUnMappedRegions(objCurInfo.GetCompanyCode());
StringBuilder strContent = new StringBuilder();
strContent.Append("<table class='table table-striped' id='tblUnMappedRegion'><thead><tr><td>S.No</td><td><input type='checkbox' name='chkAllUnMappedRegion' onclick='fnSelectAllUnMappedRegions();'/></td>");
strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstUnMappedRegion != null)
{
int i = 0;
foreach (var dr in lstUnMappedRegion)
{
i++;
strContent.Append("<tr><td>" + i + "</td>");
strContent.Append("<td><input type='checkbox' id='chkSelect_" + i + "' name='chkUnMappedRegion' value='" + dr.Region_Code + "'/></td>");
strContent.Append("<td>" + dr.Region_Name + "</td>");
strContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strContent.Append("</tr>");
}
}
strContent.Append("</table>");
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(objJson.Serialize(lstRegion) + "~" + strContent.ToString());
}
public string GetSearchHolidayDetails(string holidayDate)
{
int count = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
string date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0];
lstHoliday = objRegion.GetHolidayDetailsByDate(objCurInfo.GetCompanyCode(), date);
StringBuilder strContent = new StringBuilder();
strContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Date</td><td>Holiday Name</td>");
strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strContent.Append("<tr><td>" + i + "</td>");
strContent.Append("<td>" + dr.Holiday_Date + "</td>");
strContent.Append("<td>" + dr.Holiday_Name + "</td>");
strContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strContent.Append("</tr>");
}
}
strContent.Append("</tbody></table>");
return(strContent.ToString());
}
public JsonResult GetMappedHolidaysByDate(string holidayDate)
{
int count = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
string date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0];
lstHoliday = objRegion.GetHolidayDetailsByDate(objCurInfo.GetCompanyCode(), date);
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
return(Json(objJson.Serialize(lstHoliday)));
}
public string GenerateYearWiseHolidayExcel(string regionCodes, string year, string SearchKey, int pageNumber, bool excelDownload)
{
int count = 0;
int totalPageCount = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
lstHoliday = objRegion.GetMappedHolidayDetails(objCurInfo.GetCompanyCode(), regionCodes, year, SearchKey, pageNumber, excelDownload, PAGESIZE,
ref totalPageCount);
StringBuilder strContent = new StringBuilder();
StringBuilder strExcelContent = new StringBuilder();
strExcelContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Date</td><td>Holiday Name</td>");
strExcelContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strExcelContent.Append("<tr><td>" + i + "</td>");
strExcelContent.Append("<td><span id='lblHolidayDate_" + i + "'>" + dr.Holiday_Date + "</span></td>");
strExcelContent.Append("<td><span id='lblHolidayName_" + i + "'>" + dr.Holiday_Name + "</span></td>");
strExcelContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strExcelContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strExcelContent.Append("</tr>");
}
}
strExcelContent.Append("</tbody></table>");
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = objCurInfo.GetUserName();
string subDomin = objCurInfo.GetSubDomain();
string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls";
string blobUrl = string.Empty;
blobUrl = objAzureBlob.AzureBlobUploadText(strExcelContent.ToString(), accKey, fileName, "bulkdatasvc");
return(blobUrl);
}
public string GetMappedHolidayDetails(string regionCodes, string year, string SearchKey, int pageNumber, bool excelDownload)
{
int count = 0;
int totalPageCount = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
lstHoliday = objRegion.GetMappedHolidayDetails(objCurInfo.GetCompanyCode(), regionCodes, year, SearchKey, pageNumber, excelDownload, PAGESIZE,
ref totalPageCount);
StringBuilder strContent = new StringBuilder();
strContent.Append(Pager.Paging(pageNumber, totalPageCount));
StringBuilder strExcelContent = new StringBuilder();
strContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Edit</td><td>Delete</td><td>Date</td><td>Holiday Name</td>");
strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strContent.Append("<tr><td>" + i + "</td>");
strContent.Append("<td><a id='aEdit_" + i + "' onclick='fnEditHoliday(\"" + dr.Holiday_Code + "\",this)'>Edit</a></td>");
strContent.Append("<td><a id='aDelete_" + i + "' onclick='fnDeleteHoliday(\"" + dr.Holiday_Code + "\",this)'>Delete</a></td>");
strContent.Append("<td><span id='lblHolidayDate_" + i + "'>" + dr.Holiday_Date + "</span></td>");
strContent.Append("<td><span id='lblHolidayName_" + i + "'>" + dr.Holiday_Name + "</span></td>");
strContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strContent.Append("</tr>");
}
}
strContent.Append("</tbody></table>");
return(strContent.ToString());
}
public string UpdateRegionFullIndex()
{
string result = "";
string guid = Guid.NewGuid().ToString();
try
{
DataSet ds = new DataSet();
DataControl.BLRegion _objBlRegion = new DataControl.BLRegion();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
ds = _objBlRegion.GetAllRegionsForMigration(_objCurInfo.GetCompanyCode());
DataSet dsAllRegions = new DataSet();
DataRow[] dr;
DataRow[] drChild;
dr = ds.Tables[0].AsEnumerable().Where(c => c["Under_Region_Id"].ToString() == "0").ToArray();
if (dr.Length > 0)
{
string regionCode = dr[0]["Region_Code"].ToString();
string regionId = dr[0]["Region_Id"].ToString();
dsAllRegions = _objBlRegion.GetRegionHierarchyDataset(_objCurInfo.GetCompanyCode(), regionCode, _objCurInfo.GetUserCode(), guid);
if (dsAllRegions.Tables[0].Rows.Count > 0)
{
DataRow[] drRoot;
drRoot = dsAllRegions.Tables[0].AsEnumerable().Where(c => c["Under_Region_Id"].ToString() == "0").ToArray();
drRoot[0]["Full_index"] = regionId + ".";
drRoot[0]["Company_Code"] = _objCurInfo.GetCompanyCode();
dsAllRegions.AcceptChanges();
for (int i = 0; i < dsAllRegions.Tables[0].Rows.Count; i++)
{
string curRegionCode = dsAllRegions.Tables[0].Rows[i]["Region_Code"].ToString();
string curParRegionCode = dsAllRegions.Tables[0].Rows[i]["Under_Region_Code"].ToString();
if (curRegionCode != curParRegionCode)
{
string curRegionId = dsAllRegions.Tables[0].Rows[i]["Region_Id"].ToString();
string parIndex = "";
DataRow[] drTemp;
drTemp = dsAllRegions.Tables[0].AsEnumerable().Where(c => c["Region_Code"].ToString() == curParRegionCode).ToArray();
if (drTemp.Length > 0)
{
parIndex = drTemp[0]["Full_index"].ToString();
dsAllRegions.Tables[0].Rows[i]["Full_index"] = parIndex + curRegionId + ".";
dsAllRegions.Tables[0].Rows[i]["Company_Code"] = _objCurInfo.GetCompanyCode();
}
}
}
//Update Qry
int rowsAffected = 0;
result = _objBlRegion.BulkRegionTempInsert(_objCurInfo.GetCompanyCode(), dsAllRegions.Tables[0], "REFRESH");
if (result.Split(':')[0].ToUpper() == "SUCCESS")
{
rowsAffected = _objBlRegion.UpdateRegionIndexFromTemptoRegionMaster(_objCurInfo.GetCompanyCode(), "REFRESH",
guid, _objCurInfo.GetUserCode());
if (rowsAffected > 0)
{
result = "SUCCESS:Region tree refreshed successfully";
}
else
{
result = "ERROR:Error occurred while refresh the region";
}
}
}
}
}
catch (Exception ex)
{
result = "FAILURE:" + ex.Message;
}
return(result);
}
public string UpdateRegionNewIndex()
{
string result = "";
string guid = Guid.NewGuid().ToString();
try
{
DataSet ds = new DataSet();
DataControl.BLRegion _objBlRegion = new DataControl.BLRegion();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
ds = _objBlRegion.GetAllRegionsForMigration(_objCurInfo.GetCompanyCode());
DataSet dsAllRegions = new DataSet();
DataRow[] dr;
dr = ds.Tables[0].AsEnumerable().Where(c => c["Under_Region_Id"].ToString() == "0").ToArray();
if (dr.Length > 0)
{
string userCode = dr[0]["Region_Code"].ToString();
string userId = dr[0]["Region_Id"].ToString();
dsAllRegions = _objBlRegion.GetRegionHierarchyDataset(_objCurInfo.GetCompanyCode(), userCode, _objCurInfo.GetUserCode(), guid);
if (dsAllRegions.Tables[0].Rows.Count > 0)
{
//Display Order Update
for (int d = 0; d < dsAllRegions.Tables[0].Rows.Count; d++)
{
dsAllRegions.Tables[0].Rows[d]["Display_Order"] = d + 1;
dsAllRegions.AcceptChanges();
}
//Root user seq and full index update
DataRow[] drRoot;
drRoot = dsAllRegions.Tables[0].AsEnumerable().Where(c => c["Under_Region_Id"].ToString() == "0").ToArray();
drRoot[0]["Full_index"] = userId + ".";
drRoot[0]["Seq_index"] = "1";
drRoot[0]["Company_Code"] = _objCurInfo.GetCompanyCode();
// Root child nodes seq and full index updation
DataRow[] drChild;
drChild = dsAllRegions.Tables[0].AsEnumerable().Where(d => d["Under_Region_Code"].ToString() == userCode).ToArray();
if (drChild.Length > 0)
{
int c = 0;
foreach (DataRow drr in drChild)
{
c++;
drr["Seq_index"] = c.ToString();
drr["Company_Code"] = _objCurInfo.GetCompanyCode();
dsAllRegions.AcceptChanges();
}
}
dsAllRegions.AcceptChanges();
int displayOrder = 0;
for (int i = 0; i < dsAllRegions.Tables[0].Rows.Count; i++)
{
displayOrder++;
string curRegionCode = dsAllRegions.Tables[0].Rows[i]["Region_Code"].ToString();
string curParRegionCode = dsAllRegions.Tables[0].Rows[i]["Under_Region_Code"].ToString();
if (curRegionCode != curParRegionCode)
{
string curRegionId = dsAllRegions.Tables[0].Rows[i]["Region_Id"].ToString();
string parIndex = "";
DataRow[] drTemp;
drTemp = dsAllRegions.Tables[0].AsEnumerable().Where(c => c["Region_Code"].ToString() == curParRegionCode).ToArray();
if (drTemp.Length > 0)
{
parIndex = drTemp[0]["Full_index"].ToString();
dsAllRegions.Tables[0].Rows[i]["Full_index"] = parIndex + curRegionId + ".";
dsAllRegions.Tables[0].Rows[i]["Company_Code"] = _objCurInfo.GetCompanyCode();
dsAllRegions.Tables[0].Rows[i]["Under_Region_Id"] = drTemp[0]["Region_Id"].ToString();
}
drChild = dsAllRegions.Tables[0].AsEnumerable().Where(d => d["Under_Region_Code"].ToString() == curRegionCode).ToArray();
if (drChild.Length > 0)
{
int c = 0;
foreach (DataRow drr in drChild)
{
c++;
drr["Seq_index"] = c.ToString();
drr["Company_Code"] = _objCurInfo.GetCompanyCode();
dsAllRegions.AcceptChanges();
}
}
}
}
//Update Qry
int rowsAffected = 0;
result = _objBlRegion.BulkRegionTempInsert(_objCurInfo.GetCompanyCode(), dsAllRegions.Tables[0], "MIGRATION");
if (result.Split(':')[0].ToUpper() == "SUCCESS")
{
rowsAffected = _objBlRegion.UpdateRegionIndexFromTemptoRegionMaster(_objCurInfo.GetCompanyCode(), "MIGRATION",
guid, _objCurInfo.GetUserCode());
if (rowsAffected > 0)
{
result = "SUCCESS:Region Migration Done";
}
else
{
result = "ERROR:Error occurred while migration";
}
}
}
}
}
catch (Exception ex)
{
result = "FAILURE:" + ex.Message;
}
return(result);
}
public int InsertHolidayMaster(string regionCodes, string holidayDate, string holidayName, string mode, string holidayCode, string Old_HolidayDate)
{
int rowsAffected = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
List <MVCModels.HiDoctor_Master.RegionModel> lstRegion = new List <MVCModels.HiDoctor_Master.RegionModel>();
List <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = new List <MVCModels.HiDoctor_Master.HolidayModel>();
if (!string.IsNullOrEmpty(Old_HolidayDate))
{
Old_HolidayDate = Old_HolidayDate.Split('/')[2] + "-" + Old_HolidayDate.Split('/')[1] + "-" + Old_HolidayDate.Split('/')[0];
}
if (mode != "DELETE")
{
lstRegion = objRegion.GetRegions(objCurInfo.GetCompanyCode());
if (!string.IsNullOrEmpty(regionCodes))
{
string[] ar = regionCodes.Split(',');
for (int i = 0; i < ar.Length; i++)
{
MVCModels.HiDoctor_Master.HolidayModel objHoliday = new MVCModels.HiDoctor_Master.HolidayModel();
objHoliday.Company_Code = objCurInfo.GetCompanyCode();
if (mode == "INSERT")
{
objHoliday.Created_By = objCurInfo.GetUserName();
objHoliday.Created_DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
objHoliday.Holiday_Status = "0";
}
else
{
objHoliday.Updated_By = objCurInfo.GetUserName();
objHoliday.Updated_DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
objHoliday.Holiday_Code = holidayCode;
}
objHoliday.Holiday_Name = holidayName;
objHoliday.Holiday_Date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0];
objHoliday.Region_Code = ar[i];
var lstRegionType = lstRegion.AsEnumerable().Where(z => z.Region_Code == ar[i]).ToList();
if (lstRegionType.Count > 0)
{
objHoliday.Region_Type_Code = lstRegionType[0].Region_Type_Code;
}
lstHoliday.Add(objHoliday);
}
rowsAffected = objRegion.InsertHolidayMaster(lstHoliday, mode, objCurInfo.GetCompanyCode(), Old_HolidayDate);
}
}
else
{
MVCModels.HiDoctor_Master.HolidayModel objHoliday = new MVCModels.HiDoctor_Master.HolidayModel();
objHoliday.Holiday_Status = "1";
objHoliday.Holiday_Code = holidayCode;
objHoliday.Updated_By = objCurInfo.GetUserName();
objHoliday.Updated_DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
objHoliday.Company_Code = objCurInfo.GetCompanyCode();
objHoliday.Region_Code = regionCodes;
lstHoliday.Add(objHoliday);
rowsAffected = objRegion.InsertHolidayMaster(lstHoliday, mode, objCurInfo.GetCompanyCode(), Old_HolidayDate);
}
return(rowsAffected);
}
