public void UpdateExpenses(ExpensesModel o)
{
Expenses ph = db.ExpensesRep.GetItem(o.Expenses_PK);
db.ExpensesRep.Update(toExpenses(ph, o));
db.Save();
}
private List <ExpensesModel> getAllExpenses()
{
List <ExpensesModel> lstExpenses = new List <ExpensesModel>();
ExpensesModel expenses = new ExpensesModel();
queryString = "SELECT ID, date, description, cashout FROM dbspa.tblexpenses WHERE isDeleted = 0 AND (date BETWEEN ? AND ?)";
parameters = new List <string>();
DateTime date = DateTime.Parse(datePickerFrom.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
date = DateTime.Parse(datePickerTo.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
expenses.ID = reader["ID"].ToString();
expenses.Date = reader["date"].ToString();
expenses.Description = reader["description"].ToString();
expenses.CashOut = reader["cashout"].ToString();
lstExpenses.Add(expenses);
expenses = new ExpensesModel();
}
conDB.closeConnection();
return(lstExpenses);
}
public ActionResult EditExpenses(int?id)
{
if (Session["empName"] != null)
{
string name = Session["empName"].ToString();
var ss = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault();
var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == ss.id).FirstOrDefault();
ViewBag.cat = new SelectList(_db.Expensestypes.ToList(), "id", "catogery");
ViewBag.office = new SelectList(_db.Offices.ToList(), "id", "OfficeName");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpensesModel _expen = _db.Expenses.Find(id);
if (_expen == null)
{
return(HttpNotFound());
}
else if (_allowAll.Staticis == true)
{
return(View(_expen));
}
}
return(RedirectToAction("HavntAccess", "Employees"));
}
public ActionResult EditExpenses(int id, ExpensesModel _expen, string OfficeName, string catogery)
{
if (Session["empName"] != null)
{
ViewBag.cat = new SelectList(_db.Expensestypes.ToList(), "id", "catogery");
ViewBag.office = new SelectList(_db.Offices.ToList(), "id", "OfficeName");
if (ModelState.IsValid)
{
_expen.date = DateTime.Now;
_expen.office = OfficeName;
_expen.Expensestype = catogery;
_db.Entry(_expen).State = EntityState.Modified;
_db.SaveChanges();
TempData["EpenEdit"] = "تم التعديل بنجاح";
var model = new ExpensesAndTypes();
model.officeX = _db.Offices.ToList();
model.expenTypeX = _db.Expensestypes.ToList();
model.expenX = _db.Expenses.ToList();
return(View("Expenses", model));
}
return(View(_expen));
}
return(RedirectToAction("HavntAccess", "Employees"));
}
public int SaveExpenses(ExpensesModel model)
{
int result;
try
{
using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings))
{
sqlService.AddParameter("@AutoExpensesID", model.AutoExpensesID);
sqlService.AddParameter("@Particulars", model.Particulars);
sqlService.AddParameter("@ExpensesBillNo", model.ExpensesBillNo);
sqlService.AddParameter("@ShopName", model.ShopName);
sqlService.AddParameter("@Quantity", model.Quantity);
sqlService.AddParameter("@Amount", model.Amount);
sqlService.AddParameter("@PaymentMode", model.PaymentMode);
sqlService.AddParameter("@PurchasesDate", model.PurchasesDate);
sqlService.AddOutputParameter("@Result", SqlDbType.SmallInt);
sqlService.ExecuteSPNonQuery("dbo.USP_SaveExpenses");
result = (int)((short)sqlService.Parameters["@Result"].Value);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
protected void btnSubmite_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
ExpensesModel model;
model = client.GetExpensesByID(txtExpensesName.Text, ParlourId);
if (model != null && ExpensesID == 0)
{
ShowMessage(ref lblMessage, MessageType.Danger, "Expenses Category Already Exists.");
}
else
{
model = new ExpensesModel();
model.pkiExpenseCategoryID = ExpensesID;
model.Category = txtExpensesName.Text;
model.parlourid = ParlourId;
model.LastModified = System.DateTime.Now;
model.ModifiedUser = UserName;
//================================================================
int retID = client.SaveExpensesDetails(model);
ExpensesID = retID;
ShowMessage(ref lblMessage, MessageType.Success, "Expenses Category Details successfully saved");
BindExpensesList();
ClearControl();
}
lblMessage.Visible = true;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab512", "goToTab(5)", true);
}
}
public bool Insert(ExpensesModel e)
{
bool success = false;
DataConnection con = new DataConnection();
try
{
con = new DataConnection();
con.MyConnection();
con.SqlQuery("Insert Into [Expenses] (Date,Reference,Amount,Category,Description,CeatedBy) Values(@date,@reference,@amount,@category,@description,@ceatedby)");
con.command.Parameters.AddWithValue("@date", e.DateAdded);
con.command.Parameters.AddWithValue("@reference", e.Reference);
con.command.Parameters.AddWithValue("@amount", e.Amount);
con.command.Parameters.AddWithValue("@category", e.Category);
con.command.Parameters.AddWithValue("@description", e.Description);
con.command.Parameters.AddWithValue("@ceatedby", e.CeatedBy);
int row = con.command.ExecuteNonQuery();
if (row > 0)
{
success = true;
}
else
{
success = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(success);
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
ExpensesModel em = dgvExpenses.SelectedItem as ExpensesModel;
ExpensesDetails expenseDetails = new ExpensesDetails(this, em);
expenseDetails.ShowDialog();
}
public static Expense ToModelToEntity(this ExpensesModel model)
{
var expense = new Expense {
ListItemsExpense = model.ListItemsExpenseModel.Select(x => x.ModelToEntity()).ToList()
};
return(expense);
}
public ActionResult ExpensesByIdPdf(List <int> ids)
{
var expenses = _expenseService.GetExpenses(UserId, ids);
var items = _autoMapperService.MapExpenseItems(expenses);
var model = new ExpensesModel {
Expenses = items
};
return(PdfActionResult("ExpensesPdf", model));
}
public static double SumExpense(this ExpensesModel model)
{
double sumExpense = 0;
foreach (ItemModel item in model.ListItemsExpenseModel)
{
sumExpense += item.HowMuch;
}
return(sumExpense);
}
private Expenses toExpenses(Expenses p, ExpensesModel i)
{
p.Category_FK = i.Category_FK;
p.Date_purchase = i.Date_purchase;
p.Expenses_PK = i.Expenses_PK;
p.Login_FK = i.Login_FK;
p.Name_expenses = i.Name_expenses;
p.Necessity = i.Necessity;
p.Sum_expenses = i.Sum_expenses;
return(p);
}
public async Task <IHttpActionResult> Post(ExpensesModel model)
{
try
{
Guid response = _repository.CreateExpense(model);
return(Ok(response));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public async Task <IHttpActionResult> Put(ExpensesModel model)
{
try
{
_repository.PutExpense(model);
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
return(BadRequest(ModelState));
}
public Guid CreateExpense(ExpensesModel model)
{
Entity expense = new Entity("new_expenseee");
expense.Attributes["new_employer"] = new EntityReference("account", model.AccountGuid);
expense.Attributes["new_employee"] = new EntityReference("contact", model.ContactGuid);
expense.Attributes["new_project"] = model.Project;
expense.Attributes["new_comment"] = model.Comment;
expense.Attributes["new_date"] = Convert.ToDateTime(model.Date);
expense.Attributes["new_spent"] = new Money(Convert.ToDecimal(model.Spent));
expense.Attributes["new_vat21"] = new Money(Convert.ToDecimal(model.Vat));
expense.Attributes["new_total"] = new Money(Convert.ToDecimal(model.Total));
return(_helper.CreateExpense(expense));
}
private void SaveExpenses()
{
try
{
if (ValidateControls())
{
model = new ExpensesModel();
model.AutoExpensesID = string.IsNullOrEmpty(hdnExpensesID.Text) ? null : (long?)Convert.ToInt64(hdnExpensesID.Text);
model.ExpensesBillNo = string.IsNullOrEmpty(txtBillNo.Text) ? null : txtBillNo.Text;
model.Particulars = txtParticulars.Text;
model.PaymentMode = Convert.ToString(ddlPaymentMode.Text);
model.ShopName = txtShopName.Text;
model.Quantity = Convert.ToInt32(txtQuantity.Text);
model.Amount = Convert.ToInt32(txtAmount.Text);
model.PurchasesDate = Common.Convert_String_To_Date(txtMaskedDate.Text);
//DateTime.ParseExact(dtpDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
_schoolExpenses = new SchoolExpenses();
int result = _schoolExpenses.SaveExpenses(model);
switch (result)
{
case 1:
MessageBox.Show("Record Successfully Saved.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
//case -1:
// MessageBox.Show("Error in saving records.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information);
// break;
}
BindExpensesGrid();
ClearControls();
/*=================================================================*/
//Show Hide Delete Control, Based on Date.
if (gridExpenses.Rows.Count == 0)
{
gridExpenses.Columns["ColDelete"].Visible = true;
}
else
{
Grid_ShowDeleteContol();
}
/*=================================================================*/
}
}
catch
{
MessageBox.Show("Error in saving records.", "Expenses", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void BindExpensesToUpdate()
{
ExpensesModel model = client.EditExpensesbyID(ExpensesID, ParlourId);
if (model == null)
{
Response.Write("<script>alert('Sorry!you are not authorized to perform edit on this Branch.');</script>");
}
else
{
ExpensesID = model.pkiExpenseCategoryID;
txtExpensesName.Text = model.Category;
btnSubmite.Text = "Update";
}
}
// GET: Summary
public ActionResult Index()
{
ExpensesModel model = new ExpensesModel();
BudgetModel bModel = new BudgetModel();
SessionManager session = new SessionManager();
int budgetId = session.Get <Budget>(PageConstant.BUDGET_ID_IN_SESSION).Id;
int userId = session.Get <User>(PageConstant.USER_ID_I_SESSION).Id;
var expense = model.GetAll(budgetId);
var viewModel = new SummaryModel()
{
Summary = expense
};
return(View(viewModel));
}
public ActionResult Save(ExpensesModel model)
{
BudgetModel bmodel = new BudgetModel();
SessionManager session = new SessionManager();
int userId = session.Get <User>(PageConstant.USER_ID_I_SESSION).Id;
model.BudgetId = session.Get <Budget>(PageConstant.BUDGET_ID_IN_SESSION).Id;
model.Save(model);
Budget budget = bmodel.GetCurrentBudget(userId);
budget.CurrentBudget = budget.CurrentBudget - model.Amount;
bmodel.UpdateBudget(budget);
bmodel.CurrentBudget = budget.CurrentBudget;
bmodel.StartBudget = budget.StartBudget;
return(View("MainPanel", bmodel));
}
public ActionResult NewExpenses(ExpensesModel EXP)
{
if (ismodel)
{
using (context = new BPOContext())
{
Expenses exp = new Expenses()
{
Expense_Name = EXP.Expense_Name,
Amount = EXP.Amount,
ID = EXP.ID,
Date = EXP.Date
};
context.Expenses.Add(exp);
context.SaveChanges();
}
}
return(View());
}
private void loadDataGridDetails()
{
List <ExpensesModel> lstExpensesModel = new List <ExpensesModel>();
ExpensesModel expensesModel = new ExpensesModel();
queryString = "SELECT ID, date, description, cashout FROM dbspa.tblexpenses WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
expensesModel.ID = reader["ID"].ToString();
expensesModel.Date = (!string.IsNullOrEmpty(reader["date"].ToString())) ? reader["date"].ToString() : "";
expensesModel.Description = reader["description"].ToString();
expensesModel.CashOut = reader["cashout"].ToString();
lstExpensesModel.Add(expensesModel);
expensesModel = new ExpensesModel();
}
conDB.closeConnection();
expenseWindow.dgvExpenses.ItemsSource = lstExpensesModel;
}
private void Grid_DoubleClick(object sender, EventArgs e)
{
if (grid.SelectedRows.Count == 0)
{
return;
}
var id = Convert.ToInt64(grid.SelectedRows[0].Cells["ID"].Value);
Expenses ObjExpenses = new Expenses();
ExpensesModel ExpMod = ObjExpenses.GetAllExpenses().FirstOrDefault(b => b.ID == id);
if (ExpMod != null)
{
//todo: Need to fix selected shop
m_ExpensesID = ExpMod.ID;
dtExpDate.Value = ExpMod.Exp_Date;
cmbExpType.Text = ExpMod.Exp_Type;
NBExpAmt.Value = ExpMod.Exp_Amt;
TxtDescription.Text = ExpMod.Description;
TxtReserve.Text = ExpMod.Reserve1;
}
}
public void WhenWantSaveThenSubtotalAreEsqualsThatHisList()
{
var context = new MonthFinanceContextMock();
//create Model with properties.
var earningModel = new EarningModel {
ListItemsEarningModel = new List <ItemModel> {
new ItemModel {
Name = "Salary", HowMuch = 5000
}
}
};
var expenseModel = new ExpensesModel {
ListItemsExpenseModel = new List <ItemModel> {
new ItemModel {
Name = "Rent House Dublin", HowMuch = 2500
}
}
};
var monthFinanceEntity = new MonthFinanceModel {
Expense = expenseModel,
//EarningModel = earningModel,
Saving = 1000
};
var entity = monthFinanceEntity.ToModelToEntity();
//entity.SubTotalEarning = 5000;
//entity.SubTotalExpense = 2500;
//pass model to ententy
var result = context.Save(entity);
Assert.Equal(true, result);
}
public ActionResult AddExpenses(string catogery, string OfficeName, int values, string Comment, ExpensesModel mod)
{
if (Session["empName"] != null)
{
string name = Session["empName"].ToString();
var ss = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault();
var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == ss.id).FirstOrDefault();
ViewBag.cat = new SelectList(_db.Expensestypes.ToList(), "id", "catogery");
ViewBag.office = new SelectList(_db.Offices.ToList(), "id", "OfficeName");
if (_allowAll.Staticis == true)
{
mod.Expensestype = catogery;
mod.office = OfficeName;
mod.values = values;
mod.Comment = Comment;
mod.date = DateTime.Now;
_db.Expenses.Add(mod);
_db.SaveChanges();
var model = new ExpensesAndTypes();
model.officeX = _db.Offices.ToList();
model.expenTypeX = _db.Expensestypes.ToList();
model.expenX = _db.Expenses.ToList();
return(View("Expenses", model));
}
}
return(RedirectToAction("HavntAccess", "Employees"));
}
public ExpensesViewModel()
{
_data = new ExpensesModel();
}
public ExpensesDetails(ExpensesWindow ew, ExpensesModel em)
{
expenseModel = em;
expenseWindow = ew;
InitializeComponent();
}
public void CreateExpenses(ExpensesModel item)
{
db.ExpensesRep.Create(toExpenses(new Expenses(), item));
db.Save();
GetAllExpenses();
}
public static int SaveExpensesDetails(ExpensesModel model)
{
return(ToolsSetingDAL.SaveExpensesDetails(model));
}
