public Boolean Update(ExpenseENT entExpense)
{
ExpenseDAL dalExpense = new ExpenseDAL();
if (dalExpense.Update(entExpense))
{
return(true);
}
else
{
Message = dalExpense.Message;
return(false);
}
}
public Boolean Delete(SqlInt32 ExpenseID, SqlInt32 UserID)
{
ExpenseDAL dalExpense = new ExpenseDAL();
if (dalExpense.Delete(ExpenseID, UserID))
{
return(true);
}
else
{
Message = dalExpense.Message;
return(false);
}
}
private void fillGridViewExpense(SqlInt32 UserID)
{
ExpenseDAL dalExpense = new ExpenseDAL();
DataTable dtExpense = new DataTable();
dtExpense = dalExpense.SelectAll(UserID);
if (dtExpense != null && dtExpense.Rows.Count > 0)
{
gvExpense.DataSource = dtExpense;
gvExpense.DataBind();
calculateSum();
}
else
{
gvExpense.DataSource = null;
gvExpense.DataBind();
}
}
public ExpenseENT SelectByPK(SqlInt32 ExpenseID, SqlInt32 UserID)
{
ExpenseDAL dalExpense = new ExpenseDAL();
return(dalExpense.SelectByPK(ExpenseID, UserID));
}
public DataTable SelectAll(SqlInt32 UserID)
{
ExpenseDAL dalExpense = new ExpenseDAL();
return(dalExpense.SelectAll(UserID));
}
public ExpenseBO GetExpenseByID(int EXPENSEID)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.GetExpenseByID(EXPENSEID));
}
/// <summary>
/// To Update Expense
/// </summary>
/// <param name="objExpense"></param>
/// <returns></returns>
public string UpdateExpense(ExpenseBO objExpense)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.UpdateBank(objExpense));
}
/// <summary>
/// To Delete Expense
/// </summary>
/// <param name="EXPENSEID"></param>
/// <returns></returns>
public string DeleteExpense(int EXPENSEID)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.DeleteExpense(EXPENSEID));
}
//New Changes
/// <summary>
/// To Add Expense
/// </summary>
/// <param name="objExpense"></param>
/// <returns></returns>
public string AddExpense(ExpenseBO objExpense)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.AddExpense(objExpense));
}
/// <summary>
/// To Save Data
/// </summary>
/// <param name="dtExpen"></param>
/// <param name="ProjectID"></param>
/// <param name="uID"></param>
/// <returns></returns>
public DataTable savedata(DataTable dtExpen, int ProjectID, string uID)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.savedata(dtExpen, ProjectID, uID));
}
/// <summary>
/// To Get All Expense Data
/// </summary>
/// <param name="ProjectID"></param>
/// <returns></returns>
public object GetAllExpenseData(int ProjectID)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.GetAllExpenseData(ProjectID));
}
/// <summary>
/// To Get Expense Data For ACC
/// </summary>
/// <param name="ProjectID"></param>
/// <returns></returns>
public object GetExpenseDataForACC(int ProjectID)
{
ExpenseDAL ExpenseDALobj = new ExpenseDAL();
return(ExpenseDALobj.GetExpenseDataForACC(ProjectID));
}
/// <summary>
/// To Excel Data Import into Grid
/// </summary>
/// <param name="FilePath"></param>
/// <param name="Extension"></param>
/// <param name="projectID"></param>
/// <param name="createdBy"></param>
/// <returns></returns>
public DataTable ExcelDataImportintoGrid(string FilePath, string Extension, int projectID, int createdBy)
{
ExpenseDAL objExpensePopup = new ExpenseDAL();
return(objExpensePopup.ExcelDataImportintoGrid(FilePath, Extension, projectID, createdBy));
}
