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);
}
