public JsonResult GetEntityAndUserType() { try { List <object> lstCat = new List <object>(); List <object> lstUserType = new List <object>(); BL_DCRHeader _objHead = new BL_DCRHeader(); BLMaster _objMast = new BLMaster(); lstCat = _objHead.GetCategory(_objCurr.GetCompanyCode()); lstUserType = _objMast.GetUserType(_objCurr.GetCompanyCode()); List <JsonResult> lst = new List <JsonResult> { Json(lstCat, JsonRequestBehavior.AllowGet), Json(lstUserType, JsonRequestBehavior.AllowGet) }; return(Json(lst, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj); return(null); } }
/// <summary> /// Insert and Update /// </summary> /// <param name="ExpenseEntityName"></param> /// <param name="EffectiveFrom"></param> /// <param name="EffectiveTo"></param> /// <param name="ExpenseEntityCodeval"></param> /// <param name="Mode"></param> /// <returns></returns> public int InsertandUpdateTheExpenseEntityMaster(string ExpenseEntityName, string EffectiveFrom, string EffectiveTo, string ExpenseEntityCodeval, string Mode) { string companyCode = _objcurrentInfo.GetCompanyCode(); try { string data = string.Empty; BLMaster Master = new BLMaster(); if (Mode.ToUpper() == "I") //Insert Data { string ExpenseEntityCode = _objData.GetMaxCode(_objcurrentInfo.GetCompanyCode(), "tbl_SFA_Expense_Entity_Master", "Expense_Entity_Code", "EEC"); string status = "1"; int InsertExpenseEntityMaster = Master.InsertExpenseEntityMaster(companyCode, ExpenseEntityCode, ExpenseEntityName, EffectiveFrom, EffectiveTo, status, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")); return(InsertExpenseEntityMaster); } else { int UpdateExpenseEntityMaster = Master.UpdateExpenseEntityMaster(companyCode, ExpenseEntityCodeval, ExpenseEntityName, EffectiveFrom, EffectiveTo, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")); return(UpdateExpenseEntityMaster); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:ExpenseEntityName", ExpenseEntityName); dicContext.Add("Filter:ExpenseEntityCodeval", ExpenseEntityCodeval); dicContext.Add("Filter:EffectiveFrom", EffectiveFrom); dicContext.Add("Filter:EffectiveTo", EffectiveTo); dicContext.Add("Filter:Mode", Mode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(3); } }
public int SaveExtendSFC(int distance_Fare_Code, int sfc_Version_No, DateTime dcr_Date, string remark, int sfc_Extend_Count) { BLMaster objMaster = new BLMaster(); _objCurrentInfo = new CurrentInfo(); return(objMaster.SaveExtendSFC(distance_Fare_Code, sfc_Version_No, dcr_Date, _objcurrentInfo.GetCompanyCode(), remark, _objcurrentInfo.GetUserCode(), sfc_Extend_Count)); }
/// <summary> /// Used to get the count of Existing SFC record for same region /// </summary> /// <param name="regionCode"></param> /// <param name="fromPlace"></param> /// <param name="toPlace"></param> /// <param name="categoryName"></param> /// <param name="travelMode"></param> /// <returns></returns> public JsonResult CheckExistingSFCforRegion(string regionCode, string fromPlace, string toPlace, string categoryName, string travelMode) { string message = string.Empty; Dictionary <string, int> dicTravleModeCount = new Dictionary <string, int>(); try { BLMaster _objDAL = new BLMaster(); CurrentInfo _objCurrentInfo = new CurrentInfo(); dicTravleModeCount = _objDAL.GetExistingSFCCount(_objCurrentInfo.GetCompanyCode(), regionCode, fromPlace, toPlace, categoryName, travelMode); return(Json(dicTravleModeCount)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("regionCode", regionCode); dicContext.Add("fromPlace", fromPlace); dicContext.Add("toPlace", toPlace); dicContext.Add("categoryName", categoryName); dicContext.Add("travelMode", travelMode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); throw ex; } }
/// <summary> /// Insert and Update /// </summary> /// <param name="activityName"></param> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="Mode"></param> /// <param name="updateActivityCode"></param> /// <returns></returns> public int InsertActivityMaster(string activityName, string startDate, string endDate, string Mode, string updateActivityCode) { string companyCode = _objcurrentInfo.GetCompanyCode(); string UpdatedBy = _objcurrentInfo.GetUserCode(); try { string data = string.Empty; BLMaster Master = new BLMaster(); if (Mode.ToUpper() == "I") // Insert Data { string ActivityCode = _objData.GetMaxCode(_objcurrentInfo.GetCompanyCode(), "tbl_SFA_Activity_Master", "Activity_Code", "ATY"); string status = "1"; int InsertActivityMaster = Master.InsertActivityMaster(companyCode, activityName, startDate, endDate, status, ActivityCode, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")); return(InsertActivityMaster); } else { int UpdateActivityMaster = Master.UpdateActivityMaster(companyCode, activityName, startDate, endDate, updateActivityCode, _objcurrentInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")); return(UpdateActivityMaster); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:activityName", activityName); dicContext.Add("Filter:startDate", startDate); dicContext.Add("Filter:endDate", endDate); dicContext.Add("Filter:Mode", Mode); dicContext.Add("Filter:updateActivityCode", updateActivityCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
/// <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 StringBuilder GetInwardExcelDataUserBased(string users_Json, string product_Json, string product_type_name, string division_name) { try { CreateFileName(product_type_name, division_name); string company_code = _objCurrentInfo.GetCompanyCode(); string[] hiddenColumns = new string[] { }; string[] editableColumnNames = new string[] { }; string[] hiddenColumnNames = new string[] { }; _objExcelConverter = new ExcelFactory(); BLMaster objBlMaster = new BLMaster(); DataSet dsInwardExcelData = new DataSet(); dsInwardExcelData = objBlMaster.GetInwardExcelDataUserBased(company_code, users_Json, product_Json); if (dsInwardExcelData.Tables != null && dsInwardExcelData.Tables[0].Rows != null && dsInwardExcelData.Tables[0].Rows.Count > 0) { dsInwardExcelData.Tables[0].Columns.Add("Quantity", typeof(string)); DataRowCollection dr = dsInwardExcelData.Tables[0].Rows; DataColumnCollection dc = dsInwardExcelData.Tables[0].Columns; _objExcelConverter.DataSetToExcel(DOWNLOAD_PATH_KEY_NAME, _fileNameString.ToString(), dsInwardExcelData, hiddenColumnNames, hiddenColumns, false, editableColumnNames); } else { StringBuilder str = new StringBuilder("No Data Found."); return(str); } StringBuilder MasterfilenameStrings = GetInwardLookupValuesExcel(); return(_fileNameString.Append("^").Append(MasterfilenameStrings)); } catch (Exception ex) { return(_fileNameString.Append(ex.Message)); } }
/// <summary> /// Insert User ProductMapping /// </summary> /// <param name="userCodes"></param> /// <param name="productCodes"></param> /// <returns></returns> public string InsertUserProductMapping(string userCodes, string productCodes) { int result = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); string companyCode = _objcurrentInfo.GetCompanyCode(); BLMaster _objMaster = new BLMaster(); StringBuilder strBuild = new StringBuilder(); string currentDate = DateTime.Now.ToString("yyyy-MM-dd"); try { result = _objMaster.InsertUserProduct(companyCode, userCodes, productCodes, currentDate); if (result > 0) { strBuild.Append("User Product Mapped Sucessfully."); } else { strBuild.Append("This User Product Already Mapped"); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("userCodes", userCodes); dicContext.Add("productCodes", productCodes); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(null); } return(strBuild.ToString()); }
/// <summary> /// Insert , Update , Change Status for Status Cycle Mapping /// </summary> /// <param name="cycleCode"></param> /// <param name="cycleName"></param> /// <param name="statusCode"></param> /// <param name="statusName"></param> /// <param name="description"></param> /// <param name="statusOwnerType"></param> /// <param name="orderNo"></param> /// <param name="moveOrder"></param> /// <param name="mode"></param> /// <param name="oCycleCode"></param> /// <param name="oStatusCode"></param> /// <param name="recordStatus"></param> /// <returns></returns> public int InsertStatusCycleMapping(string cycleCode, string cycleName, string statusCode, string statusName, string description, string statusOwnerType, int orderNo, string moveOrder, string mode, string oCycleCode, string oStatusCode, int recordStatus) { try { string companyCode = _objcurrentInfo.GetCompanyCode(); string userName = _objcurrentInfo.GetUserName(); string dateTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); BLMaster objBlMaster = new BLMaster(); return(objBlMaster.InsertStatusCycleMapping(companyCode, cycleCode, cycleName, statusCode, statusName, description, statusOwnerType, orderNo, moveOrder, mode, oCycleCode, oStatusCode, recordStatus, userName, dateTime, userName, dateTime)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); dicObj.Add("cycleCode", cycleCode); dicObj.Add("cycleName", cycleName); dicObj.Add("statusCode", statusCode); dicObj.Add("statusName", statusName); dicObj.Add("description", description); dicObj.Add("statusOwnerType", statusOwnerType); dicObj.Add("orderNo", orderNo.ToString()); dicObj.Add("moveOrder", moveOrder); dicObj.Add("mode", mode); dicObj.Add("oCycleCode", oCycleCode); dicObj.Add("oStatusCode", oStatusCode); dicObj.Add("recordStatus", recordStatus.ToString()); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(0); } }
/// <summary> /// Change Status /// </summary> /// <param name="status"></param> /// <param name="activityCode"></param> /// <returns></returns> public bool ChangestatusforActivityMaster(string status, string activityCode) { string companyCode = _objcurrentInfo.GetCompanyCode(); string DocStatus = string.Empty; bool changeResult = false; try { DocStatus = status.ToUpper() == "ENABLED" ? "1" : "0"; //1 is enabled, 0 is disabled BLMaster Master = new BLMaster(); string CompanyCode = _objcurrentInfo.GetCompanyCode(); Master.ChangeStatusForActivityMaster(companyCode, activityCode, DocStatus); changeResult = true; } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", companyCode); dicContext.Add("Filter:status", status); dicContext.Add("Filter:activityCode", activityCode); changeResult = false; } return(changeResult); }
//Bind Region public JsonResult GetRegionList(string regionTypecode) { try { BLMaster objMaster = new BLMaster(); ProductPriceMasterModel objDropRegion = new ProductPriceMasterModel(); objDropRegion.Company_Code = _objcurrentInfo.GetCompanyCode(); objDropRegion.Region_Type_Code = regionTypecode; IEnumerable <ProductPriceMasterModel> lstdropregiontype = objMaster.GetRegion(objDropRegion); var DropRegionList = (from region in lstdropregiontype.AsEnumerable() select new ProductPriceMasterModel() { Region_Name = region.Region_Name.ToString(), Region_Code = region.Region_Code.ToString() }).ToList <ProductPriceMasterModel>(); return(Json(DropRegionList)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
//Bind UnderUserType public JsonResult GetUnderUserType() { string companyCode = _objcurrentInfo.GetCompanyCode(); try { BLMaster Master = new BLMaster(); DataTable dtDivision = null; List <UserTypeMasterModel> Divisionlst = new List <UserTypeMasterModel>(); DataSet ds = Master.Getdivisions(companyCode); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { dtDivision = ds.Tables[0]; } Divisionlst = (from Division in dtDivision.AsEnumerable() select new UserTypeMasterModel { User_Type_Code = Division["User_Type_Code"].ToString(), User_Type_Name = Division["User_Type_Name"].ToString() }).ToList <UserTypeMasterModel>(); return(Json(Divisionlst)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(null); } }
/// <summary> /// Used to get the drop Domain List /// </summary> /// <returns></returns> public JsonResult GetDomain() { try { BLMaster objMaster = new BLMaster(); ProjectMasterModel objprojectdomain = new ProjectMasterModel(); objprojectdomain.Company_Code = _objcurrentInfo.GetCompanyCode(); IEnumerable <ProjectMasterModel> lstprojectdomain = objMaster.GetDomain(objprojectdomain); var DivisionList = (from division in lstprojectdomain.AsEnumerable() select new ProjectMasterModel() { Domain_Name = division.Domain_Name, Domain_Code = division.Domain_Code }).ToList <ProjectMasterModel>(); return(Json(DivisionList)); } catch (Exception ex) { Dictionary <string, string> dicObj = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj); return(null); } }
public string checkWAUser() { StringBuilder strContent = new StringBuilder(); int chkCount = 0; try { BLMaster objMaster = new BLMaster(); string companyCode = _objcurrentInfo.GetCompanyCode(); string userCode = _objcurrentInfo.GetUserCode(); string userName = _objcurrentInfo.GetUserName(); chkCount = objMaster.checkWAUser(companyCode, userCode); if (chkCount == 0) { strContent.Append(userName + " Can't make a request,Since you are not a valid Wide Angle user,you are not allowed to make this request"); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(null); } string result = strContent.ToString(); if (string.IsNullOrEmpty(result)) { result = "SUCCESS"; } return(result); }
//Method is Used to bind the Data with RequestMaste Html Table public string GetRequestMaster() { string companycode = _objcurrentInfo.GetCompanyCode(); try { List <RequestMasterModel> lstRequestmastermodel = (List <RequestMasterModel>)GetRequestMasterDetails(); StringBuilder sb = new StringBuilder(); BLMaster objMaster = new BLMaster(); sb.Append("<table WIDTH='70%' id='tblsummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Edit</td>"); sb.Append("<td>Change Status</td>"); sb.Append("<td>Request Name</td>"); sb.Append("<td>Request Entity</td>"); sb.Append("<td>Request Type</td>"); sb.Append("<td>Credit Limit</td>"); sb.Append("<td>Cycle</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (lstRequestmastermodel != null && lstRequestmastermodel.Count > 0) { int i = 0; foreach (var lstRequest in lstRequestmastermodel) { i++; sb.Append("<tr><td><a href='#' id='E" + i + "' onclick='fnEditRequestMaster(this)'>Edit</a></td>"); sb.Append("<td><a href='#' id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>"); sb.Append("<td style='display:none' id='Request_Code" + i + "'>" + lstRequest.Request_Code + "</td>"); sb.Append("<td id='Request_Name" + i + "'>" + lstRequest.Request_Name + "</td>"); sb.Append("<td id='Request_Entity" + i + "'>" + lstRequest.Request_Entity + "</td>"); sb.Append("<td id='Request_Type" + i + "'>" + lstRequest.Request_Type + "</td>"); sb.Append("<td id='Credit_Limit" + i + "'>" + lstRequest.Credit_Limit + "</td>"); sb.Append("<td style='display:none' id='Cycle_Code" + i + "'>" + lstRequest.Cycle_Code + "</td>"); sb.Append("<td id='Cycle_Name" + i + "'>" + lstRequest.Cycle_Name + "</td>"); sb.Append("<td id='Record_Status" + i + "'>" + lstRequest.Record_Status + "</td></tr>"); } } else { sb.Append("<span>No Records TO Display</span>"); } sb.Append("</body>"); sb.Append("</table>"); return(sb.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:CompanyCode", companycode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
public JsonResult InsertAdjustment(List <InwardAdj> lstInwardAdj) { string response = string.Empty; BLMaster _objBLMaster = new BLMaster(); response = _objBLMaster.InsertAdjustment(lstInwardAdj); return(Json(response, JsonRequestBehavior.AllowGet)); }
/// <summary> /// InsertandUpdate /// </summary> /// <param name="regionTypecode"></param> /// <param name="regionCode"></param> /// <param name="productCode"></param> /// <param name="price"></param> /// <param name="effectiveFrom"></param> /// <param name="effectiveTo"></param> /// <param name="Mode"></param> /// <param name="priceCodeval"></param> /// <returns></returns> public int InsertandUpdateProductprice(string regionTypecode, string regionCode, string productCode, string price, string effectiveFrom, string effectiveTo, string Mode, string priceCodeval) { string result1 = string.Empty; BLMaster Master = new BLMaster(); ProductPriceMasterModel objproductPricemasterModer = new ProductPriceMasterModel(); List <ProductPriceMasterModel> lstproductprice = new List <ProductPriceMasterModel>(); try { if (Mode.ToUpper() == "I") // Insert Data { objproductPricemasterModer.Company_Code = _objcurrentInfo.GetCompanyCode(); objproductPricemasterModer.Region_Type_Code = regionTypecode; objproductPricemasterModer.Region_Code = regionCode; objproductPricemasterModer.Product_Code = productCode; objproductPricemasterModer.Price_Status = "1"; objproductPricemasterModer.Price = price; objproductPricemasterModer.Effective_From = effectiveFrom; objproductPricemasterModer.Effective_To = effectiveTo; objproductPricemasterModer.Created_By = _objcurrentInfo.GetUserName(); objproductPricemasterModer.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstproductprice.Add(objproductPricemasterModer); int result = Master.InsertforProductPriceMaster(lstproductprice); return(result); } else { objproductPricemasterModer.Company_Code = _objcurrentInfo.GetCompanyCode(); objproductPricemasterModer.Region_Type_Code = regionTypecode; objproductPricemasterModer.Region_Code = regionCode; objproductPricemasterModer.Product_Code = productCode; objproductPricemasterModer.Price_Code = priceCodeval; objproductPricemasterModer.Price = price; objproductPricemasterModer.Effective_From = effectiveFrom; objproductPricemasterModer.Effective_To = effectiveTo; objproductPricemasterModer.Updated_By = _objcurrentInfo.GetUserName(); objproductPricemasterModer.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstproductprice.Add(objproductPricemasterModer); int result = Master.UpdateforProductpriceMaster(lstproductprice); return(result); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:regionTypecode", regionTypecode); dicContext.Add("Filter:regionCode", regionCode); dicContext.Add("Filter:productCode", productCode); dicContext.Add("Filter:Mode", Mode); dicContext.Add("Filter:price", price); dicContext.Add("Filter:effectiveFrom", effectiveFrom); dicContext.Add("Filter:effectiveTo", effectiveTo); dicContext.Add("Filter:priceCodeval", priceCodeval); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
/// <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); } }
/// <summary> /// Method to bind the data with HtmlCycleMaster Table /// </summary> /// <returns></returns> public string GetCycleMaster() { string companyCode = _objcurrentInfo.GetCompanyCode(); string regionCode = _objcurrentInfo.GetRegionCode(); string strRegionCode = string.Empty; try { List <CycleMasterModel> lstCycleMaster = (List <CycleMasterModel>)GetcycleMasterDetails(regionCode); StringBuilder sb = new StringBuilder(); BLMaster objMaster = new BLMaster(); sb.Append("<table WIDTH='60%' id='tblsummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Edit</td>"); sb.Append("<td>Cycle Name</td>"); sb.Append("<td>Region Name</td>"); sb.Append("<td>Description</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (lstCycleMaster != null && lstCycleMaster.Count > 0) { int i = 0; foreach (var lstcycle in lstCycleMaster) { i++; sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>"); sb.Append("<td style='display:none' id='Cycle_Code" + i + "'>" + lstcycle.Cycle_Code + "</td>"); sb.Append("<td id='Cycle_Name" + i + "'>" + lstcycle.Cycle_Name + "</td>"); sb.Append("<td style='display:none' id='Region_Code" + i + "'>" + lstcycle.Region_Code + "</td>"); sb.Append("<td id='Region_Name" + i + "'>" + lstcycle.Region_Name + "</td>"); sb.Append("<td style='display:none' id='Start_Date" + i + "'>" + lstcycle.Start_Date + "</td>"); sb.Append("<td style='display:none' id='End_Date" + i + "'>" + lstcycle.End_Date + "</td>"); sb.Append("<td id='Long_Description" + i + "'>" + lstcycle.Long_Description + "</td>"); sb.Append("<td id='Record_Status" + i + "'>" + lstcycle.Record_Status + "</td></tr>"); } } else { sb.Append("<span>No Records TO Display</span>"); } sb.Append("</body>"); sb.Append("</table>"); return(sb.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:regionCode", regionCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
public string UpdateProfileDetails(MVCModels.HiDoctor_Master.popupEmployeeModel objEmpdata) { string companyCode = _objcurrentInfo.GetCompanyCode(); string userCode = _objcurrentInfo.GetUserCode(); BLMaster _objBlMaster = new BLMaster(); return(_objBlMaster.UpdateProfileDetails(companyCode, userCode, objEmpdata.Mail, objEmpdata.Mobile, objEmpdata.Phn, objEmpdata.Add1, objEmpdata.Add2, objEmpdata.Add3, objEmpdata.City, objEmpdata.State, objEmpdata.Pincode, objEmpdata.Bloodgroup, objEmpdata.Employeephoto)); }
/// <summary> /// Method to bind the data with HtmDoctorcategoryMaster Table /// </summary> /// <returns></returns> public string GetDoctorCatgegory() { string companycode = _objcurrentInfo.GetCompanyCode(); try { BLMaster _objmaster = new BLMaster(); List <MVCModels.HiDoctor_Master.DoctorModel> lstdoctcategory = (List <MVCModels.HiDoctor_Master.DoctorModel>)GetdoctorcategoryDetails(); //dsc StringBuilder sb = new StringBuilder(); sb.Append("<table WIDTH='100%' id='tblsummary' class='table table-striped' >"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Edit</td>"); sb.Append("<td>Change Status</td>"); sb.Append("<td>Doctor Category Name</td>"); sb.Append("<td>Visit Count</td>"); sb.Append("<td>Doctor Count</td>"); sb.Append("<td>Division Name</td>"); sb.Append("<td>Effective From</td>"); sb.Append("<td>Effective To</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); // if (lstdoctcategory != null && lstdoctcategory.Count > 0) { int i = 0; foreach (var lstdoc in lstdoctcategory) { i++; sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>"); sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>"); sb.Append("<td style='display:none' id='Category_Code" + i + "'>" + lstdoc.Category_Code + "</td>"); sb.Append("<td id='Category_Name" + i + "'>" + lstdoc.Category_Name + "</td>"); sb.Append("<td id='Visit_Count" + i + "'>" + lstdoc.Visit_Count + "</td>"); sb.Append("<td id='Doctor_Count" + i + "'>" + lstdoc.Doctor_Count + "</td>"); sb.Append("<td style='display:none' id='Division_Code" + i + "'>" + lstdoc.Division_Code + "</td>"); sb.Append("<td id='Division_Name" + i + "'>" + lstdoc.Division_Name + "</td>"); sb.Append("<td id='Effective_From" + i + "'>" + lstdoc.Effective_From + "</td>"); sb.Append("<td id='Effective_To" + i + "'>" + lstdoc.Effective_To + "</td>"); sb.Append("<td id='Status" + i + "'>" + lstdoc.Status + "</td></tr>"); } } sb.Append("</tbody>"); sb.Append("</table>"); return(sb.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
public string GetPrivilegeValue(string userCode, string privilegeName) { string pri = ""; BLMaster obj = new BLMaster(); string companyCode = _objCurrentInfo.GetCompanyCode(); pri = obj.GetPrivilegeValue(companyCode, userCode, privilegeName); return(pri); }
/// <summary> /// Insert and Update /// </summary> /// <param name="featureName"></param> /// <param name="effectiveFrom"></param> /// <param name="featureCodeval"></param> /// <param name="description"></param> /// <param name="Mode"></param> /// <returns></returns> public int InsertandUpdateFeatureMaster(string featureName, string effectiveFrom, string featureCodeval, string description, string Mode) { BLMaster Master = new BLMaster(); FeatureMasterModel objfeaturemasterModel = new FeatureMasterModel(); List <FeatureMasterModel> lstfeaturemaster = new List <FeatureMasterModel>(); try { if (Mode.ToUpper() == "I") // Insert Data { if (string.IsNullOrEmpty(description)) { description = ""; } objfeaturemasterModel.Company_Code = _objcurrentInfo.GetCompanyCode(); objfeaturemasterModel.Feature_Name = featureName; objfeaturemasterModel.Effective_From = effectiveFrom; objfeaturemasterModel.Description = description; objfeaturemasterModel.Record_Status = "1"; objfeaturemasterModel.Is_Active = "1"; objfeaturemasterModel.Created_By = _objcurrentInfo.GetUserName(); objfeaturemasterModel.Created_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstfeaturemaster.Add(objfeaturemasterModel); int result = Master.InsertforFeatureMaster(lstfeaturemaster); return(result); } else { if (string.IsNullOrEmpty(description)) { description = ""; } objfeaturemasterModel.Company_Code = _objcurrentInfo.GetCompanyCode(); objfeaturemasterModel.Feature_Code = featureCodeval; objfeaturemasterModel.Feature_Name = featureName; objfeaturemasterModel.Effective_From = effectiveFrom; objfeaturemasterModel.Description = description; objfeaturemasterModel.Updated_By = _objcurrentInfo.GetUserName(); objfeaturemasterModel.Updated_Date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); lstfeaturemaster.Add(objfeaturemasterModel); int result = Master.UpdateforFeatureMaster(lstfeaturemaster); return(result); } } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:featureName", featureName); dicContext.Add("Filter:effectiveFrom", effectiveFrom); dicContext.Add("Filter:featureCodeval", featureCodeval); dicContext.Add("Filter:Mode", Mode); dicContext.Add("Filter:description", description); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(0); } }
public string GetInvalidFiles(string docUploadId) { StringBuilder strTbl = new StringBuilder(); _objBlMaster = new BLMaster(); List <MVCModels.InvalidFiles> lstInvalidFiles = new List <InvalidFiles>(); int s = 0; try { lstInvalidFiles = _objBlMaster.GetInvalidFiles(_objcurrentInfo.GetCompanyCode(), docUploadId).ToList(); strTbl.Append("<table WIDTH='100%' id='tblMydoc' class='table table-striped'>"); strTbl.Append("<thead class='active'>"); strTbl.Append("<tr style='background-color:#428bca;'>"); strTbl.Append("<th>S.No</th><th>Invalid File Name</th><th>Reason</th>"); strTbl.Append("</tr>"); strTbl.Append("</thead>"); strTbl.Append("<tbody>"); if (lstInvalidFiles != null && lstInvalidFiles.Count > 0) { foreach (var fileName in lstInvalidFiles) { s++; strTbl.Append("<tr>"); //S.No strTbl.Append("<td>"); strTbl.Append(s); strTbl.Append("</td>"); //Invalid File Name strTbl.Append("<td>"); strTbl.Append(fileName.Doc_file_Name); strTbl.Append("</td>"); //Reason strTbl.Append("<td>"); strTbl.Append(fileName.ERR_REASON); strTbl.Append("</td>"); strTbl.Append("</tr>"); } } else { strTbl.Append("No Details Found."); } strTbl.Append("</tbody>"); strTbl.Append("</table>"); return(strTbl.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("docUploadId", docUploadId); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
public JsonResult GetRequestCategoryNames() { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); BLMaster _objMaster = new BLMaster(); List <DCRRestrictionModel> lstrequestCategoryNames = new List <DCRRestrictionModel>(); lstrequestCategoryNames = _objMaster.GetRequestCategoryName(_objcurrentInfo.GetCompanyCode()).ToList(); DataControl.JSONConverter objJson = new DataControl.JSONConverter(); return(Json(objJson.Serialize(lstrequestCategoryNames))); }
public JsonResult GetUserType() { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); BLMaster _objMaster = new BLMaster(); List <DivisionUserProducts> lstUserType = new List <DivisionUserProducts>(); lstUserType = _objMaster.GetUserTypeNamesforProductMapping(_objcurrentInfo.GetCompanyCode()).ToList(); DataControl.JSONConverter objJson = new DataControl.JSONConverter(); return(Json(objJson.Serialize(lstUserType))); }
/// <summary> /// Bind the ExpenseEntityMaster with Html table /// </summary> /// <returns></returns> public string GetExpenseEntityMaster() { string companyCode = _objcurrentInfo.GetCompanyCode(); try { BLMaster Master = new BLMaster(); DataSet dsExpenseEntityMaster = new DataSet(); dsExpenseEntityMaster = Master.GetExpenseEntityMaster(companyCode); StringBuilder sb = new StringBuilder(); sb.Append("<table WIDTH='75%' id='tblsummary' class='table table-striped' >"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:grey;'>"); sb.Append("<td>Edit</td>"); sb.Append("<td>Change Status</td>"); sb.Append("<td>Entity Name</td>"); sb.Append("<td>Effective From</td>"); sb.Append("<td>Effective To</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (dsExpenseEntityMaster != null && dsExpenseEntityMaster.Tables[0] != null && dsExpenseEntityMaster.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsExpenseEntityMaster.Tables[0].Rows.Count; i++) { sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>"); sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>"); sb.Append("<td style='display:none' id='Expense_Entity_Code" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Code"].ToString() + "</td>"); sb.Append("<td id='Expense_Entity_Name" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Expense_Entity_Name"].ToString() + "</td>"); sb.Append("<td id='Effective_From" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_From"].ToString() + "</td>"); sb.Append("<td id='Effective_To" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Effective_To"].ToString() + "</td>"); sb.Append("<td id='Row_Status" + i + "'>" + dsExpenseEntityMaster.Tables[0].Rows[i]["Row_Status"].ToString() + "</td></tr>"); } } else { sb.Append("<tr><td>No records To Display</td></tr>"); } sb.Append("</body>"); sb.Append("</table>"); return(sb.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", companyCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }
public JsonResult GetSFCExtendedDetails(string region_code, DateTime dcr_Date, int distance_Fare_Code) { BLMaster objMaster = new BLMaster(); _objCurrentInfo = new CurrentInfo(); string company_Code = _objCurrentInfo.GetCompanyCode(); List <SFCRegionModel> lsSFCRegion = objMaster.GetSFCExtendedDetails(region_code, dcr_Date, distance_Fare_Code, company_Code); return(Json(lsSFCRegion)); }
public JsonResult GetRegionSFC(string region_code, DateTime dcr_Date) { BLMaster objMaster = new BLMaster(); _objCurrentInfo = new CurrentInfo(); string company_Code = _objCurrentInfo.GetCompanyCode(); List <SFCRegionModel> lsSFCRegion = objMaster.GetRegionSFC(region_code, dcr_Date, company_Code); return(Json(lsSFCRegion)); }
/// <summary> /// Method is used to bind the data with Html Table /// </summary> /// <returns></returns> public string GetFeatureMaster() { string companycode = _objcurrentInfo.GetCompanyCode(); try { List <FeatureMasterModel> lstfeaturemaster = (List <FeatureMasterModel>)GetFeatureMasterDetails(); StringBuilder sb = new StringBuilder(); BLMaster objMaster = new BLMaster(); sb.Append("<table WIDTH='60%' id='tblsummary' class='table table-striped'>"); sb.Append("<thead class='active'>"); sb.Append("<tr style='background-color:#428bca;'>"); sb.Append("<td>Select</td>"); sb.Append("<td>Change Status</td>"); sb.Append("<td>Feature Type</td>"); sb.Append("<td>Description</td>"); sb.Append("<td>Effective From</td>"); sb.Append("<td>Status</td>"); sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); if (lstfeaturemaster != null && lstfeaturemaster.Count > 0) { int i = 0; foreach (var lstfeature in lstfeaturemaster) { i++; sb.Append("<tr><td class='td-a'><a id='E" + i + "' onclick='fnEdit(this)'>Edit</a></td>"); sb.Append("<td class='td-a'><a id='C" + i + "' onclick='fnchangeStatus(this)'>Change Status</a></td>"); sb.Append("<td style='display:none' id='Feature_Code" + i + "'>" + lstfeature.Feature_Code + "</td>"); sb.Append("<td id='Feature_Name" + i + "'>" + lstfeature.Feature_Name + "</td>"); sb.Append("<td id='Description" + i + "'>" + lstfeature.Description + "</td>"); sb.Append("<td id='Effective_From" + i + "'>" + lstfeature.Effective_From + "</td>"); sb.Append("<td id='Record_Status" + i + "'>" + lstfeature.Record_Status + "</td></tr>"); } } else { sb.Append("<span>No Records TO Display</span>"); } sb.Append("</body>"); sb.Append("</table>"); return(sb.ToString()); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:CompanyCode", companycode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return(ex.Message.ToString()); } }