public void LoadData(DataGridView dtGridView) { IList <CRMGroup> CRMGroup = _CRMGroupInfo.GetAll(); _dtCRMGroup = ListtoDataTable.ToDataTable(CRMGroup.ToList()); loadDataOnGrid(dtGridView, _dtCRMGroup); }
private void AuditTrail_Load(object sender, EventArgs e) { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(AUDITLOGCONTROLLER_BY_USER, Program.CurrentUser.UserName); HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String auditTrailJson = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); auditTrailJson = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var auditTrailCollection = jsonSerialization.DeserializeFromString <Result <List <Activities> > >(auditTrailJson); if (auditTrailCollection.Value != null) { _dtAuditTrail = ListtoDataTable.ToDataTable(auditTrailCollection.Value); dtGridAuditTrail.DataSource = _dtAuditTrail; gridDisplaySetting(); } }
private void getConversationDetails() { if (_dtConversation != null && _dtConversation.Rows.Count > 0) { _dtConversation.Clear(); } FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(CONVERSATIONBY_ID, _prospectClient.ID); HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String prospClientResultJosn = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); prospClientResultJosn = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var prospClientConversationCollection = jsonSerialization.DeserializeFromString <Result <List <ProspectClientConversation> > >(prospClientResultJosn); if (prospClientConversationCollection.Value != null) { _prospectClient.ProspectClientConversationList = prospClientConversationCollection.Value; _dtConversation = ListtoDataTable.ToDataTable(prospClientConversationCollection.Value); dataGridConversation.DataSource = _dtConversation; gridDisplaySetting(); } }
private void frmUseList_Load(object sender, EventArgs e) { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + USERAPI; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String userResultJson = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); userResultJson = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var userCollection = jsonSerialization.DeserializeFromString <Result <List <User> > >(userResultJson); if (userCollection.Value != null) { _dtUser = ListtoDataTable.ToDataTable(userCollection.Value); dtGridUser.DataSource = _dtUser; gridDisplaySetting(); } }
private void loadPlanData() { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GET_PLAN_BY_CLIENTID_API, ClientId); HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String planerResultJson = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); planerResultJson = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var plannerCollection = jsonSerialization.DeserializeFromString <Result <List <Planner> > >(planerResultJson); if (plannerCollection.Value != null) { _dtPlanner = ListtoDataTable.ToDataTable(plannerCollection.Value); } }
public void LoadData(DataGridView dtGridView) { IList <Festivals> festivals = _festivalsInfo.GetAll(); _dtFestivals = ListtoDataTable.ToDataTable(festivals.ToList()); loadDataOnGrid(dtGridView, _dtFestivals); }
private void loadApplicationConfig() { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + GET_APPLICATIONCONFIG_API; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String appConfigJsobResult = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); appConfigJsobResult = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var appConfigCollection = jsonSerialization.DeserializeFromString <Result <List <ApplicationConfiguration> > >(appConfigJsobResult); if (appConfigCollection.Value != null) { _dtAppConfig = ListtoDataTable.ToDataTable(appConfigCollection.Value); } } catch (Exception ex) { MessageBox.Show(string.Format("Fail to load application data. Error:{0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void loadArticleFormWithData() { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + GET_EMAILARTICLES_API; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String emailArticleResultJson = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); emailArticleResultJson = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var emailArticleCollection = jsonSerialization.DeserializeFromString <Result <List <EmailArticle> > >(emailArticleResultJson); if (emailArticleCollection.Value != null) { _dtArticle = ListtoDataTable.ToDataTable(emailArticleCollection.Value); } } catch (Exception ex) { MessageBox.Show(string.Format("Fail to load application data. Error:{0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GetQuoteById() { Business.Sales.Quote Obj = new Business.Sales.Quote(); Entity.Sales.Quote Quote = Obj.GetQuoteById(QuoteId); if (Quote.Id != 0) { txtActualCloseDate.Text = Quote.ActualCloseDate == null ? string.Empty : Quote.ActualCloseDate.GetValueOrDefault().ToString("dd MMM yyyy"); txtDateShipped.Text = Quote.DateShipped == null ? string.Empty : Quote.DateShipped.GetValueOrDefault().ToString("dd MMM yyyy"); txtValidTillDate.Text = Quote.ValidTillDate == null ? string.Empty : Quote.ValidTillDate.GetValueOrDefault().ToString("dd MMM yyyy"); txtOriginalPODate.Text = Quote.OriginalPODate == null ? string.Empty : Quote.OriginalPODate.GetValueOrDefault().ToString("dd MMM yyyy"); txtQuoteNumber.Text = Quote.QuoteNumber; txtPurchaseOrderNo.Text = Quote.PurchaseOrderNo; txtShippingProvider.Text = Quote.ShippingProvider; txtCurrencyCode.Text = Quote.CurrencyCode; txtCurrencyName.Text = Quote.CurrencyName; txtTaxRate.Text = Quote.TaxRate == null ? string.Empty : Quote.TaxRate.ToString(); ddlOpportunity.SelectedValue = Quote.OpportunityId == null ? "0" : Quote.OpportunityId.ToString(); ddlPaymentTerm.SelectedValue = Quote.PaymentTermId == null ? "0" : Quote.PaymentTermId.ToString(); ddlQuoteStage.SelectedValue = Quote.QuoteStageId == null ? "0" : Quote.QuoteStageId.ToString(); JavaScriptSerializer ser = new JavaScriptSerializer(); List <Entity.Sales.QuoteLineItem> lst = ser.Deserialize <List <Entity.Sales.QuoteLineItem> >(Quote.QuoteLineItem); ListtoDataTable lsttodt = new ListtoDataTable(); _ItemsList = lsttodt.ToDataTable(lst); LoadItemList(); } }
public void LoadData(DataGridView dtGridView) { IList <Area> Area = _AreaInfo.GetAll(); _dtArea = ListtoDataTable.ToDataTable(Area.ToList()); loadDataOnGrid(dtGridView, _dtArea); }
public DataTable GetAll(int planId) { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GETALL_API, planId); HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String planerResultJson = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); planerResultJson = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var plannerCollection = jsonSerialization.DeserializeFromString <Result <List <PlanOption> > >(planerResultJson); if (plannerCollection.Value != null) { return(ListtoDataTable.ToDataTable(plannerCollection.Value)); } return(null); }
private void loadEmailSchedulerData() { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + GET_EMAILSCHEDULER_API; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); request.Method = "GET"; String emailSchedulerResultJosn = String.Empty; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); emailSchedulerResultJosn = reader.ReadToEnd(); reader.Close(); dataStream.Close(); } var emailSchedulerCollection = jsonSerialization.DeserializeFromString <Result <List <EmailScheduler> > >(emailSchedulerResultJosn); if (emailSchedulerCollection.Value != null) { _dtEmailScheduler = ListtoDataTable.ToDataTable(emailSchedulerCollection.Value); dataGridEmailScheduler.DataSource = _dtEmailScheduler; gridDisplaySetting(); } }
private void fillCurrentStatusToGoalData() { cmbCurrentStsatusToGoal.Items.Clear(); foreach (var goal in _goals) { cmbCurrentStsatusToGoal.Items.Add(goal.Name); } _currentStatusToGoal = new CurrentStatusInfo().GetCurrentStatusToGoal(int.Parse(cmbPlanOption.Tag.ToString())); if (_currentStatusToGoal != null) { _dtCurrentStatustoGoals = ListtoDataTable.ToDataTable(_currentStatusToGoal.ToList()); dtGridCurrentStatusToGoal.DataSource = _dtCurrentStatustoGoals; dtGridCurrentStatusToGoal.Columns[0].Visible = false; dtGridCurrentStatusToGoal.Columns[1].Visible = false; dtGridCurrentStatusToGoal.Columns[2].Visible = false; dtGridCurrentStatusToGoal.Columns[3].Visible = false; dtGridCurrentStatusToGoal.Columns[6].Visible = false; dtGridCurrentStatusToGoal.Columns[7].Visible = false; dtGridCurrentStatusToGoal.Columns[8].Visible = false; dtGridCurrentStatusToGoal.Columns[9].Visible = false; dtGridCurrentStatusToGoal.Columns[10].Visible = false; dtGridCurrentStatusToGoal.Columns[11].Visible = false; dtGridCurrentStatusToGoal.Columns[5].DisplayIndex = 0; dtGridCurrentStatusToGoal.Columns[5].HeaderText = "Goal"; dtGridCurrentStatusToGoal.Columns[4].DisplayIndex = 1; dtGridCurrentStatusToGoal.Columns[4].HeaderText = "Fund Allocation"; } }
public void CrearLista <T>(List <T> ListaDatos) { if (ListaDatos != null) { ListtoDataTable lsttodt = new ListtoDataTable(); GetData = lsttodt.ToDataTable(ListaDatos); var bindingList = new BindingList <T>(ListaDatos); var source = new BindingSource(bindingList, null); DGVlistaDatos.DataSource = source; DGVlistaDatos.Refresh(); DGVlistaDatos.Update(); } }
public ActionResult UpdateRfId() { try { int LoginID = GetLogin(); if (Request.Files.Count > 0 && LoginID > 0) { int FileID = 0; int RowCount = 0; string path = Server.MapPath(ConfigurationManager.AppSettings["INVUpload"].ToString()); CommonFunction com = new CommonFunction(); //Guid guFileName = Guid.NewGuid(); string FileName = Request.Files[0].FileName.ToString(); string FilePath = Server.MapPath(ConfigurationManager.AppSettings["INVUpload"]); string FileExtension = Path.GetExtension(Request.Files[0].FileName); string ip = CommonFunction.GetIpAddress(Request); FileID = this.objSDC.InsertFileUploadLog(FileName + FileExtension, "RFID_" + FileName + FileExtension, LoginID.ToString(), ip, "12", "RFID_UPDATE"); Request.Files[0].SaveAs(FilePath + FileID.ToString() + FileExtension); DataTable dt = com.GetDataFromExcel2(FilePath + FileID + FileExtension, true); if (dt == null) { throw new Exception("DataTable is null"); } DataTable pDt = ParseToString(dt); if (dt.Rows.Count > 0) { List <RFIDTempTableMiewModel> lstofRfid = this.objSvc.InventoryUploadRFID(pDt, LoginID, ip, FileID); List <RFIDTempTableMiewModel> objValidLst = lstofRfid.Where(x => (x.Status != null && x.Status.ToLower() == "valid")).ToList(); List <RFIDTempTableMiewModel> objInValidLst = lstofRfid.Where(x => (x.Status != null && x.Status.ToLower().Contains("invalid"))).ToList(); DataTable dtValid = ListtoDataTable.ToDataTable <RFIDTempTableMiewModel>(objValidLst); DataTable dtNotValid = ListtoDataTable.ToDataTable <RFIDTempTableMiewModel>(objInValidLst); ExportToExcel.SaveExcel(path, FileID.ToString() + "_Valid", "Valid", dtValid); ExportToExcel.SaveExcel(path, FileID.ToString() + "_InValid", "InValid", dtNotValid); } return(Json(new Response { IsSuccess = true, Result = new { FileID = FileID, RowCount = RowCount } })); } return(Json(new Response { IsSuccess = false, Message = "File not uploaded" })); } catch (Exception ex) { ErrorLog.Log("RFIDController", "UpdateRfId", ex); return(Json(new Response { IsSuccess = false, Message = ex.Message })); } }
private void loadProspectCustomerData() { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + PROSPECT_CLIENTS_GETALL; RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <List <ProspectClient> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { var prospClientCollection = jsonSerialization.DeserializeFromString <List <ProspectClient> >(restResult.ToString()); _dtProspClients = ListtoDataTable.ToDataTable(prospClientCollection); fillTreeviewData(_dtProspClients); } else { MessageBox.Show(restResult.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { Logger.LogDebug(ex); } //HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(apiurl); //request.Method = "GET"; //String prospClientResultJosn = String.Empty; //using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) //{ // Stream dataStream = response.GetResponseStream(); // StreamReader reader = new StreamReader(dataStream); // prospClientResultJosn = reader.ReadToEnd(); // reader.Close(); // dataStream.Close(); //} //var prospClientCollection = jsonSerialization.DeserializeFromString<Result<List<ProspectClient>>>(prospClientResultJosn); //if (prospClientCollection.Value != null) //{ // _dtProspClients = ListtoDataTable.ToDataTable(prospClientCollection.Value); // //dataGridProspClients.DataSource = _dtProspClients; // fillTreeviewData(_dtProspClients); // //gridDisplaySetting(); //} }
public ActionResult PartialCancel(int OrderID, string LotNos, int FileNo = 0) { try { int LoginID = GetLogin(); if (LoginID > 0) { OrderInfoViewModel objInfo = this.objMemoService.MemoInfo(OrderID); MemoDetail obj = this.objMemoService.CancelPartialMemo(OrderID, LotNos, LoginID); if (FileNo != 0) { fileUploadLogModel objFile = this.objMemoService.GetFileByID(FileNo); if (objFile != null) { String path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["INVUpload"]); DataTable dtValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "Valid").ToList()); DataTable dtNotValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "InValid").ToList()); ExportToExcel.SaveExcel(path, FileNo.ToString() + "_Valid", "Valid", dtValid); ExportToExcel.SaveExcel(path, FileNo.ToString() + "_InValid", "InValid", dtNotValid); objFile.validInv = obj.Inv.Where(x => x.LotStatus == "Valid").Count(); objFile.invalidInv = obj.Inv.Where(x => x.LotStatus == "InValid").Count(); this.objMemoService.UpdateFile(objFile); if (obj.Counts.OrderId > 0) { this.objMemoService.UpdateFile(obj.Counts.OrderId, FileNo); } } } if (objInfo != null && obj.Counts != null && obj.Counts.OrderId > 0) { this.objMemoService.SendMailMemo(obj.Counts.OrderId, GetEmailID(), GetFullName(), objInfo.UserDetail.loginID, "List of inventory Partial Canceled Memo from memo-", "", Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["EmailTemplate_CancelMemo"]), objInfo, LotNos); bool log = this.objUDSvc.UserActivitylogs(LoginID, "Partial canceled memo", LotNos); } return(Json(new Response { Code = 200, IsSuccess = true, Message = "", Result = obj.Counts.validCount })); } return(Json(new Response { IsSuccess = false, Message = string.Format(StringResource.Invalid, "Session") })); } catch (Exception ex) { ErrorLog.Log("MemoController", "PartialCancel", ex); return(Json(new Response { IsSuccess = false, Message = ex.Message })); } }
internal double GetProfileValue() { IList <FinancialPlanner.Common.Model.PlanOptions.CurrentStatusToGoal> currentStatusToGoals = new CurrentStatusInfo().GetCurrentStatusToGoal(_optionId); _dtcurrentStatusToGoal = ListtoDataTable.ToDataTable(currentStatusToGoals.ToList()); DataRow[] dr = _dtcurrentStatusToGoal.Select(string.Format("GoalName = '{0}'", _goal.Name)); if (dr != null && dr.Count() > 0) { return((string.IsNullOrEmpty(dr[0]["FundAllocation"].ToString())) ? 0 : double.Parse(dr[0]["FundAllocation"].ToString())); } return(0); }
public ActionResult Book(string LotNos, int CustomerID, int isConfirmed, int isSellDirect, string Remark, int FileNo = 0) { try { int LoginID = GetLogin(); if (LoginID > 0) { MemoDetail obj = this.objMemoService.CreateMemo(LotNos, LoginID, CustomerID, isConfirmed, isSellDirect, Remark); if (FileNo != 0) { fileUploadLogModel objFile = this.objMemoService.GetFileByID(FileNo); if (objFile != null) { String path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["INVUpload"]); DataTable dtValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "Valid").ToList()); DataTable dtNotValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "InValid").ToList()); ExportToExcel.SaveExcel(path, FileNo.ToString() + "_Valid", "Valid", dtValid); ExportToExcel.SaveExcel(path, FileNo.ToString() + "_InValid", "InValid", dtNotValid); objFile.validInv = obj.Inv.Where(x => x.LotStatus == "Valid").Count(); objFile.invalidInv = obj.Inv.Where(x => x.LotStatus == "InValid").Count(); this.objMemoService.UpdateFile(objFile); if (obj.Counts.OrderId > 0) { this.objMemoService.UpdateFile(obj.Counts.OrderId, FileNo); } } } if (obj != null && obj.Counts.OrderId != 0) { this.objMemoService.SendMailMemo(obj.Counts.OrderId, GetEmailID(), GetFullName(), CustomerID, "List of inventory put on memo to", "", Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["EmailTemplate_PutOnMemo"])); bool log = this.objUDSvc.UserActivitylogs(LoginID, "Put on memo", LotNos); } return(Json(new Response { Code = 200, IsSuccess = true, Message = "", Result = obj.Counts })); } return(Json(new Response { IsSuccess = false, Message = string.Format(StringResource.Invalid, "Session") })); } catch (Exception ex) { ErrorLog.Log("MemoController", "Book", ex); return(Json(new Response { IsSuccess = false, Message = ex.Message })); } }
internal DataTable GetMFTransactionsInfo(int plannerId) { IList <MFTransactions> MFTransactionsObj = new List <MFTransactions>(); try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GET_ALL, plannerId); RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <IList <MFTransactions> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { MFTransactionsObj = jsonSerialization.DeserializeFromString <IList <MFTransactions> >(restResult.ToString()); } if (MFTransactionsObj != null) { if (MFTransactionsObj.Count > 0) { dtMFTrans = ListtoDataTable.ToDataTable(MFTransactionsObj.ToList()); } else { return(defaultTableStructure()); } } return(dtMFTrans); } catch (System.Net.WebException webException) { if (webException.Message.Equals("The remote server returned an error: (401) Unauthorized.")) { MessageBox.Show("You session has been expired. Please Login again.", "Session Expired", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return(null); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
public void FillInvestmentBifurcationData(int riskProfileId, string investmentType, DataGridView dataGrid) { if (_dtInvestmentSegment != null) { _dtInvestmentSegment.Clear(); } IList <InvestmentSegment> InvestmentSegmentObj = new List <InvestmentSegment>(); try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GET_ALL, riskProfileId); RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <IList <InvestmentSegment> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { InvestmentSegmentObj = jsonSerialization.DeserializeFromString <IList <InvestmentSegment> >(restResult.ToString()); } if (InvestmentSegmentObj != null) { _dtInvestmentSegment = ListtoDataTable.ToDataTable(InvestmentSegmentObj.ToList()); } fillGrid(investmentType, dataGrid); } catch (System.Net.WebException webException) { if (webException.Message.Equals("The remote server returned an error: (401) Unauthorized.")) { MessageBox.Show("You session has been expired. Please Login again.", "Session Expired", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); } }
private void loadRiskProfileData() { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + RISKPROFILE_GETALL; RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <List <RiskProfiledReturnMaster> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { var riskProfileColleection = jsonSerialization.DeserializeFromString <List <RiskProfiledReturnMaster> >(restResult.ToString()); _dtRiskProfile = ListtoDataTable.ToDataTable(riskProfileColleection); fillTreeviewData(_dtRiskProfile); } else { MessageBox.Show(restResult.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void loadCustomerData() { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + CLIENTS_GETALL; RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <List <Client> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { var clientColleection = jsonSerialization.DeserializeFromString <List <Client> >(restResult.ToString()); _dtClient = ListtoDataTable.ToDataTable(clientColleection); fillTreeviewData(_dtClient); } else { MessageBox.Show(restResult.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
internal DataTable GetSchemes(int investmentsegmentId) { DataTable dtSchemes = new DataTable(); IList <RecommendedSchemes> recommendedSchemesObj = new List <RecommendedSchemes>(); try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GET_ALL_RECOMMENDEDSCHEME, investmentsegmentId); RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <IList <RecommendedSchemes> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { recommendedSchemesObj = jsonSerialization.DeserializeFromString <IList <RecommendedSchemes> >(restResult.ToString()); } if (recommendedSchemesObj != null) { dtSchemes = ListtoDataTable.ToDataTable(recommendedSchemesObj.ToList()); } } catch (System.Net.WebException webException) { if (webException.Message.Equals("The remote server returned an error: (401) Unauthorized.")) { MessageBox.Show("You session has been expired. Please Login again.", "Session Expired", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); } return(dtSchemes); }
public DataTable GetRiskProfileReturnById(int id) { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(RISKPROFILERETURN_DETAIL_GETALL, id); RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <List <RiskProfiledReturn> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { var riskProfileColleection = jsonSerialization.DeserializeFromString <List <RiskProfiledReturn> >(restResult.ToString()); _dtRiskProfileReturn.Clear(); _dtRiskProfileReturn = ListtoDataTable.ToDataTable(riskProfileColleection); } else { MessageBox.Show(restResult.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(_dtRiskProfileReturn); }
public async Task <DataResult <DecryptViewModel> > DECRYPTINDENTS(DecryptViewModel model) { var objDecrypt = new DataResult <DecryptViewModel>(); var listOfIndentId = new List <string>(); var listSec = new List <SecurityNumberUpdateVM>(); try { var dModel = new DecryptViewModel(); string outputFile = Path.Combine($"{model.OutputPath}\\DecryptedFile.xls"); var decrypt = PGPDecryptMain.Decrypt(model.EncryptedFilePath, GetConfigValue("PFSPrivateKey"), HashUtil.DecryptStringValue(GetConfigValue("PGPPassword")), outputFile); dModel.OutputPath = outputFile; if (!string.IsNullOrEmpty(dModel.OutputPath)) { var excelToDT = ParseExcelNow(outputFile); var excelToList = ConvertDataTableToList <ExcelFileViewModel>(excelToDT).Select(x => new ExcelFileViewModel { //INDENTID = x.INDENTID.Remove(0,1), INDENTID = x.INDENTID, ACCOUNTNUMBER = x.ACCOUNTNUMBER, ACCOUNTNAME = x.ACCOUNTNAME, //DOMICILEBRANCHNAME = x.DOMICILEBRANCHNAME, DOMICILEBRANCHADDRESS = x.DOMICILEBRANCHADDRESS, SORTCODE = x.SORTCODE, CHEQUETYPE = x.CHEQUETYPE, NOOFLEAVES = x.NOOFLEAVES, DELIVERYBRANCHADDRESS = x.DELIVERYBRANCHADDRESS, SCHEMECODE = x.SCHEMECODE, DOMICILEBRANCHCODE = x.DOMICILEBRANCHCODE, //DELIVERYBRANCHCODE = x.DELIVERYBRANCHCODE, RANGESTART = x.RANGESTART, RANGESTOP = x.RANGESTOP, STARTAUDIT = x.STARTAUDIT }); var accountNo = excelToList.FirstOrDefault().ACCOUNTNUMBER; var parameter = new List <IDbDataParameter>(); parameter.Add(_db.CreateParameter("P_ACCOUNTNO", accountNo, OracleDbType.Varchar2, ParameterDirection.Input)); parameter.Add(_db.CreateParameter("P_BATCHGENERATED", OracleDbType.RefCursor, null)); parameter.Add(_db.CreateParameter("P_ERROR_MSG", 100, string.Empty, DbType.String, ParameterDirection.Output)); var generatedIndentsByAccountNo = _db.GetDataTable(STOREDPROC.GETGENERATEDINDENTSBYACCTNO, CommandType.StoredProcedure, 0, parameter); if (generatedIndentsByAccountNo.Rows.Count == 0) { objDecrypt.Data = null; objDecrypt.Status = true; objDecrypt.Message = "No matching record in database"; } var generatedIndentsByAccountNoToList = ConvertDataTableToList <LocalValidateIndents>(generatedIndentsByAccountNo); foreach (var item in excelToList) { var objIndent = generatedIndentsByAccountNoToList.Where(x => x.ACCOUNTNO == item.ACCOUNTNUMBER && x.INDENT_ID == item.INDENTID).Select(x => new CompareObjectFromDb { INDENTID = x.INDENT_ID, ACCOUNTNUMBER = x.ACCOUNTNO, ACCOUNTNAME = x.ACCOUNTNAME, DOMICILEBRANCHADDRESS = x.DOM_BRANCH_ADD, SORTCODE = x.SORTCODE, CHEQUETYPE = x.CHEAQUETYPE, NOOFLEAVES = x.NUMBER_OF_LEAVES, DELIVERYBRANCHADDRESS = x.DEL_BRANCH_ADD, SCHEMECODE = x.SCHEMECODE, DOMICILEBRANCHCODE = x.DOM_BRANCH_CODE, RANGESTART = x.RANGE_START, RANGESTOP = x.RANGE_STOP, }).FirstOrDefault(); if (objIndent == null) { objDecrypt.Data = null; objDecrypt.Status = false; objDecrypt.Message = "Excel record(s) does not match generated indents"; ErrorWriter.WriteLog($"Decryption process returned : { objDecrypt.Message } at { DateTime.Now }"); return(objDecrypt); } if (item.CHEQUETYPE != objIndent.CHEQUETYPE || item.DELIVERYBRANCHADDRESS != objIndent.DELIVERYBRANCHADDRESS || item.DOMICILEBRANCHADDRESS != objIndent.DOMICILEBRANCHADDRESS || item.DOMICILEBRANCHCODE != objIndent.DOMICILEBRANCHCODE || item.RANGESTART != Convert.ToDouble(objIndent.RANGESTART) || item.RANGESTOP != Convert.ToDouble(objIndent.RANGESTOP) || item.NOOFLEAVES != Convert.ToDouble(objIndent.NOOFLEAVES) || item.SORTCODE != objIndent.SORTCODE) { objDecrypt.Data = null; objDecrypt.Status = false; objDecrypt.Message = "Excel record(s) does not match generated indents"; ErrorWriter.WriteLog($"Decryption process returned : { objDecrypt.Message } at { DateTime.Now }"); return(objDecrypt); } listOfIndentId.Add(item.INDENTID); var secModel = new SecurityNumberUpdateVM() { ACCOUNTNUMBER = item.ACCOUNTNUMBER, APPROVED = "0", CHEQUESTATE = "0", CHEQUE_NUMBER = item.RANGESTART.ToString(), CMC_CODE = "985", DATECAPTURED = DateTime.Now.ToString("dd-MMM-yy"), INDENT_ID = item.INDENTID, INITUPLOAD = "1", NUMBER_OF_CHEQUES_PRINTED = item.NOOFLEAVES.ToString(), OPERATOR_ID = "Superflux", PREFIX = "PO", REPLACES = "", REPLACESPREFIX = "", SECURITY_NUMBER = item.STARTAUDIT.ToString(), SEQ = "", SN = "1", UPLOADED = "0" }; listSec.Add(secModel); } using (var orcl = new OracleConnection(_connectionString)) { orcl.Open(); var command = new OracleCommand() { Connection = orcl, CommandText = STOREDPROC.UPDATEINDENTTABLE, CommandType = CommandType.StoredProcedure, BindByName = true }; command.Parameters.Add(new OracleParameter("P_ERROR_MSG", OracleDbType.Varchar2)).Direction = ParameterDirection.Output; command.Parameters.Add(new OracleParameter("n_array", OracleDbType.Varchar2) { CollectionType = OracleCollectionType.PLSQLAssociativeArray, Value = listOfIndentId.ToArray() }); try { command.ExecuteNonQuery(); } catch (Exception ex) { ErrorWriter.WriteLog($"Decryption process returned error : { ex.Message } at { DateTime.Now }"); } finally { orcl.Close(); } var listSecDT = new ListtoDataTable().ToDataTable(listSec); _db.BulkCopyWriteToServer(listSecDT, "SECURITYCHEQUENUMBEROLD"); } } objDecrypt.Status = true; objDecrypt.Message = $"File successfully decrypted to { outputFile } at { DateTime.Now }"; objDecrypt.Data = dModel; ErrorWriter.WriteLog($"Decryption process returned : { objDecrypt.Message } at { DateTime.Now }"); return(objDecrypt); } catch (Exception ex) { var error = await ExceptionRefiner.LogError(ex); ErrorWriter.WriteLog($"Decryption process returned error: { ex.Message } at { DateTime.Now }"); objDecrypt.Status = false; objDecrypt.Message = error; objDecrypt.Data = null; return(objDecrypt); } }
public void GetProcessTable(ref DataTable dta) { int iReturnCode; //Return code int iStartAddr; int iStart; string szAdd = "ZR"; string szDeviceName; //List data for 'DeviceName' int iNumberOfData = 32; //Data for 'DeviceSize' short[] arrDeviceValue = new short[iNumberOfData]; int iProcessType = 0; int iProcessDepth = 0; int iNormalReverse = 0; int iReverseWidth = 0; int iMarginofAdvance = 0; int iMarginofDelay = 0; int iCutOff = 0; string szProcessName = ""; List <ProcessTableData> processtables = new List <ProcessTableData>(); //DataTable dta = new DataTable(); try { int idx = 0; for (int cclink = 1; cclink <= 4; cclink++) { iStart = ((cclink - 1) * 1000) + 3000; for (int stno = 1; stno <= 30; stno++) { iStartAddr = ((stno - 1) * 32) + iStart; szDeviceName = szAdd + iStartAddr.ToString(); iReturnCode = 0; if (Connected == true) { iReturnCode = plc.ReadDeviceBlock2(szDeviceName, iNumberOfData, out arrDeviceValue[0]); } if (iReturnCode == 0) { int k = 0; szProcessName = ""; foreach (var baca in arrDeviceValue) { if (k < 16) { switch (k) { case 0: iProcessType = baca; break; case 1: iProcessDepth = baca; break; case 2: iNormalReverse = baca; break; case 3: iReverseWidth = baca; break; case 4: iMarginofAdvance = baca; break; case 5: iMarginofDelay = baca; break; case 6: iCutOff = baca; break; default: break; } } else { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szProcessName += tchar.ToString(); } } k++; } //insert to datatable processtables.Add(new ProcessTableData { id = idx, cc_link_no = cclink, stno = stno, process_type = iProcessType, depth = iProcessDepth, normal_reverse = iNormalReverse, margin_reverse = iReverseWidth, margin_of_adv = iMarginofAdvance, margin_of_delay = iMarginofDelay, cut_off = iCutOff, process_name = szProcessName }); } idx++; } } //ListtoDataTable lsttodt = new ListtoDataTable(); dta = ListtoDataTable.ListToDataTable(processtables); } //Exception processing catch (Exception exception) { Debug.WriteLine(exception.Message); string stringFormat = "Read Process Table Failed"; StatusPLCLog = stringFormat; } //return dta; }
public int GetProcessStatusTable(ref DataTable dta) { int iReturnCode = 9; //Return code string szAdd = "ZR"; int iNumberOfData = 94; //Data for 'DeviceSize' short[] arrDeviceValue = new short[iNumberOfData]; List <ConvResultTableData> convtables = new List <ConvResultTableData>(); try { if (Connected == true) { //List<JobCode> jobcode = new List<JobCode>(); for (int id = 1; id <= 400; id++) { Debug.WriteLine("Ambil data untuk ind = " + id); int iStartAddr = ((id - 1) * 100) + 11000; string szDeviceName = szAdd + iStartAddr.ToString(); iReturnCode = plc.ReadDeviceBlock2(szDeviceName, iNumberOfData, out arrDeviceValue[0]); if (iReturnCode == 0) { //int k = 0; string szPID = ""; string szVIN = ""; string szSuffix = ""; string szModelCode = ""; string szWLCCode = ""; string szChassisNo = ""; short[] arrJob = new short[60]; int idxJob = 0; short idx = 0; Debug.WriteLine("Start Baca PLC"); Debug.WriteLine("Jumlah yang akan dibace" + arrDeviceValue.Length); for (int k = 0; k < arrDeviceValue.Length; k++) { short baca = arrDeviceValue[k]; //if (k < 95) //{ // if (k == 0) { idx = baca; } else if (Enumerable.Range(1, 5).Contains(k)) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szPID += tchar.ToString(); } } else if (Enumerable.Range(6, 9).Contains(k)) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szVIN += tchar.ToString(); } } else if (k == 15) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szSuffix += tchar.ToString(); } } else if (Enumerable.Range(16, 2).Contains(k)) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szModelCode += tchar.ToString(); } } else if (Enumerable.Range(18, 2).Contains(k)) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szWLCCode += tchar.ToString(); } } else if (Enumerable.Range(20, 10).Contains(k)) { byte[] kon = BitConverter.GetBytes(baca); foreach (byte m in kon) { char tchar = Convert.ToChar(m); szChassisNo += tchar.ToString(); } } else if (Enumerable.Range(35, 60).Contains(k)) { arrJob[idxJob] = baca; idxJob++; } //} //k++; } //Debug.WriteLine("Data satu row = " + k.ToString()); //creat job list List <JobCode> jobCodes = new List <JobCode>(); for (int ijob = 0; ijob < 30; ijob++) { Debug.WriteLine("Add Job Code idx = " + ijob.ToString() + "; Jumlahtotal job = " + arrJob.Length.ToString()); JobCode jobCode = new JobCode { B1 = arrJob[(ijob * 2)], B2 = arrJob[(ijob * 2) + 1] }; jobCodes.Add(jobCode); } //insert to datatable convtables.Add(new ConvResultTableData { Id = idx, pid = szPID, vin = szVIN, suffix = szSuffix, model_code = szModelCode, wlc_code = szWLCCode, chassis_number = szChassisNo, jobCode = jobCodes }); } else { iReturnCode = 8; } } } else { iReturnCode = 7; } //ListtoDataTable lsttodt = new ListtoDataTable(); dta = ListtoDataTable.ListToDataTable(convtables); } //Exception processing catch (Exception exception) { Debug.WriteLine(exception.Message); string stringFormat = "Read Conversion Result Table Failed"; StatusPLCLog = stringFormat; iReturnCode = 9; } return(iReturnCode); }
public async Task <DataResult <MfbViewModel> > UPLOADMFBEXCEL(HttpPostedFileBase upload, string username) { try { if (string.IsNullOrEmpty(username)) { throw new PlatformCustomException("invalid user"); } var objResult = new DataResult <MfbViewModel>(); var parameter = new List <IDbDataParameter>(); //declare all variables for indents for excel #region IndentVariables var indentId = string.Empty; var micrAccountNo = string.Empty; var sortCode = string.Empty; var lastSerialNumber = 0; var branchCode = string.Empty; var branchName = string.Empty; var firstChequeNumber = string.Empty; var numberOfCheques = string.Empty; var numberOfChequesPrinted = string.Empty; var chequeType = string.Empty; var dateOfRequest = DateTime.Now.ToString("dd-MMM-yy"); var dateEnterted = DateTime.Now.ToString("dd-MMM-yy"); var pulled = string.Empty; var datePulled = DateTime.Now.ToString("dd-MMM-yy"); var printed = string.Empty; var approved = string.Empty; var approver = string.Empty; var uploaded = string.Empty; var requisitionId = string.Empty; var scheduleNo = string.Empty; var indentSource = string.Empty; var deliveryBranchCode = string.Empty; var customerName = string.Empty; var ranged = string.Empty; var recieved = string.Empty; var dateRecieved = DateTime.Now.ToString("dd-MMM-yy"); var deleted = string.Empty; var acknowledged = string.Empty; var dateAcknowledged = DateTime.Now.ToString("dd-MMM-yy"); var dispatched = string.Empty; var dateDispatched = DateTime.Now.ToString("dd-MMM-yy"); var dispatchNumber = string.Empty; var dateApproved = DateTime.Now.ToString("dd-MMM-yy"); var costOfBooklet = string.Empty; var cancel = string.Empty; var mult = string.Empty; var cmcCode = string.Empty; var batchId = string.Empty; var generated = string.Empty; var dateOfPrinting = DateTime.Now.ToString("dd-MMM-yy"); var receivedApprovedBy = string.Empty; int lastSerialCounter = 0; #endregion var validateUpload = await MfbExcelValidation(upload); //convert excel to list var convertExcelToDT = FileUploadToDataTable(upload); //convert databaTable to List var convertDtToList = ConvertDataTableToList <MFBIndentsUpload>(convertExcelToDT); var listMfb = new List <MFBIndentsUpload>(); foreach (var item in convertDtToList) { var branchParam = new List <IDbDataParameter>(); DbConnection connection = null; branchParam.Add(_db.CreateParameter("p_branchname", 100, item.BRANCHNAME, DbType.String, ParameterDirection.Input)); branchParam.Add(_db.CreateParameter("p_branchcode", 5, string.Empty, DbType.String, ParameterDirection.Output)); branchParam.Add(_db.CreateParameter("p_sortcode", 9, string.Empty, DbType.String, ParameterDirection.Output)); branchParam.Add(_db.CreateParameter("p_cmcinuse", 5, string.Empty, DbType.String, ParameterDirection.Output)); branchParam.Add(_db.CreateParameter("p_error_msg", 200, string.Empty, DbType.String, ParameterDirection.Output)); if (string.IsNullOrEmpty(branchCode)) { var getBranchCodeByName = _db.GetExecuteNonQuery(STOREDPROC.GETBRANCHCODEBYBRANCHNAME, CommandType.StoredProcedure, branchParam, 0, out connection); branchCode = getBranchCodeByName.Parameters["p_branchcode"].Value.ToString(); sortCode = getBranchCodeByName.Parameters["p_sortcode"].Value.ToString(); cmcCode = getBranchCodeByName.Parameters["p_cmcinuse"].Value.ToString(); string error = getBranchCodeByName.Parameters["p_error_msg"].Value.ToString(); if (!string.IsNullOrEmpty(error)) { objResult.Data = null; objResult.Status = false; objResult.Message = error; ErrorWriter.WriteLog($"MFB upload process returned : { objResult.Message } at { DateTime.Now }"); return(objResult); } } var currentUser = username; var reqId = item.REQUISITION_ID.ToString(); micrAccountNo = item.MICR_ACCOUNT_NO; requisitionId = Convert.ToInt32(item.REQUISITION_ID).ToString("D8"); approved = "N"; branchName = item.BRANCHNAME; cancel = "N"; chequeType = GetConfigValue("MFBChequeType"); deleted = "N"; dispatched = "N"; numberOfCheques = item.NUMBEROFCHEQUES; indentSource = GetConfigValue("IndentSource"); pulled = "N"; acknowledged = "N"; printed = "N"; scheduleNo = item.SCHEDULE_NO; deliveryBranchCode = item.DELIVERY_BRANCHCODE; customerName = item.CUSTOMER_NAME; recieved = "N"; deleted = "N"; dispatched = "N"; indentId = $"{branchCode}{micrAccountNo}{requisitionId}"; var lastSerialParam = new List <IDbDataParameter>(); if (lastSerialCounter <= Convert.ToInt32(lastSerialNumber)) { var dR = new DataRead(); var dt = new DataTable(); var ds = dR.GetLastSerialNumberByBranchCode(branchCode); if (ds.Tables[0].Rows.Count < 1) { //SETLAST_SERIAL_NUMBER TO 1 lastSerialCounter = 1; var insertParams = new List <IDbDataParameter>(); insertParams.Add(_db.CreateParameter("p_branchcode", 13, branchCode, DbType.String, ParameterDirection.Input)); insertParams.Add(_db.CreateParameter("p_sortcode", 9, sortCode, DbType.String, ParameterDirection.Input)); insertParams.Add(_db.CreateParameter("p_lastserial", 12, 0, DbType.Decimal, ParameterDirection.Input)); insertParams.Add(_db.CreateParameter("p_cmccode", 3, cmcCode, DbType.String, ParameterDirection.Input)); insertParams.Add(_db.CreateParameter("p_error_msg", 200, string.Empty, DbType.String, ParameterDirection.Output)); //INSERT NEW RECORD FOR THE BRANCH _db.InsertWithTransaction(STOREDPROC.INSERTINTOLASTSERIALNUMBER, CommandType.StoredProcedure, insertParams, 0); } else { dt = ds.Tables[0]; var getLastSerial = dt.Rows[0]["LAST_SERIAL_NUMBER"].ToString(); lastSerialNumber = Convert.ToInt32(getLastSerial); var lastSerialNumberToUse = Convert.ToInt32(lastSerialNumber) + 1; lastSerialCounter = Convert.ToInt32(lastSerialNumberToUse); } } var objMfb = new MFBIndentsUpload() { INDENT_ID = indentId, MICR_ACCOUNT_NO = micrAccountNo, SORTCODE = sortCode, BRANCHNAME = branchName, BRANCHCODE = branchCode, FIRST_CHEQUE_NUMBER = lastSerialCounter.ToString(), NUMBEROFCHEQUES = numberOfCheques, NUMBEROFCHEQUESPRINTED = numberOfChequesPrinted, CHEQUETYPE = chequeType, DATEOFREQUEST = dateOfRequest, DATEENTERED = dateEnterted, PULLED = pulled, DATEPULLED = datePulled, PRINTED = printed, DATEOFPRINTING = dateOfPrinting, RECEIVEDAPPROVED_BY = receivedApprovedBy, ORIGINATOR = currentUser, APPROVED = approved, APPROVER = approver, UPLOADED = uploaded, REQUISITION_ID = requisitionId, SCHEDULE_NO = scheduleNo, INDENTSOURCE = indentSource, DELIVERY_BRANCHCODE = deliveryBranchCode, CUSTOMER_NAME = customerName, RANGED = ranged, RECEIVED = recieved, DATERECEIVED = dateRecieved, DELETED = deleted, ACKNOWLEDGED = acknowledged, DATEACKNOWLEDGED = dateAcknowledged, DISPATCHED = dispatched, DATEDISPATCHED = dateDispatched, DISPATCHNUMBER = dispatchNumber, DATEAPPROVED = dateApproved, COST_OF_BOOKLET = costOfBooklet, CANCEL = cancel, MULT = mult, BATCHID = batchId, GENERATED = generated }; lastSerialCounter++; listMfb.Add(objMfb); } var listMfbDT = new ListtoDataTable().ToDataTable(listMfb); _db.BulkCopyWriteToServer(listMfbDT, "INDENTS_TEST"); //update last serial table with the last id used by branch code var updateParam = new List <IDbDataParameter>(); updateParam.Add(_db.CreateParameter("p_lastserialnumber", 100, lastSerialCounter - 1, DbType.String, ParameterDirection.Input)); updateParam.Add(_db.CreateParameter("p_branchcode", 5, branchCode, DbType.String, ParameterDirection.Input)); updateParam.Add(_db.CreateParameter("p_error_msg", 200, string.Empty, DbType.String, ParameterDirection.Output)); _db.Update(STOREDPROC.UPDATELASTSERIALNUMBER, CommandType.StoredProcedure, updateParam, 0); objResult.Data = null; objResult.Status = true; objResult.Message = listMfbDT.Rows.Count.ToString(); ErrorWriter.WriteLog($"MFB upload process returned : { objResult.Message } indents processed at { DateTime.Now }"); return(objResult); } catch (Exception ex) { var error = await ExceptionRefiner.LogError(ex); ErrorWriter.WriteLog($"MFB upload process returned error: { ex.Message } at { DateTime.Now }"); return(new DataResult <MfbViewModel>() { Data = null, Message = error, Status = false }); } }
public async Task <DataResult <IndentsToGenerate> > GENERATEDINDENTSANDENCRYPT(string userId) { var objIndents = new DataResult <IndentsToGenerate>(); var parameter = new List <IDbDataParameter>(); var exportDataToExcel = false; var listIndents = new List <GeneratedIndents>(); //var copyOfGeneratedIndents = new DataTable(); DbConnection db = null; var transCode = GetConfigValue("TransactionCode"); try { parameter.Add(_db.CreateParameter("P_ERROR_MSG", string.Empty, DbType.String)); parameter.Add(_db.CreateParameter("P_INDENTGENERATED", OracleDbType.RefCursor, null)); parameter.Add(_db.CreateParameter("p_transcode", 13, transCode, DbType.String, ParameterDirection.Input)); var generateIndentsForProcessing = _db.GetDataTable(STOREDPROC.GENERATEINDENTFORPROC, CommandType.StoredProcedure, 0, parameter); if (generateIndentsForProcessing.Rows.Count == 0) { objIndents.Data = null; objIndents.Status = false; objIndents.Message = "No record currently available for processing."; ErrorWriter.WriteLog($"Fetch indetns for encryption returned : { objIndents.Message } at { DateTime.Now }"); return(objIndents); } //This part is used to remove indentId column from excel report. Uncomment if you want to generate indents without Indent_Id //copyOfGeneratedIndents = generateIndentsForProcessing.Copy(); //generateIndentsForProcessing.Columns.RemoveAt(0); DeleteExistingFilesInFolder(GetConfigValue("GeneratedIndentLocation")); var fullPath = ServerPath(); var fileName = Path.GetFileName(fullPath); exportDataToExcel = await ExportDataToExcelAndEncrypt(generateIndentsForProcessing, fileName, fullPath); var convertDTToList = ConvertDataTableToList <IndentsToGenerate>(generateIndentsForProcessing); string id = DateTime.Now.ToFileTimeUtc().ToString(); foreach (var item in convertDTToList) { var model = new GeneratedIndents(); model.GENERATED_ID = id; model.BATCHID = id; model.INDENT_ID = item.INDENT_ID; model.STATUSID = 0; model.DOM_BRANCH_ADD = item.DOMICILEBRANCHADDRESS; model.DOM_BRANCH_CODE = item.DOMICILEBRANCHCODE; model.SORTCODE = item.SORTCODE; model.CHEAQUETYPE = item.CHEQUETYPE; model.NUMBER_OF_LEAVES = item.NOOFLEAVES.ToString(); model.DEL_BRANCH_ADD = item.DELIVERYBRANCHADDRESS; model.SCHEMECODE = item.SCHEMECODE; model.DEL_BRANCH_CODE = item.DELIVERYBRANCHCODE; model.RANGE_START = item.RANGESTART.ToString(); model.RANGE_STOP = item.RANGESTOP.ToString(); model.GENERATEDBY = userId; model.GENERATEDON = DateTime.Now.ToString("dd-MMMM-yy"); model.SECNUM = null; model.DATECAPTURED = DateTime.Now.ToString("dd-MMMM-yy"); model.ACCOUNTNO = item.ACCOUNTNUMBER; model.ACCOUNTNAME = item.ACCOUNTNAME; model.CURRENCY = item.CURRENCY; listIndents.Add(model); } var listIndentDT = new ListtoDataTable().ToDataTable(listIndents); var updateParam = new List <IDbDataParameter>(); updateParam.Add(_db.CreateParameter("P_ERROR_MSG", 200, string.Empty, DbType.String, ParameterDirection.Output)); var updateCommand = _db.UpdateWithTransaction(STOREDPROC.UPDATEGENERATEDINDENTS, CommandType.StoredProcedure, updateParam, 0); _db.BulkCopyWriteToServer(listIndentDT, "GENERATEDINDENTS"); objIndents.Data = null; objIndents.Status = true; objIndents.Message = generateIndentsForProcessing.Rows.Count.ToString(); return(objIndents); } catch (Exception ex) { var error = await ExceptionRefiner.LogError(ex); ErrorWriter.WriteLog($"Encryption process returned error: { ex.Message } at { DateTime.Now }"); objIndents.Data = null; objIndents.Status = false; objIndents.Message = error; return(objIndents); } }