public static int DeleteExpenses(int id)
{
int iSuccess = 0;
int uSuccess = 0;
ExpensesInfo expenses = ExpensesDAL.GetExpensesById(id);
CardInfo cardInfo = CardDAL.GetCardById(expenses.CardId);
ExpensesDAL.DeleteExpenses(id, out iSuccess);
if (iSuccess > 0)
{
float amount = cardInfo.Amount + expenses.Amount;
float expenditureAmount = cardInfo.ExpenditureAmount - expenses.Amount;
CardDAL.UpdateCardAmount(amount, expenditureAmount, expenses.CardId, 2, out uSuccess);
}
if (iSuccess > 0 && uSuccess > 0)
{
return(1);
}
else
{
return(0);
}
}
protected void getDataPieChart()
{
decimal[] incomeArr1 = new decimal[5];
string[] incomeCat = new string[5];
decimal[] incomevValues = new decimal[5];
decimal[] incomePercentages = new decimal[10];
string[] income = new string[] { "Job/Business Income", "Rental Income", "Retirement Pension", "Social Security", "Other sources" };
ExpensesDAL expDAL = new ExpensesDAL();
IncomeSourceBO incB = new IncomeSourceBO();
IncomeDAL incDAL = new IncomeDAL();
incB = incDAL.GetIncomeDetail();
decimal totalIncome = incB.jobIncome + incB.rentalIncome + incB.retirementPension + incB.socialSecurity + incB.otherSources;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
incomeArr1 = incDAL.getDataOfIncome();
for (int j = 0; j < 5; j++)
{
incomePercentages[j] = (decimal)(incomeArr1[j] / totalIncome) * 100;
}
int i;
for (i = 0; i < 5; i++)
{
incomeCat[i] = income[i];
incomevValues[i] = incomePercentages[i];
}
Chart2.Series[0].Points.DataBindXY(incomeCat, incomevValues);
Chart2.Series[0].Label = "#PERCENT{P2}";
Chart2.Series[0].LegendText = "#VALX (#PERCENT)";
}
protected void getDataPieChart()
{
decimal[] arr2 = new decimal[10];
string[] cat1 = new string[10];
decimal[] Values = new decimal[10];
decimal[] percentages = new decimal[10];
string[] expenses = new string[] { "House Rent", "Utilities", "Education", "Health", "Shopping", "Transport/Travel", "Entertainment", "Outside Eating", "EMI", "Other Expenses" };
ExpensesDAL expDAL = new ExpensesDAL();
IncomeSourceBO incB = new IncomeSourceBO();
IncomeDAL incDAL = new IncomeDAL();
incB = incDAL.GetIncomeDetail();
decimal totalIncome = incB.bankAccount + incB.jobIncome + incB.rentalIncome + incB.retirementPension + incB.socialSecurity + incB.otherSources;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
arr2 = expDAL.getExpenseData();
for (int j = 0; j < 10; j++)
{
percentages[j] = (decimal)(arr2[j] / totalIncome) * 100;
}
int i;
for (i = 0; i < 10; i++)
{
cat1[i] = expenses[i];
Values[i] = percentages[i];
}
Chart2.Series[0].Points.DataBindXY(cat1, Values);
this.Chart2.Series[0]["PieLabelStyle"] = "Outside";
Chart2.Series[0].Label = "#PERCENT{P2}";
Chart2.Series[0].LegendText = "#VALX (#PERCENT)";
}
public void Save(int ClaimId)
{
this.ClaimID = ClaimId;
ExpensesDAL DAL = new ExpensesDAL();
DAL.Save(this);
}
public int AddExpense(Expense expense, User curruser)
{
//Modified by Talha: Jan 26th, 2012 - Added Return variable to ensure data inserted successfully
int cmd_success;
cmd_success = new ExpensesDAL().Insert(expense, curruser);
return(cmd_success);
}
public static int InsertOrUpdatetoExpenses(ExpensesInfo info)
{
int iSuccess = 0;
int uSuccess = 0;
ExpensesInfo expenses = new ExpensesInfo();
if (info.Id > 0)
{
expenses = ExpensesDAL.GetExpensesById(info.Id);
}
ExpensesDAL.InsertOrUpdatetoExpenses(info, out iSuccess);
if (iSuccess > 0 || iSuccess == -1)
{
CardInfo cardInfo = CardDAL.GetCardById(info.CardId);
float amount = 0;
float expenditureAmount = 0;
if (info.Id > 0)
{
amount = cardInfo.Amount - (info.Amount - expenses.Amount);
expenditureAmount = cardInfo.ExpenditureAmount + (info.Amount - expenses.Amount);
}
else
{
amount = cardInfo.Amount + info.Amount;
expenditureAmount = cardInfo.ExpenditureAmount + info.Amount;
}
CardDAL.UpdateCardAmount(amount, expenditureAmount, info.CardId, 2, out uSuccess);
}
if (iSuccess > 0 && uSuccess > 0)
{
return(1);
}
else if (iSuccess == -1 && uSuccess > 0)
{
return(-1);
}
else
{
return(0);
}
}
protected void getDataBarChart()
{
decimal[] arr2 = new decimal[10];
string[] cat1 = new string[10];
decimal[] Values = new decimal[10];
string[] expenses = new string[] { "House Rent", "Utilities", "Education", "Health", "Shopping", "Transport/Travel", "Entertainment", "Outside Eating", "EMI", "Other Expenses" };
ExpensesDAL expDAL = new ExpensesDAL();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
arr2 = expDAL.getExpenseData();
int i;
for (i = 0; i < 10; i++)
{
cat1[i] = expenses[i];
Values[i] = arr2[i];
}
Chart1.Series[0].Points.DataBindXY(cat1, Values);
}
public static UserCollection GetOwnerByCardNumber(string cardnumber)
{
return(ExpensesDAL.GetOwnerByCardNumber(cardnumber));
}
public static ExpensesCollection GetExpensesList(List <QueryElement> list)
{
return(ExpensesDAL.GetExpensesList(list));
}
public static ExpensesInfo GetExpensesById(int id)
{
return(ExpensesDAL.GetExpensesById(id));
}
public void Delete()
{
ExpensesDAL DAL = new ExpensesDAL();
DAL.Delete(this.iD);
}
