/// <summary> /// DownLoad The statusMasterDetails into Excel /// </summary> /// <returns></returns> public void PutStatusMasterIntoExcel() { string companycode = _objcurrentInfo.GetCompanyCode(); string error = string.Empty; try { List <StatusMasterModel> lstStatusMaster = (List <StatusMasterModel>)GetStatusMasterDetails(); StringBuilder sb = new StringBuilder(); BLMaster objMaster = new BLMaster(); DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider(); sb.Append("<table WIDTH='40%' id='tblsummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Status Name</td>"); sb.Append("<td>Display Name</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (lstStatusMaster != null && lstStatusMaster.Count > 0) { int i = 0; foreach (var lstStatus in lstStatusMaster) { i++; sb.Append("<td id='Status_Name" + i + "'>" + lstStatus.Status_Name + "</td>"); sb.Append("<td id='Display_Name" + i + "'>" + lstStatus.Display_Name + "</td>"); sb.Append("<td id='Record_Status" + i + "'>" + lstStatus.Record_Status + "</td></tr>"); } } else { sb.Append("<span>No Records TO Display</span>"); } sb.Append("</body>"); sb.Append("</table>"); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string userName = _objcurrentInfo.GetUserName(); string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;; string fileName = "Status Master" + " - " + subdomainName + " - " + userName + ".xls"; string blobUrl = objAzureBlob.AzureBlobUploadText(sb.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } }
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 string InsertProjectActivityMapping(string projectcode, string activityCode, string startDate, string endDate) { try { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMaster _objBlMaster = new DataControl.BLMaster(); string createdBy = _objCurInfo.GetUserName(); return(_objBlMaster.InsertSalesActivityMapping(_objCurInfo.GetCompanyCode(), projectcode, activityCode, startDate, endDate, createdBy, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"))); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("ProjectCode", projectcode); dicObj.Add("ActivityCode", activityCode); dicObj.Add("StartDate", startDate); dicObj.Add("EndDate", endDate); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return("ERROR: " + ex.Message.ToString()); } }
/// <summary> /// DownLoad The ActivityMasterDetails into Excel /// </summary> public void PutActivityMasterIntoExcel() { string error = string.Empty; StringBuilder sb = new StringBuilder(); try { string companyCode = _objcurrentInfo.GetCompanyCode(); DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider(); BLMaster Master = new BLMaster(); DataSet dsActivityMaster = new DataSet(); dsActivityMaster = Master.GetLeaveTypeDetails(companyCode); //dsc sb.Append("<table WIDTH='75%' id='tblsummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Activity Name</td>"); sb.Append("<td>Start Date</td>"); sb.Append("<td>End Date</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("<tbody>"); // if (dsActivityMaster != null && dsActivityMaster.Tables[0] != null && dsActivityMaster.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsActivityMaster.Tables[0].Rows.Count; i++) { sb.Append("<td id='Activity_Name" + i + "'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Activity_Name"] + "</td>"); sb.Append("<td id='Start_Date" + i + " 'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Start_Date"] + "</td>"); sb.Append("<td id='End_Date" + i + " ' style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["End_Date"] + "</td>"); sb.Append("<td id='Row_Status" + i + " 'style='text-align:left;'>" + dsActivityMaster.Tables[0].Rows[i]["Row_Status"] + "</td></tr>"); } } else { sb.Append("<tr><td>No records To Display</td></tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string userName = _objcurrentInfo.GetUserName(); string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;; string fileName = "ActivityMaster" + " - " + subdomainName + " - " + userName + ".xls"; string blobUrl = objAzureBlob.AzureBlobUploadText(sb.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } }
public int InsertCampaignPlanner(string regionCode, string regionName, string cpName, string categoryCode, string categoryName, string sfcDetails, string doctorDetails, string Mode, string CPCode, string workArea, string CPStatus, string EditPrivilege) { int rowsAffected = 0; try { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); DataControl.BLCampaignPlanner _objBlCP = new DataControl.BLCampaignPlanner(); rowsAffected = _objBlCP.InsertCampaignPlanner(_objCurInfo.GetCompanyCode(), regionCode, regionName, cpName, categoryCode, categoryName, sfcDetails, doctorDetails, Mode, CPCode, _objCurInfo.GetUserName(), workArea, CPStatus, EditPrivilege); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("regionCode", regionCode); dicObj.Add("regionName", regionName); dicObj.Add("cpName", cpName); dicObj.Add("categoryCode", categoryCode); dicObj.Add("categoryName", categoryName); dicObj.Add("sfcDetails", sfcDetails); dicObj.Add("doctorDetails", doctorDetails); dicObj.Add("Mode", Mode); dicObj.Add("CPCode", CPCode); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); } return(rowsAffected); }
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 void GetHolidayExcelDownload(FormCollection coll) { string blobUrl = string.Empty, error = string.Empty; DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); string holidayDate = string.Empty; if (!string.IsNullOrEmpty(coll["hdnSearchDate"])) { holidayDate = Convert.ToString(coll["hdnSearchDate"]); } try { System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; DataControl.CurrentInfo _objCurr = new DataControl.CurrentInfo(); string content = GetSearchHolidayDetails(holidayDate); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string userName = _objCurr.GetUserName(); string subDomin = _objCurr.GetSubDomain(); string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(content.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); } }
public ActionResult OrderAdd(string id) { BLUser objUser = new BLUser(); List <MVCModels.HiDoctor_Master.UserModel> lstUser = new List <MVCModels.HiDoctor_Master.UserModel>(); lstUser = objUser.GetChildUsersCodeAndNameOnly(_objCurrentInfo.GetCompanyCode(), _objCurrentInfo.GetUserCode()); ViewBag.Child_User_Count = lstUser.Count(); string OrderMode = id.Split('~')[0]; if (OrderMode == "Add") { ViewBag.OrderMode = OrderMode; ViewBag.action_Region_Code = _objCurrentInfo.GetRegionCode(); } else { ViewBag.OrderMode = OrderMode; ViewBag.Order_Id = id.Split('~')[1]; ViewBag.action_Region_Code = id.Split('~')[2]; } ViewBag.Current_Date = System.DateTime.Now.ToString("yyyy-MM-dd"); ViewBag.action_User_Name = _objCurrentInfo.GetUserName(); ViewBag.action_User_Code = _objCurrentInfo.GetUserCode(); ViewBag.Current_Month = System.DateTime.Now.Month + "-" + System.DateTime.Now.Year; ViewBag.Previous_Month = System.DateTime.Now.AddMonths(-1).Month + "-" + System.DateTime.Now.AddMonths(-1).Year; ViewBag.Next_Month = System.DateTime.Now.AddMonths(1).Month + "-" + System.DateTime.Now.AddMonths(1).Year; return(View()); }
public string GetPrivilegeAccessLogReport(string fromDate, string toDate, string userTypeCodes, string isExcel) { StringBuilder strContent = new StringBuilder(); string blobUrl = string.Empty; strContent.Append("<table><tr><td colspan='7' class='tblhead'>Privilege Log Report - Log Period " + fromDate.Split('-')[2] + "/" + fromDate.Split('-')[1] + "/" + fromDate.Split('-')[0] + " to " + toDate.Split('-')[2] + "/" + toDate.Split('-')[1] + "/" + toDate.Split('-')[0] + "</td></tr></table>"); strContent.Append("<table class='table table-striped'><thead><tr><th>S.No</th><th>Date</th><th>Privilege Name </th><th>Privilege Value Name</th>"); strContent.Append("<th>User Type Name</th><th>Record Status</th><th>Request from</th><th>Request Date</th><th>Request Reason</th>"); strContent.Append("<th>Support User Name</th><th>Updated By</th></tr></thead><tbody>"); try { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMaster objMaster = new DataControl.BLMaster(); List <MVCModels.HiDoctor_Master.UserTypePrivilegeMappingModel> lstPrivilege = new List <MVCModels.HiDoctor_Master.UserTypePrivilegeMappingModel>(objMaster.GetPrivilegeLogReport(objCurInfo.GetCompanyCode(), fromDate, toDate, userTypeCodes)); int i = 0; if (lstPrivilege.Count > 0) { foreach (var dr in lstPrivilege) { i++; strContent.Append("<tr><td>" + i + "</td>"); strContent.Append("<td>" + dr.Mapping_Updated_Date + "</td>"); strContent.Append("<td>" + dr.Privilege_Name + "</td>"); strContent.Append("<td>" + dr.Privilege_Value_Name + "</td>"); strContent.Append("<td>" + dr.User_Type_Name + "</td>"); strContent.Append("<td>" + dr.Record_Status + "</td>"); strContent.Append("<td>" + dr.Request_From + "</td>"); strContent.Append("<td>" + dr.Request_Date + "</td>"); strContent.Append("<td>" + dr.Request_Reason + "</td>"); strContent.Append("<td>" + dr.Support_User_Name + "</td>"); strContent.Append("<td>" + dr.Mapping_Updated_By + "</td></tr>"); } } strContent.Append("</tbody>"); strContent.Append("</table>"); if ("Y" == isExcel) { 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 compCode = objCurInfo.GetCompanyCode(); string fileName = "PRIVILEGELOG_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); strContent.Clear(); strContent.Append(blobUrl); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } return(strContent.ToString()); }
public string SetDCRUnapprove(string dcrDate, string unapprovealReason, string flag, string calcFieldStatus) { string companyCode = _objCurrentInfo.GetCompanyCode(); string userName = _objCurrentInfo.GetUserName(); string userCode = _objCurrentInfo.GetUserCode(); string dcrCode = _objCurrentInfo.GetDCRCode(dcrDate); calcFieldStatus = calcFieldStatus.ToUpper() == "APPLIED" ? "1" : "2"; string result = string.Empty; result = _objSPData.CheckTheDCRCanbeUnapprove(companyCode, userCode, dcrCode, flag); if (result == "SUCCESS") { result = _objSPData.SetDCRUnapprove(companyCode, userCode, userName, dcrDate, dcrCode, flag, unapprovealReason, calcFieldStatus); } return(result); }
//For excell public void PutRequestCategoryMasterIntoExcel() { string blobUrl = string.Empty; string error = string.Empty; StringBuilder sbTableContent = new StringBuilder(); DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo(); string companyCode = _objCurrentInfo.GetCompanyCode(); StringBuilder sb = new StringBuilder(); DataControl.BLMaster _objBlmaster = new DataControl.BLMaster(); DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); try { DataControl.JSONConverter json = new DataControl.JSONConverter(); List <RequestCategoryMasterModel> lstRequestMap = new List <RequestCategoryMasterModel>(); DataControl.BLMaster _objMapping = new DataControl.BLMaster(); lstRequestMap = (List <RequestCategoryMasterModel>)_objMapping.GetRequestCategoryDetail(companyCode); if (lstRequestMap != null && lstRequestMap.Count > 0) { sbTableContent.Append("<table id='tblrequest' class='table table-striped' >"); sbTableContent.Append("<thead class='active'>"); sbTableContent.Append("<tr style='background-color: #428bca'>"); sbTableContent.Append("<td>Request Category Name</td>"); sbTableContent.Append("<td>Status</td>"); sbTableContent.Append("</tr>"); sbTableContent.Append("</thead>"); sbTableContent.Append("<tbody>"); foreach (var item in lstRequestMap) { sbTableContent.Append("<tr><td>" + item.Request_Category_Name + "</td>"); sbTableContent.Append("<td>" + item.Request_Category_Status + "</td></tr>"); } } sbTableContent.Append("</tbody>"); sbTableContent.Append("</table>"); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string userName = _objCurrentInfo.GetUserName(); string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;; string fileName = "RequestCategoryMaster " + " - " + subdomainName + " - " + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(sbTableContent.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>();; DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } }
public void PutPayslipmetadataintoExcel() { string error = string.Empty; StringBuilder sb = new StringBuilder(); try { DataControl.BLUser objBlUser = new BLUser(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); string companyCode = _objCurInfo.GetCompanyCode(); DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider(); List <MVCModels.HiDoctor_Master.PaySlipMetaDataModel> lstdata = new List <MVCModels.HiDoctor_Master.PaySlipMetaDataModel>(); lstdata = objBlUser.GetpaysliprefsheetDetail(companyCode).ToList(); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); sb.Append("<table WIDTH='40%' id='tblpaysummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>User Type Name</td>"); sb.Append("<td>Column No</td>"); sb.Append("<td>Column Name</td>"); sb.Append("<td>DataTypeName</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (lstdata.Count > 0) { foreach (var lstPayMetadata in lstdata) { sb.Append("<tr><td>" + lstPayMetadata.User_Type_Name + "</td>"); sb.Append("<td>" + lstPayMetadata.Column_No + "</td>"); sb.Append("<td>" + lstPayMetadata.Column_Name + "</td>"); sb.Append("<td>" + lstPayMetadata.DataTypeAliasName + "</td></tr>"); } } string userName = _objCurInfo.GetUserName(); string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;; string fileName = "PaySlipMetaData" + " - " + subdomainName + " - " + userName + ".xls"; string blobUrl = objAzureBlob.AzureBlobUploadText(sb.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } }
/// <summary> /// Insert and Update /// </summary> /// <param name="subRegionCodeVal"></param> /// <param name="subRegionName"></param> /// <param name="UnderRegionName"></param> /// <param name="underRegionCode"></param> /// <param name="mode"></param> /// <returns></returns> public int InsertandUpdateSubRegionmaster(string subRegionCodeVal, string subRegionName, string UnderRegionName, string underRegionCode, string mode) { try { BLMaster _objMaster = new BLMaster(); SubRegionMasterModel objSubRegion = new SubRegionMasterModel(); List <SubRegionMasterModel> lstSubRegionMaster = new List <SubRegionMasterModel>(); if (mode.ToUpper() == "I") // Insert the Date { objSubRegion.Company_Code = _objcurrentInfo.GetCompanyCode(); objSubRegion.SubRegion_Name = subRegionName; objSubRegion.SubRegion_Status = "1"; objSubRegion.UnderRegion_Code = UnderRegionName; objSubRegion.Created_By = _objcurrentInfo.GetUserName(); objSubRegion.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstSubRegionMaster.Add(objSubRegion); int result = _objMaster.InsertforSubRegionMaster(lstSubRegionMaster); return(result); } else { objSubRegion.Company_Code = _objcurrentInfo.GetCompanyCode(); objSubRegion.SubRegion_Code = subRegionCodeVal; objSubRegion.SubRegion_Name = subRegionName; objSubRegion.UnderRegion_Code = UnderRegionName; objSubRegion.Updated_By = _objcurrentInfo.GetUserName(); objSubRegion.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstSubRegionMaster.Add(objSubRegion); int result = _objMaster.UpdateforSubRegionMaster(lstSubRegionMaster); return(result); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:subRegionName", subRegionName); dicContext.Add("Filter:subRegionCodeVal", subRegionCodeVal); dicContext.Add("Filter:underRegionCode", underRegionCode); dicContext.Add("Filter:mode", mode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
///DcrStatusMaster for HospitalField///// public bool InsertMappedHospitalRegionsField(List <DCRRegionModel> lstRegions) { bool result = false; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string UserName = objCurInfo.GetUserName(); result = _objBLDcrStatusMaster.InsertMappedHospitalRegionsField(lstRegions, UserName); return(result); }
public int UnMapHospitalRegionsField(string Regioncode) { int result = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string UserName = objCurInfo.GetUserName(); result = _objBLDcrStatusMaster.UnMapHospitalRegionsField(Regioncode, UserName); return(result); }
public string UploadAttachment(FormCollection coll) { try { System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; DataControl.CurrentInfo objCur = new DataControl.CurrentInfo(); string companyCode = objCur.GetCompanyCode(); string newFilename = string.Empty; var container = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse( ConfigurationManager.AppSettings["NBBLOBACCKEY"]).CreateCloudBlobClient() .GetContainerReference(companyCode.ToLower()); container.CreateIfNotExists(); //int blocksCount = int.Parse(coll["blocksCount"].ToString()); //string fileName = coll["fileName"].ToString(); //long fileSize = long.Parse(coll["fileSize"].ToString()); int blocksCount = int.Parse(coll["blocksCount"].ToString()); string fileName = coll["fileName"].ToString(); fileName = fileName.Substring(fileName.LastIndexOf("\\") + 1); newFilename = fileName; string fileExtenstion = fileName.Substring(fileName.LastIndexOf(".")); long fileSize = long.Parse(coll["fileSize"].ToString()); newFilename = newFilename.Substring(0, newFilename.LastIndexOf('.')); newFilename = newFilename.ToString().Trim().Replace(" ", "_"); //Special Character are replaced. newFilename = Regex.Replace(newFilename, @"[^0-9a-zA-Z_]+", "_"); fileName = newFilename + "_" + objCur.GetUserName() + "_" + DateTime.Now.ToString("ddMMyyyyHHmmssfff") + fileExtenstion; var fileToUpload = new MVCModels.CloudFile() { BlockCount = blocksCount, FileName = fileName, Size = fileSize, BlockBlob = container.GetBlockBlobReference(fileName), StartTime = DateTime.Now, IsUploadCompleted = false, UploadStatusMessage = string.Empty }; Session.Add("CurrentFile", fileToUpload); return(fileName); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Method:", MethodBase.GetCurrentMethod().Name); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); throw ex; } }
//Send Password public string GetandSendPassWord(string newPassWord, string usercode, int mailvalue) { string companyCode = _objcurrentInfo.GetCompanyCode(); string userName = _objcurrentInfo.GetUserName(); string strmail = ""; string strMailid = ""; string strUserName = ""; string result = ""; try { DataSet dsEmail = new DataSet(); DataSet dspassword = new DataSet(); BLUser _objUser = new BLUser(); if (mailvalue == 0) { dspassword = _objUser.GetPassword(companyCode, usercode); strUserName = dspassword.Tables[0].Rows[0]["User_Name"].ToString(); string pwdflag = _objUser.UpdatePasswordReset(companyCode, usercode, newPassWord); result = "SAVED"; } else { dsEmail = _objUser.checkEmailid(companyCode, usercode); if (dsEmail.Tables[0].Rows.Count > 0) { strMailid = dsEmail.Tables[0].Rows[0]["Email_Id"].ToString(); dspassword = _objUser.GetPassword(companyCode, usercode); strUserName = dspassword.Tables[0].Rows[0]["User_Name"].ToString(); string pwdflag = _objUser.UpdatePasswordReset(companyCode, usercode, newPassWord); if (!string.IsNullOrEmpty(strMailid)) { strmail = SendMail(newPassWord, strUserName, strMailid); result = strmail + "*" + strMailid; } } else { result = "ERROR"; } } return(result); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:UserName", usercode); dicContext.Add("Filter:newPassWord", newPassWord); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
//public string GetDisabledUsers() //{ // StringBuilder strUsers = new StringBuilder(); // DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); // DataControl.BLUser objUser = new DataControl.BLUser(); // IEnumerable<MVCModels.HiDoctor_Master.UserModel> lstUser = null; // lstUser = objUser.GetDisabledUsers(objCurInfo.GetCompanyCode()); // strUsers.Append("<ul>"); // if (lstUser != null) // { // foreach (var user in lstUser) // { // strUsers.Append("<li onclick='fnGetUser(\"" + user.User_Code + "\")'>" + user.User_Name + "</li>"); // } // } // strUsers.Append("</ul>"); // return strUsers.ToString(); //} //public string GetResignedUserLeaveTakenReport() //{ // StringBuilder strTblContent = new StringBuilder(); // DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); // DataControl.BLUser objUser = new DataControl.BLUser(); // DataControl.BLLeave objLeave = new DataControl.BLLeave(); // return strTblContent.ToString(); //} #region get user menu access log report public string GetUserMenuAccessLogReport(string fromDate, string toDate, string userTypeCodes, string isExcel) { StringBuilder strContent = new StringBuilder(); string blobUrl = string.Empty; strContent.Append("<table><tr><td colspan='7' class='tblhead'>Menu Access Log Report - Log Period " + fromDate.Split('-')[2] + "/" + fromDate.Split('-')[1] + "/" + fromDate.Split('-')[0] + " to " + toDate.Split('-')[2] + "/" + toDate.Split('-')[1] + "/" + toDate.Split('-')[0] + "</td></tr></table>"); strContent.Append("<table class='table table-striped'><thead><tr><th>S.No</th><th>Date</th><th>User Type Name </th><th>Menu Name</th>"); strContent.Append("<th>Menu URL</th><th>Access</th><th>Changed By</th></tr></thead><tbody>"); try { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLMaster objMaster = new DataControl.BLMaster(); List <MVCModels.UserTypeMenuAccessModel> lstUserMenu = new List <UserTypeMenuAccessModel>(objMaster.GetUserTypeMenuAccessLog(objCurInfo.GetCompanyCode(), fromDate, toDate, userTypeCodes)); int i = 0; if (lstUserMenu.Count > 0) { foreach (var dr in lstUserMenu) { i++; strContent.Append("<tr><td>" + i + "</td>"); strContent.Append("<td>" + dr.Updated_Date + "</td>"); strContent.Append("<td>" + dr.User_Type_Name + "</td>"); strContent.Append("<td>" + dr.Menu_Text + "</td>"); strContent.Append("<td>" + dr.Menu_URL + "</td>"); strContent.Append("<td>" + dr.Access + "</td>"); strContent.Append("<td>" + dr.Updated_By + "</td></tr>"); } } strContent.Append("</tbody>"); strContent.Append("</table>"); if ("Y" == isExcel) { 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 compCode = objCurInfo.GetCompanyCode(); string fileName = "MENUACCESSLOG_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); strContent.Clear(); strContent.Append(blobUrl); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } return(strContent.ToString()); }
public void PutProjectActivityIntoAzure(FormCollection coll) { try { string error = string.Empty; DataControl.BLMaster _objBlMaster = new DataControl.BLMaster(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider(); StringBuilder tblBuilder = new StringBuilder(); string companyCode = _objCurInfo.GetCompanyCode(); int rowNum = 0; DataSet dsProjActMapp = _objBlMaster.GetSalesActivityMapping(companyCode); if (dsProjActMapp != null && dsProjActMapp.Tables.Count > 0 && dsProjActMapp.Tables[0].Rows.Count > 0) { tblBuilder.Append("<table id='tblSFC' class='table table-striped' cellpadding='0' cellspacing='0'>"); tblBuilder.Append("<thead><tr><th>Project Name</th><th>Activity Name</th><th>Start Date</th><th>End Date</th><th>Status</th></tr></thead>"); tblBuilder.Append("<tbody>"); foreach (DataRow dr in dsProjActMapp.Tables[0].Rows) { rowNum++; tblBuilder.Append("<tr>"); tblBuilder.Append("<td>" + dr["Project_Name"].ToString() + "<input type='hidden' id='hdnProjCode_" + rowNum + "' value='" + dr["Project_Code"].ToString() + "' /></td>"); tblBuilder.Append("<td>" + dr["Activity_Name"].ToString() + "<input type='hidden' id='hdnActivityCode_" + rowNum + "' value='" + dr["Activity_Code"].ToString() + "' /></td>"); tblBuilder.Append("<td id='tdStartDate_" + rowNum + "'>" + dr["StartDate"].ToString() + "</td>"); tblBuilder.Append("<td id='tdEndDate_" + rowNum + "'>" + dr["EndDate"].ToString() + "</td>"); tblBuilder.Append("<td id='tdStatus_" + rowNum + "'>" + dr["Status"].ToString() + "</td>"); tblBuilder.Append("</tr>"); } tblBuilder.Append("</tbody>"); tblBuilder.Append("</table>"); } 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 subdomainName = HttpContext.Request.Url.DnsSafeHost.ToString(); string fileName = "ProjectActivityMapping" + " - " + subdomainName + " - " + userName + ".xls"; string blobUrl = objAzureBlob.AzureBlobUploadText(tblBuilder.ToString(), accKey, fileName, "bulkdatasvc"); objFileDownload.DownloadFile(blobUrl, fileName, out error); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); } }
public int AddNewStatus(string Division, string Usertype, string Status, string Catagory, string NewStatus) { int result = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string companyCode = objCurInfo.GetCompanyCode(); string username = objCurInfo.GetUserName(); result = _objBLDcrStatusMaster.AddNewStatus(companyCode, username, Usertype, Division, Status, Catagory, NewStatus); return(result); }
// Inert or update Sales order(applied or drafted status) public string InsertOTC(string orderId, string orderDate, string isSubmit, string productString, string custCode, string salesPersonCode , string salesPersonName, string orderValue, string remarks, string refNumber, string productCodes, string offerCodes, string dueDate) { BAL_OTC objBALOTC = new BAL_OTC(); salesPersonCode = (salesPersonCode == IsSession) ? _objcurrentInfo.GetRegionCode() : salesPersonCode; string enterBy = _objcurrentInfo.GetUserCode(); string enterByRegion = _objcurrentInfo.GetRegionCode(); salesPersonName = (salesPersonName == "") ? _objcurrentInfo.GetUserName() : salesPersonName.Split('(')[0]; return(objBALOTC.InsertOTC(_objcurrentInfo.GetCompanyCode(), orderId, orderDate, isSubmit, productString, custCode, salesPersonCode, salesPersonName, enterBy, enterByRegion, orderValue, remarks, refNumber, productCodes, offerCodes, dueDate)); }
// // GET: /Division/ public ActionResult Index() { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); string getusertypename = GetUserType(); ViewBag.getusertypename = getusertypename; ViewBag.CompanyCode = _objCurInfo.GetCompanyCode(); ViewBag.UserName = _objCurInfo.GetUserName(); ViewBag.User_Code = _objCurInfo.GetUserCode(); ViewBag.Region_Code = _objCurInfo.GetRegionCode(); return(View()); }
public int UnmapRegionslock(string Regioncode) { int result = 0; _objBLRegion = new BLRegion(); _objcurrentInfo = new CurrentInfo(); string UserName = string.Empty; UserName = _objcurrentInfo.GetUserName(); result = _objBLRegion.UnmapRegionslock(Regioncode, UserName); return(result); }
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); }
//Insert category// public int InsertAPICategory(string CategoryName, string status, string Description) { DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string createdBy = objCurInfo.GetUserName(); string createdDate = DateTime.Now.ToString(); try { int result = _objMapping.APIInsertCategory(CategoryName, status, createdBy, createdDate, Description); return(result); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:CategoryName", CategoryName); dicContext.Add("Filter:Status", status); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(2); } }
//UpdateAPIService public int UpdateAPIService(string APICategoryCode, string ServiceId, string ServiceDescription, string ServiceType, string ServiceParamNos, string ServiceParams, string ExcelOutPutHeaders, string ServiceInternalSPName, string serviceTypeMappingClassName, string serviceName, string IsVisible, string apiID) { DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string createdBy = objCurInfo.GetUserName(); string createdDate = DateTime.Now.ToString(); if (IsVisible == "1") { IsVisible = "Y"; } try { int result = _objMapping.UpdateAPIService(APICategoryCode, ServiceId, ServiceDescription, ServiceType, ServiceParamNos, ServiceParams, ExcelOutPutHeaders, ServiceInternalSPName, serviceTypeMappingClassName, serviceName, IsVisible, apiID); return(result); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:APICategoryCode", APICategoryCode); dicContext.Add("Filter:ServiceId", ServiceId); dicContext.Add("Filter:ServiceDescription", ServiceDescription); dicContext.Add("Filter:Status", ServiceDescription); dicContext.Add("Filter:ServiceType", ServiceType); dicContext.Add("Filter:ServiceParamNos", ServiceParamNos); dicContext.Add("Filter:ServiceParams", ServiceParams); dicContext.Add("Filter:ExcelOutPutHeaders", ExcelOutPutHeaders); dicContext.Add("Filter:ServiceInternalSPName", ServiceInternalSPName); dicContext.Add("Filter:serviceTypeMappingClassName", serviceTypeMappingClassName); dicContext.Add("Filter:serviceName", serviceName); dicContext.Add("Filter:IsVisible", IsVisible); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(2); } }
//public bool InsertRegionLock(List<RegionLockMappingModel> lstRegionLockMapping) //{ // bool result = false; // DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); // string UserName = objCurInfo.GetUserName(); // string CompanyCode = objCurInfo.GetCompanyCode(); // string RegionCode = objCurInfo.GetRegionCode(); // string RegionTypeCode = null; // //string RegionTypeCode = lstRegionLockMapping[i].Region_Type_Code; // result = _objBLRegion.InsertRegionLockMapping(lstRegionLockMapping, CompanyCode, RegionCode, RegionTypeCode, UserName); // return result; //} public bool InsertRegionLock(string regionLockJson) { try { _objcurrentInfo = new CurrentInfo(); _objBLRegion = new BLRegion(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string UserName = objCurInfo.GetUserName(); string CompanyCode = objCurInfo.GetCompanyCode(); // RegionCode = objCurInfo.GetRegionCode(); // string company_Code = _objcurrentInfo.GetCompanyCode(); return(_objBLRegion.InsertRegionLockMapping(CompanyCode, UserName, regionLockJson)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("region Lock Json:", regionLockJson); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); throw; } }
public int UpdateAPICategory(string CategoryName, string status, string description, string APIcategoryID) { DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string createdBy = objCurInfo.GetUserName(); string createdDate = DateTime.Now.ToString(); try { int result = _objMapping.UpdateAPICategory(CategoryName, status, createdBy, createdDate, description, APIcategoryID); return(result); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:requestCode", status); dicContext.Add("Filter:userTypeCode", APIcategoryID); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(2); } }
public string GetEmployeeAuditReport(string fromDate, string toDate, string isExcel) { StringBuilder strContent = new StringBuilder(); string blobUrl = string.Empty; strContent.Append("<table><tr><td colspan='7' class='tblhead'>Employee Audit Report - Period " + fromDate.Split('-')[2] + "/" + fromDate.Split('-')[1] + "/" + fromDate.Split('-')[0] + " to " + toDate.Split('-')[2] + "/" + toDate.Split('-')[1] + "/" + toDate.Split('-')[0] + "</td></tr></table>"); strContent.Append("<table class='table table-striped' id='tblEmployee'><thead><tr><th>S.No</th><th>Date</th><th>Employee Name </th><th>Employee Number</th>"); strContent.Append("<th>Gender</th><th>Date of birth</th><th>Address</th><th>Phone</th><th>Mobile</th>"); strContent.Append("<th>Employee Status</th><th>Email Id</th><th>Date of Joining</th><th>EDN Proof</th><th>Salary Proof</th>"); strContent.Append("<th>Resume Given</th><th>Resignation Submitted</th><th>Appointed</th><th>Bank Account Number1</th><th>Bank Account Number2</th>"); strContent.Append("<th>PF Number</th><th>PAN Number</th><th>Effective From</th><th>Effective To</th><th>Confirmation Date</th>"); strContent.Append("<th>Employee Entity Type</th><th>Created By</th><th>Created DateTime</th>"); strContent.Append("<th>Updated By</th><th>Updated DateTime</th></tr></thead><tbody>"); try { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLUser objUser = new DataControl.BLUser(); List <MVCModels.HiDoctor_Master.EmployeeModel> lstEmp = new List <MVCModels.HiDoctor_Master.EmployeeModel>(objUser.GetEmployeeAuditReport(objCurInfo.GetCompanyCode(), fromDate, toDate)); int i = 0; if (lstEmp.Count > 0) { foreach (var dr in lstEmp) { i++; strContent.Append("<tr><td>" + i + "</td>"); strContent.Append("<td>" + Convert.ToString(dr.Updated_DateTime).Substring(0, 10) + "</td>"); strContent.Append("<td>" + dr.Employee_Name + "</td>"); strContent.Append("<td>" + dr.Employee_Number + "</td>"); strContent.Append("<td>" + dr.Gender + "</td>"); if (dr.Date_Of_Birth == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Date_Of_Birth + "</td>"); } //strContent.Append("<td>" + dr.Date_Of_Birth + "</td>"); strContent.Append("<td>" + dr.Address + "</td>"); strContent.Append("<td>" + dr.Phone + "</td>"); strContent.Append("<td>" + dr.Mobile + "</td>"); strContent.Append("<td>" + dr.Employee_Status + "</td>"); strContent.Append("<td>" + dr.Email_Id + "</td>"); if (dr.Date_of_Joining == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Date_of_Joining + "</td>"); } strContent.Append("<td>" + ((dr.EDN_Proof == "0") ? "No" : "Yes") + "</td>"); strContent.Append("<td>" + ((dr.Salary_Proof == "0") ? "No" : "Yes") + "</td>"); strContent.Append("<td>" + ((dr.Resume_Given == "0") ? "No" : "Yes") + "</td>"); strContent.Append("<td>" + ((dr.Resignation_Submitted == "0") ? "No" : "Yes") + "</td>"); strContent.Append("<td>" + ((dr.Appointed == "0") ? "No" : "Yes") + "</td>"); strContent.Append("<td>" + dr.SCB_Account_Number + "</td>"); strContent.Append("<td>" + dr.ICICI_Account_Number + "</td>"); strContent.Append("<td>" + dr.PF_Number + "</td>"); strContent.Append("<td>" + dr.PAN_Number + "</td>"); if (dr.Effective_From == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Effective_From + "</td>"); } if (dr.Effective_To == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Effective_To + "</td>"); } if (dr.Confirmation_Date == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Confirmation_Date + "</td>"); } strContent.Append("<td>" + dr.Employee_Entity_Type + "</td>"); strContent.Append("<td>" + dr.Created_By + "</td>"); if (dr.Created_DateTime == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Created_DateTime + "</td>"); } strContent.Append("<td>" + dr.Updated_By + "</td>"); if (dr.Updated_DateTime == "01/01/1900") { strContent.Append("<td></td>"); } else { strContent.Append("<td>" + dr.Updated_DateTime + "</td>"); } strContent.Append("</tr>"); } } else { strContent.Append("<tr><td colspan='29' style='text-align:center;'>No records found</td></tr>"); } strContent.Append("</tbody>"); strContent.Append("</table>"); if ("Y" == isExcel) { 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 compCode = objCurInfo.GetCompanyCode(); string fileName = "EMPLOYEEAUDITREPORT_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); strContent.Clear(); strContent.Append(blobUrl); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); } return(strContent.ToString()); }
///// <summary> ///// Get TP Master report for alumini users ///// </summary> ///// <param name="userCode"></param> ///// <param name="date"></param> ///// <returns>return the table content</returns> public string GetTPMasterReportForAluminiUsers(string userCode, string month, string year, string isExcel, string monthName) { StringBuilder strContent = new StringBuilder(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BL_Report objReport = new DataControl.BL_Report(); DataControl.BLUser objUser = new DataControl.BLUser(); #region tp header strContent.Append(objUser.GetReportHeaderTableString(objCurInfo.GetCompanyCode(), userCode, monthName + "-" + year, "", "", "")); strContent.Append("<table class='table table-striped' cellpadding=0 cellspacing=0 id ='tblTPReport'>"); strContent.Append("<thead>"); strContent.Append("<tr id='tblTr'>"); strContent.Append("<th>User Name</th>"); strContent.Append("<th>TP Date</th>"); strContent.Append("<th>Call Objective</th>"); strContent.Append("<th>Activity Name</th>"); strContent.Append("<th>Category</th>"); strContent.Append("<th>CP Name</th>"); strContent.Append("<th>Meeting Point </th>"); strContent.Append("<th>Meeting Time </th>"); strContent.Append("<th>Work Place</th>"); strContent.Append("<th>SFC</th>"); strContent.Append("<th>Accomp Name</th>"); strContent.Append("<th>No oF Planned Doctors</th>"); strContent.Append("<th>Entered Date</th>"); strContent.Append("<th>Entered By</th>"); strContent.Append("<th>Remarks</th>"); strContent.Append("<th>Status</th>"); strContent.Append("<th>Approved/Unapproved Date</th>"); strContent.Append("<th>Approve/Unapprove Reason</th>"); strContent.Append("</tr>"); strContent.Append("</thead>"); strContent.Append("<tbody>"); #endregion tp header try { DataSet ds = new DataSet(); ds = objReport.GetTPMasterReportForAlumniUsers(objCurInfo.GetCompanyCode(), month, year, userCode); if (ds.Tables.Count > 0) { int noOfDays = System.DateTime.DaysInMonth(Convert.ToInt32(year), Convert.ToInt32(month)); DateTime startDate = Convert.ToDateTime(year + "-" + month + "-01"); DateTime endDate = Convert.ToDateTime(year + "-" + month + "-" + noOfDays); DateTime dtStartDate = new DateTime(); DateTime dtEndDate = new DateTime(); dtStartDate = Convert.ToDateTime(startDate); dtEndDate = Convert.ToDateTime(endDate); DateTime dtDate = dtStartDate; TimeSpan ts; ts = dtEndDate - dtStartDate; for (var j = 0; j <= ts.Days; j++) { if (j != 0) { dtDate = dtDate.AddDays(Convert.ToDouble(1)); } DataRow[] dr = ds.Tables[0].AsEnumerable().Where(a => Convert.ToInt32(a["Day"]) == dtDate.Day && Convert.ToInt32(a["Month"]) == dtDate.Month && Convert.ToInt32(a["Year"]) == dtDate.Year).ToArray(); if (dr.Length > 0) { strContent.Append("<tr>"); strContent.Append("<td>" + Convert.ToString(dr[0]["User_Name"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["TP_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Activity_Code"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Project_Code"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Category"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["CP_name"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Meeting_point"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Meeting_Time"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Work_Area"]) + "</td>"); #region TP SFC details // var sfcDet = jsonPath(jsData, "$.Tables[4].Rows[?(@.TP_Id=='" + details[0].TP_Id + "')]"); DataRow[] drSFC = ds.Tables[2].AsEnumerable().Where(z => Convert.ToString(z["TP_Id"]) == Convert.ToString(dr[0]["TP_Id"])).ToArray(); StringBuilder strSFC = new StringBuilder(); if (drSFC.Length > 0) { for (int s = 0; s < drSFC.Length; s++) { if (!string.IsNullOrEmpty(Convert.ToString(drSFC[s]["From_Place"]))) { strSFC.Append("" + (s + 1) + "/ " + Convert.ToString(drSFC[s]["From_Place"]) + " to " + Convert.ToString(drSFC[s]["To_Place"]) + "<br />"); } } } strContent.Append("<td>" + strSFC.ToString() + "</td>"); #endregion TP SFC details StringBuilder strAccName = new StringBuilder(); if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accomp_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accomp_Name"]) + " <br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist2_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist2_Name"]) + "<br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist3_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist3_Name"]) + "<br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist4_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist4_Name"]) + "<br /> "); } strContent.Append("<td>" + strAccName.ToString() + "</td>"); DataRow[] drDoctors = ds.Tables[1].AsEnumerable().Where(c => Convert.ToString(c["TP_Date"]) == Convert.ToString(dr[0]["TP_Date"])).ToArray(); if (drDoctors.Length > 0) { // content += "<td>" + dJsonData.length + "</td>"; strContent.Append("<td align='center' ><span onclick='fnTPDetails(\"" + userCode + "_" + dr[0]["TP_Date"] + "\")' style='text-decoration:underline;cursor:pointer'>" + drDoctors.Length + "</span></td>"); } else { strContent.Append("<td></td>"); } strContent.Append("<td>" + Convert.ToString(dr[0]["Entered_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Entered_by"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Remarks"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Status"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Approved_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Unapprove_Reason"]) + "</td>"); strContent.Append("</tr>"); } else { #region holiday details DataRow[] drHoliday = ds.Tables[3].AsEnumerable().Where(a => Convert.ToInt32(a["Day"]) == dtDate.Day && Convert.ToInt32(a["Month"]) == dtDate.Month && Convert.ToInt32(a["Year"]) == dtDate.Year).ToArray(); // var details = jsonPath(jsData, "$.Tables[5].Rows[?(@.Day=='" + day + "' & @.Month=='" + month + "' & @.Year=='" + year + "')]"); if (drHoliday.Length > 0) { if (Convert.ToString(drHoliday[0]["Type"]) == "S") { strContent.Append("<tr>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Date"]) + "</td>"); strContent.Append("<td style='background: #efefef;'> - Sunday</td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("</tr>"); } else { strContent.Append("<tr>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Date"]) + "</td>"); strContent.Append("<td style='background: #efefef;'> - Holiday - </td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Holiday"]) + "</td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("</tr>"); } } #endregion holiday details } } } } catch (Exception ex) { } strContent.Append("</tbody>"); strContent.Append("</table>"); string blobUrl = string.Empty; if ("Y" == isExcel) { 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 compCode = objCurInfo.GetCompanyCode(); string fileName = "TPMASTERALUMINI_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); strContent.Clear(); strContent.Append(blobUrl); } return(strContent.ToString()); }