private void btnSave_Click(object sender, EventArgs e) { var helper = new FinanceHelper(liteDBPath); var financeModel = new FinanceModel() { jobDate = DateTime.Parse(jobDate.Text), cashOnHand = double.Parse(String.IsNullOrEmpty(txtCashOnHand.Text)?"0": txtCashOnHand.Text), moneyIn = double.Parse(String.IsNullOrEmpty(textBox1.Text) ? "0" : textBox1.Text), moneyOut = double.Parse(String.IsNullOrEmpty(txtNoneyOut.Text) ? "0" : txtNoneyOut.Text) }; if (isEdit) { financeModel.id = finance.id; helper.Update(financeModel); } else { financeModel.id = Guid.NewGuid(); helper.Add(financeModel); } pForm.RefreshGridView(helper.GetAll()); this.Close(); }
public void Update(FinanceModel customer) { // Open data file (or create if not exits) using (var db = new LiteDatabase(liteDBPath)) { var issueCollection = db.GetCollection <FinanceModel>("finance"); // Update an existing issue document issueCollection.Update(customer); } }
public List <FinanceModel> ParseExcelDataToList(DataSet result, string bank, int userId, string iban) { if (bank == null || bank == "") { throw new Exception("Missing bank name!"); } if (iban == null || iban == "") { throw new Exception("Missing iban!"); } var dataTable = result.Tables[0]; //getting data from each sheet by its index or its "name" var finances = new List <FinanceModel>(); var finance = new FinanceModel(); var fieldMap = fieldMaps.FirstOrDefault(x => x.bank == bank); for (var i = 0; i < dataTable.Rows.Count; i++) { finance = new FinanceModel(); finance.user_id = userId; finance.iban = iban; for (var j = 0; j < dataTable.Columns.Count; j++) { if (fieldMap.transaction_date_index == j) { finance.transaction_date = Convert.ToDateTime(dataTable.Rows[i][j]); } if (fieldMap.description_index == j) { finance.description = Convert.ToString(dataTable.Rows[i][j]); } if (fieldMap.deposit_index == j) { finance.deposit = Convert.ToDecimal(dataTable.Rows[i][j]); } if (fieldMap.withdraw_index == j) { finance.withdraw = Convert.ToDecimal(dataTable.Rows[i][j]); } if (fieldMap.balance_index == j) { finance.balance = Convert.ToDecimal(dataTable.Rows[i][j]); } if (fieldMap.currency_index == j) { finance.currency = Convert.ToString(dataTable.Rows[i][j]); } } finances.Add(finance); } return(finances); }
public AddFinance(Finance prntForm, FinanceModel c = null) { InitializeComponent(); pForm = prntForm; finance = c; if (c != null) { initForm(); } }
public ActionResult FinanceHome() { FinanceModel model = new FinanceModel(); GetCity(); GetEmployeeList(); model.Gender = "M"; return(View(model)); }
public void Add(FinanceModel c) { // Open data file (or create if not exits) using (var db = new LiteDatabase(liteDBPath)) { var collection = db.GetCollection <FinanceModel>("finance"); // Insert a new issue document collection.Insert(c); collection.EnsureIndex(x => x.id); } }
public static FinanceModel Map(this Finance original) { if (original == null) { return(null); } var revenueShortfallManagementInitiatives = original.FinanceSchoolShortfallOptions.Select(x => x.ShortfallOptionID).ToList(); var schoolDealingWithSchoolFeeDefaulters = original.FinanceSchoolFeeDefaulters.Select(x => x.SchoolDefaulterID).ToList(); var row = new FinanceModel() { ID = original.ID, SchoolTypeID = original.SchoolTypeID, IsTheSchoolProjectingShortfallInRevenue = original.IsTheSchoolProjectingShortfallInRevenue, NoOfLearnersApprovedForSchoolFeeExemptionsConditional2019 = original.NoOfLearnersApprovedForSchoolFeeExemptionsConditional2019, NoOfLearnersApprovedForSchoolFeeExemptionsConditional2020 = original.NoOfLearnersApprovedForSchoolFeeExemptionsConditional2020, NoOfLearnersApprovedForSchoolFeeExemptionsPartial2019 = original.NoOfLearnersApprovedForSchoolFeeExemptionsPartial2019, NoOfLearnersApprovedForSchoolFeeExemptionsPartial2020 = original.NoOfLearnersApprovedForSchoolFeeExemptionsPartial2020, NoOfLearnersApprovedForSchoolFeeExemptionsTotal2019 = original.NoOfLearnersApprovedForSchoolFeeExemptionsTotal2019, NoOfLearnersApprovedForSchoolFeeExemptionsTotal2020 = original.NoOfLearnersApprovedForSchoolFeeExemptionsTotal2020, NoOfLearnersApprovedPostLockdownConditional = original.NoOfLearnersApprovedPostLockdownConditional, NoOfLearnersApprovedPostLockdownPartial = original.NoOfLearnersApprovedPostLockdownPartial, NoOfLearnersApprovedPostLockdownTotal = original.NoOfLearnersApprovedPostLockdownTotal, NoOfLearnersWhoseParentsDefaultedOnSchoolFeePayments2019 = original.NoOfLearnersWhoseParentsDefaultedOnSchoolFeePayments2019, NoOfLearnersWhoseParentsDefaultedOnSchoolFeePayments2020 = original.NoOfLearnersWhoseParentsDefaultedOnSchoolFeePayments2020, HowDidTheReducedRevenueCollectionImpactOnOperations = original.HowDidTheReducedRevenueCollectionImpactOnOperations, DidYouContinueWithSection38APaymentsToStaff = original.DidYouContinueWithSection38APaymentsToStaff, HowDidTheSchoolManagePayments = original.HowDidTheSchoolManagePayments, CanTheSchoolConfirmThatLTSMHasBeenProcuredFor2021 = original.CanTheSchoolConfirmThatLTSMHasBeenProcuredFor2021, CanTheSchoolConfirmThatItHasBeenAbleToPayTheirMunicipalAccounts = original.CanTheSchoolConfirmThatItHasBeenAbleToPayTheirMunicipalAccounts, CanTheSchoolConfirmThatItHasBeenAbleToUndertakeMinorRepairsUsingTheMaintenanceBudget = original.CanTheSchoolConfirmThatItHasBeenAbleToUndertakeMinorRepairsUsingTheMaintenanceBudget, CanTheSchoolConfirmThatTheyHavePaidAllTheirSGBAppointedStaff = original.CanTheSchoolConfirmThatTheyHavePaidAllTheirSGBAppointedStaff, DidTheSchoolRelieveSGBAppointedTeachingStaffOfTheirDuties = original.DidTheSchoolRelieveSGBAppointedTeachingStaffOfTheirDuties, NoOfSGBAppointedTeachingStaffWereAffected = original.NoOfSGBAppointedTeachingStaffWereAffected, WasTheReprioritisedBudgetApprovedAtAnAGM = original.WasTheReprioritisedBudgetApprovedAtAnAGM, DidTheInitiativesPursuedAssistTheSchoolInRealisingTheBudgetRevenueShortfall = original.DidTheInitiativesPursuedAssistTheSchoolInRealisingTheBudgetRevenueShortfall, IsThisSchoolSubsidisedByTheState = original.IsThisSchoolSubsidisedByTheState, WhatAreTheMainSourcesOfRevenueForTheSchool = original.WhatAreTheMainSourcesOfRevenueForTheSchool, IsTheSchoolProjectingShortfallInRevenueCollectionFor2020 = original.IsTheSchoolProjectingShortfallInRevenueCollectionFor2020, HaveYouPurchasedAdditionalLearnerAndEducatorSupportMaterial = original.HaveYouPurchasedAdditionalLearnerAndEducatorSupportMaterial, DoesTheSchoolHaveSufficientTextbooksForAllTheLearners = original.DoesTheSchoolHaveSufficientTextbooksForAllTheLearners, WasTheSchoolAbleToPayTheirMunicipalAccounts = original.WasTheSchoolAbleToPayTheirMunicipalAccounts, WasTheSchoolAbleToPurchasePPEsAndCovid19RelatedSupplies = original.WasTheSchoolAbleToPurchasePPEsAndCovid19RelatedSupplies, DidTheSchoolRelieveTeachingStaffOfTheirDutiesToBalanceTheBudget = original.DidTheSchoolRelieveTeachingStaffOfTheirDutiesToBalanceTheBudget, HowManyTeachingStaffWereRelievedOfTheirDutiesToBalanceTheBudget = original.HowManyTeachingStaffWereRelievedOfTheirDutiesToBalanceTheBudget, SchoolID = original.SchoolID, DateLogged = original.DateLogged, RevenueShortfallManagementInitiatives = revenueShortfallManagementInitiatives, SchoolDealingWithSchoolFeeDefaulters = schoolDealingWithSchoolFeeDefaulters }; return(row); }
private async Task <IList <FormOfPayment> > GetFormasPagamento() { var task = Task.Factory.StartNew(() => { using (var context = new FinanceModel()) { return(context.FormOfPayments.ToList().OrderBy(f => f.Description).ToArray()); } }); return(await task); }
private async Task <string[]> GetLocals() { var task = Task.Factory.StartNew(() => { using (var context = new FinanceModel()) { return(context.VariableExpenses.ToList().Select(v => v.Place).Distinct().ToArray()); } }); return(await task); }
private async Task <string[]> GetDescriptions() { // Tarefa para pegar as descrições e retornar para carregar o autocomplete do textbox var task = Task.Factory.StartNew(() => { using (var context = new FinanceModel()) { return(context.VariableExpenses.ToList().Select(v => v.Description).Distinct().ToArray()); } }); return(await task); }
/// <summary> /// method to get list of user permission for selected budget /// </summary> public ActionResult EditPermission(int BudgetId = 0, string level = "", string FlagCondition = "", string rowid = "") { try { ViewBag.EditLevel = level; ViewBag.GridRowID = rowid; ViewBag.childbudgetlist = _MarketingBudget.GetChildBudget(BudgetId); if (string.Compare(FlagCondition, "Edit", true) == 0) { ViewBag.FlagCondition = "Edit"; } else { ViewBag.FlagCondition = "View"; } List <RevenuePlanner.Models.Budget_Permission> UserList = _MarketingBudget.GetUserList(BudgetId); if (UserList.Count == 0) { ViewBag.NoRecord = "NoRecord"; } #region bindUser List for search List <BDSService.User> lstUserDetail = new List <BDSService.User>(); lstUserDetail = _MarketingBudget.GetAllUserList(Sessions.User.CID, Sessions.User.ID, Sessions.ApplicationId); if (Sessions.User != null) { lstUserDetail.Add(new BDSService.User { UserId = Sessions.User.UserId, ID = Sessions.User.ID, FirstName = Sessions.User.FirstName, LastName = Sessions.User.LastName, JobTitle = Sessions.User.JobTitle }); } TempData["Userlist"] = lstUserDetail; #endregion FinanceModel objFinanceModel = _MarketingBudget.EditPermission(BudgetId, Sessions.ApplicationId, UserList, Sessions.User.ID, Sessions.User.CID); return(PartialView("_UserPermission", objFinanceModel)); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } return(PartialView("_UserPermission", null)); }
public ActionResult FinancePost(FinanceModel model) { if (ModelState.IsValid) { Employee objEmployee = new Employee(); objEmployee.EmpName = model.name; objEmployee.EmpSalary = model.Salary; db.Employees.Add(objEmployee); db.SaveChanges(); } GetCity(); GetEmployeeList(); return(View("FinanceHome")); }
private void showFinance() { var financeModel = new FinanceModel() { id = Guid.Parse(selectedRow.Cells[0].Value.ToString()), cashOnHand = double.Parse(selectedRow.Cells[5].Value.ToString()), moneyIn = double.Parse(selectedRow.Cells[3].Value.ToString()), moneyOut = double.Parse(selectedRow.Cells[4].Value.ToString()), jobDate = DateTime.Parse(selectedRow.Cells[2].Value.ToString()), }; AddFinance frm = new AddFinance(this, financeModel); frm.ShowDialog(); }
public string GetFinanceInformationBySchoolID(int schoolID) { string results = string.Empty; JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository _repo = new SurveyRepository(); FinanceModel data = _repo.GetFinanceInformationBySchoolID(schoolID); results = js.Serialize(new { Message = "Success", Data = data }); } catch (Exception ex) { results = js.Serialize(new { Message = string.Format("Error - {0}", ex.Message) }); } return(results); }
private async Task <string> SaveExpense(string place, string description, decimal value, DateTime date, string type, FormOfPayment selFormPayment) { var task = Task.Factory.StartNew(() => { using (var context = new FinanceModel()) { var formOfPayment = context.FormOfPayments.First(f => f.Id == selFormPayment.Id); var balance = context.Balances.First(b => b.Id == formOfPayment.Balance_Id); var user = context.Users.First(u => u.CPF == "39174716808"); var expense = new VariableExpense() { Place = place, Description = description, FormOfPayment = formOfPayment, Value = value, Date = date, Type = type, CreatedAt = DateTime.Now, User = user }; if (type.Contains("Despesa")) { balance.Value -= (double)expense.Value; balance.UpdatedAt = DateTime.Now; } else { balance.Value += (double)expense.Value; } context.VariableExpenses.Add(expense); context.SaveChanges(); return("Despesa inserida com sucesso!"); } }); return(await task); }
public string SaveFinanceInformation(FinanceModel financeInformtion) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); FinanceModel data = repo.SaveFinanceInformation(financeInformtion); if (data.ID > 0) { resultList.Add("Success"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }
public async Task <FinanceModel> AddFinanceModel(FinanceModel financeModel) { if (financeModel == null) { return(null); } _context.FinanceModel.Add(financeModel); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (IdExists(financeModel.Id)) { return(null); } else { throw; } } return(null); }