public async Task <ActionResult> Create([Bind(Include = "ExpenseId,ActualAmount,SubCategoryId,DebitDate,ForMonth,FinancialYear")] ExpenseDetail expenseDetail)
{
if (ModelState.IsValid)
{
var isRecurring = db.SubCategories.Where(x => x.SubCategoryId == expenseDetail.SubCategoryId).FirstOrDefault();
if (isRecurring.StartDate != null && isRecurring.EndDate != null)
{
var yearsDiff = DateTime.Today.Year - isRecurring.StartDate.Value.Year;
if (yearsDiff == 0)
{
expenseDetail.MonthsPassed = DateTime.Today.Month - isRecurring.StartDate.Value.Month;
}
else
{
expenseDetail.MonthsPassed = (yearsDiff * 12) + (DateTime.Today.Month - isRecurring.StartDate.Value.Month);
}
}
// expenseDetail.AmountAccumulated = isRecurring.ExpectedAmount * savingsDetail.MonthsPassed;
db.ExpenseDetails.Add(expenseDetail);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(expenseDetail));
}
public static ExpenseDetailModel ToModelWithParticant(this ExpenseDetail entity)
{
var model = new ExpenseDetailModel()
{
Id = entity.Id,
MId = entity.MId,
ODate = entity.ODate,
EType = (ExpenseType)entity.EType,
Remark = entity.Remark,
PCount = entity.PCount,
Amount = entity.Amount,
ExpenseMain = entity.ExpenseMain.ToModelWithAuditHistory(),
ExpenseType = (ExpenseType)entity.EType
};
List <ExpenseMemberModel> result = new List <ExpenseMemberModel>();
if (entity.ExpenseMembers != null && entity.ExpenseMembers.Count > 0)
{
foreach (ExpenseMember item in entity.ExpenseMembers)
{
result.Add(item.ToModel());
model.ExpenseMemberNames = model.ExpenseMemberNames + item.User.EnglishName + ",";
}
model.ExpenseMemberNames = model.ExpenseMemberNames.Remove(model.ExpenseMemberNames.Length - 1);
}
model.ExpenseMembers = result;
return(model);
}
public ActionResult EditDetail(int id, int ExpenseSummaryID)
{
TempData["Message"] = null;
ExpenseDetail obj = new ExpenseDetail();
return(View(obj));
}
public string SaveExpenseDetailInfo(ExpenseDetail objExpenseDetailInfo)
{
int noRowCount = 0;
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
objDbCommand.AddInParameter("ExpenseType", objExpenseDetailInfo.ExpenseType);
objDbCommand.AddInParameter("CreatedBy", SessionUtility.STSessionContainer.UserID);
try
{
noRowCount = objDataAccess.ExecuteNonQuery(objDbCommand, "[dbo].uspCreateExpenseDetail", CommandType.StoredProcedure);
if (noRowCount > 0)
{
objDbCommand.Transaction.Commit();
return("Save Successfully");
}
else
{
objDbCommand.Transaction.Rollback();
return("Save Failed");
}
}
catch (Exception ex)
{
objDbCommand.Transaction.Rollback();
throw new Exception("Database Error Occured", ex);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
}
public ExpenseDetail UpdateExpenseDetail(ExpenseDetail ExpenseDetail)
{
var c = ctx.ExpenseDetail.Where(x => x.ID == ExpenseDetail.ID).First();
if (c != null)
{
c.ExpenseID = ExpenseDetail.ExpenseID;
c.ExpenseTypeID = ExpenseDetail.ExpenseTypeID;
c.CountryID = ExpenseDetail.CountryID;
c.Comment = ExpenseDetail.Comment;
c.Year = ExpenseDetail.Year;
c.Month01 = ExpenseDetail.Month01;
c.Month02 = ExpenseDetail.Month02;
c.Month03 = ExpenseDetail.Month03;
c.Month04 = ExpenseDetail.Month04;
c.Month05 = ExpenseDetail.Month05;
c.Month06 = ExpenseDetail.Month06;
c.Month07 = ExpenseDetail.Month07;
c.Month08 = ExpenseDetail.Month08;
c.Month09 = ExpenseDetail.Month09;
c.Month08 = ExpenseDetail.Month10;
c.Month10 = ExpenseDetail.Month11;
c.Month11 = ExpenseDetail.Month12;
ctx.SaveChanges();
}
return(c);
}
public ActionResult DeleteConfirmed(int id)
{
ExpenseDetail expenseDetail = db.ExpenseDetails.Find(id);
db.ExpenseDetails.Remove(expenseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddNewExpenseDetails(ExpenseDetail expenseDetail)
{
using (Billing_Customized_Entities expenseDetails = new Billing_Customized_Entities())
{
expenseDetails.ExpenseDetails.Add(expenseDetail);
expenseDetails.SaveChanges();
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
ExpenseDetail expenseDetail = await db.ExpenseDetails.FindAsync(id);
db.ExpenseDetails.Remove(expenseDetail);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit(ExpenseDetail objExpenseDetailInfo)
{
if (ModelState.IsValid)
{
ExpenseDetailBLL objExpenseDetailBLL = new ExpenseDetailBLL();
objExpenseDetailBLL.UpdateExpenseDetailInfo(objExpenseDetailInfo);
}
return(RedirectToAction("Index", "ExpenseDetail"));
}
public ActionResult Edit([Bind(Include = "ExpenseDetailID,ExpenseItemID,ExpenseDetailRemark,ExpenseDate,AddedDate,AddedUser,Deleteddate,DeletedUser,ModifiedDate,ModifiedUser,IsDeleted")] ExpenseDetail expenseDetail)
{
if (ModelState.IsValid)
{
db.Entry(expenseDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ExpenseItemID = new SelectList(db.ExpenseItems, "ExpenseItemID", "ExpenseItemName", expenseDetail.ExpenseItemID);
return(View(expenseDetail));
}
public void AddNewExpense(DateTime date, string details, decimal expenseAmount)
{
ExpenseDetail expenseDetail = new ExpenseDetail()
{
ExpenseDate = date.Date,
ExpenseDetails = details,
ExpenseAmount = Math.Round(expenseAmount, 2),
};
cashierDataAccess.AddNewExpenseDetails(expenseDetail);
}
public async Task <ActionResult> Edit(ExpenseDetail expenseDetail)
{
if (ModelState.IsValid)
{
db.Entry(expenseDetail).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Edit", "MonthlyPlanner", new { planId = expenseDetail.planId }));
}
return(RedirectToAction("ListIndex", "MonthlyPlanner"));
}
public ActionResult Detail(int id)
{
TempData["Message"] = null;
ExpenseDetail obj = new ExpenseDetail();
obj.HasBill = true;
ExpenseManager expenseManager = new ExpenseManager();
ViewBag.ExpenseSummaryName = expenseManager.GetExpenseSummaryName(id);
ViewBag.ExpenseSummaryID = id;
ViewBag.Category = new SelectList(expenseManager.GetExpenseCategory(), "ID", "Name");
return(View(obj));
}
public void DetailExpense_CreatingValidDetailExpense_ReturnDetailExpenseIsValid()
{
//Arrange
var vendor = "Viaduct Steakhouse";
var description = "development team’s project end celebration dinner";
var date = new DateTime(2017, 4, 27);
//Act
var expenseDetail = new ExpenseDetail(vendor, description, date);
//Assert
Assert.True(expenseDetail.IsValid());
}
public IHttpActionResult DeleteInvoiceDtailsTable(int id)
{
ExpenseDetail expensedetail = db.ExpenseDetails.Find(id);
if (expensedetail == null)
{
return(NotFound());
}
db.ExpenseDetails.Remove(expensedetail);
db.SaveChanges();
return(Ok(expensedetail));
}
public void DetailExpense_CreatingDetailExpenseWithDateLessThanMinSQLDate_ReturnDetailExpenseIsInvalid()
{
//Arrange
var vendor = "Viaduct Steakhouse";
var description = "development team’s project end celebration dinner";
var date = new DateTime(1752, 12, 31);
//Act
var expenseDetail = new ExpenseDetail(vendor, description, date);
//Assert
Assert.False(expenseDetail.IsValid());
}
public void DetailExpense_CreatingDetailExpenseWithoutDescription_ReturnDetailExpenseIsInvalid()
{
//Arrange
var vendor = "Viaduct Steakhouse";
var description = string.Empty;
var date = new DateTime(2017, 4, 27);
//Act
var expenseDetail = new ExpenseDetail(vendor, description, date);
//Assert
Assert.False(expenseDetail.IsValid());
}
public void DetailExpense_CreatingDetailExpenseWithoutVendor_ReturnDetailExpenseIsInvalid()
{
//Arrange
var vendor = string.Empty;
var description = "development team’s project end celebration dinner";
var date = new DateTime(2017, 4, 27);
//Act
var expenseDetail = new ExpenseDetail(vendor, description, date);
//Assert
Assert.False(expenseDetail.IsValid());
}
// GET: ExpenseDetails/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpenseDetail expenseDetail = await db.ExpenseDetails.FindAsync(id);
if (expenseDetail == null)
{
return(HttpNotFound());
}
return(View(expenseDetail));
}
// GET: POS/ExpenseDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpenseDetail expenseDetail = db.ExpenseDetails.Find(id);
if (expenseDetail == null)
{
return(HttpNotFound());
}
return(View(expenseDetail));
}
public async Task <ActionResult <ExpenseDetail> > GetExpense(long id)
{
var expense = await _context
.Expenses
.Include(e => e.Comments)
.FirstOrDefaultAsync(f => f.Id == id);
if (expense == null)
{
return(NotFound());
}
return(ExpenseDetail.FromExpense(expense));
}
private static ExpenseDetailDTO ToExpenseDetailDTO(ExpenseDetail details)
{
if (details == null)
{
return(new ExpenseDetailDTO());
}
return(new ExpenseDetailDTO
{
Vendor = details.Vendor,
Description = details.Description,
Date = details.Date
});
}
// GET: POS/ExpenseDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpenseDetail expenseDetail = db.ExpenseDetails.Find(id);
if (expenseDetail == null)
{
return(HttpNotFound());
}
ViewBag.ExpenseItemID = new SelectList(db.ExpenseItems, "ExpenseItemID", "ExpenseItemName", expenseDetail.ExpenseItemID);
return(View(expenseDetail));
}
public ActionResult Create([Bind(Include = "ExpenseDetailID,ExpenseItemID,ExpenseDetailRemark,ExpenseDate,AddedDate,AddedUser,Deleteddate,DeletedUser,ModifiedDate,ModifiedUser,IsDeleted")] ExpenseDetail expenseDetail)
{
expenseDetail.AddedUser = HttpContext.Session["username"].ToString();
expenseDetail.IsDeleted = false;
expenseDetail.AddedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.ExpenseDetails.Add(expenseDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ExpenseItemID = new SelectList(db.ExpenseItems, "ExpenseItemID", "ExpenseItemName", expenseDetail.ExpenseItemID);
return(View(expenseDetail));
}
public IHttpActionResult PostEpenseDetail([FromBody] ExpenseDetail ExpenseDetail)
{
using (DBEntities entities = new DBEntities())
{
try
{
ExpenseDetail = entities.ExpenseDetails.Add(ExpenseDetail);
entities.SaveChanges();
return(Ok(ExpenseDetail));
}
catch (Exception ex)
{
return(BadRequest());
}
}
}
private Expense GetValidExpense()
{
var costCentre = "DEV002";
var total = 1024.01m;
var paymentMethod = "personal card";
var vendor = "Viaduct Steakhouse";
var description = "development team’s project end celebration dinner";
var date = new DateTime(2017, 4, 27);
var expense = new Expense(costCentre, total, paymentMethod);
var expenseDetail = new ExpenseDetail(vendor, description, date);
expense.CreateExpenseDetail(expenseDetail);
return(expense);
}
public IEnumerable <ExpenseDetail> ExpenseDetailReport(int clientNo, int ProjectNo)
{
try
{
var connectionString = ConfigurationManager.AppSettings["PayMe-Connectionstring"];
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("GetExpenseDetailReport", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ClientId", clientNo);
cmd.Parameters.AddWithValue("@ProjectId", ProjectNo);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <ExpenseDetail> ExpenseDetailList = new List <ExpenseDetail>();
if (reader.HasRows)
{
while (reader.Read())
{
ExpenseDetail expenseDetail = new ExpenseDetail();
expenseDetail.Name = reader["Name"].ToString();
expenseDetail.ProjectName = reader["ProjectName"].ToString();
expenseDetail.ClientName = reader["ClientName"].ToString();
expenseDetail.UserName = reader["UserName"].ToString();
expenseDetail.ExpenseStatusName = reader["ExpenseStatusName"].ToString();
expenseDetail.Description = reader["Description"].ToString();
expenseDetail.ID = Convert.ToInt32(reader["ID"].ToString());
expenseDetail.CategoryID = Convert.ToInt32(reader["CategoryID"].ToString());
expenseDetail.CategoryName = reader["CategoryName"].ToString();
expenseDetail.ExpenseSummaryID = Convert.ToInt32(reader["ExpenseSummaryID"].ToString());
expenseDetail.CurrencyBillNo = reader["CurrencyBillNo"].ToString();
expenseDetail.Amount = Convert.ToDecimal(reader["Amount"] == DBNull.Value ? 0 : reader["Amount"]);
expenseDetail.BillDate = Convert.ToDateTime(reader["BillDate"].ToString());
expenseDetail.Location = reader["Location"].ToString();
expenseDetail.HasAttachment = Convert.ToBoolean(reader["HasAttachment"]);
expenseDetail.Notes = reader["Notes"].ToString();
ExpenseDetailList.Add(expenseDetail);
}
}
reader.Close();
connection.Close();
return(ExpenseDetailList);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message.ToString());
}
}
public ActionResult Detail(int id, ExpenseDetail expenseDetail)
{
try
{
ExpenseManager expenseManager = new ExpenseManager();
expenseDetail.ExpenseSummaryID = id;
int value = expenseManager.CreateExpenseDetail(expenseDetail);
////create path to store in database
//// expenseDetail.user_image = "~/image/" + expenseDetail.expenseAttachment.FileName;
//var t = Server.MapPath("Images") + "/" + expenseDetail.expenseAttachment.FileName;
////store image in folder
//expenseDetail.expenseAttachment.SaveAs(Server.MapPath("~/Images") + "/" + expenseDetail.expenseAttachment.FileName);
byte[] bytes;
if (expenseDetail.expenseAttachment != null)
{
using (BinaryReader br = new BinaryReader(expenseDetail.expenseAttachment.InputStream))
{
bytes = br.ReadBytes(expenseDetail.expenseAttachment.ContentLength);
}
string constr = ConfigurationManager.AppSettings["PayMe-Connectionstring"];
using (SqlConnection con = new SqlConnection(constr))
{
string query = "INSERT INTO ExpenseDetailDocument VALUES (@ExpenseDetailID,@Name, @ContentType, @Data)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ExpenseDetailID", value);
cmd.Parameters.AddWithValue("@Name", Path.GetFileName(expenseDetail.expenseAttachment.FileName));
cmd.Parameters.AddWithValue("@ContentType", expenseDetail.expenseAttachment.ContentType);
cmd.Parameters.AddWithValue("@Data", bytes);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
TempData["Message"] = "Expense Detail Created Successfully";
return(RedirectToAction("Detail/" + id));
}
catch (Exception ex)
{
TempData["Message"] = "Error Occured";
return(View());
}
}
public static ExpenseDetailModel ToModel(this ExpenseDetail entity)
{
var model = new ExpenseDetailModel()
{
Id = entity.Id,
MId = entity.MId,
ODate = entity.ODate,
EType = (ExpenseType)entity.EType,
Remark = entity.Remark,
PCount = entity.PCount,
Amount = entity.Amount,
ExpenseMain = entity.ExpenseMain.ToModel(),
ExpenseType = (ExpenseType)entity.EType
};
return(model);
}
internal static Expense ToExpense(ExpenseDTO expenseDTO)
{
if (expenseDTO == null ||
expenseDTO.Details == null)
{
return(null);
}
var expense = new Expense(expenseDTO.CostCentre, expenseDTO.Total, expenseDTO.PaymentMethod);
var expenseDetail = new ExpenseDetail(
expenseDTO.Details.Vendor,
expenseDTO.Details.Description,
expenseDTO.Details.Date);
expense.CreateExpenseDetail(expenseDetail);
return(expense);
}
