public ActionResult CreateCustomerInvoice(CustomerInvoiceViewModel customerViewModel) { ActiveUser activeUser = new JavaScriptSerializer().Deserialize<ActiveUser>(System.Web.HttpContext.Current.User.Identity.Name); customerViewModel.CreatedBy = activeUser.UserId; customerViewModel.ModifiedBy = activeUser.UserId; var result = _customerInvoiceComponent.CreateCustomerInvoice(customerViewModel); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult CreateCustomerInvoicePopup(int id) { var customer = _customerInvoiceComponent.GetCustomerInvoice(id); if (customer == null) customer = new CustomerInvoiceViewModel(); customer.CustomerList = new SelectList(_customerComponent.GetAllCustomer(), "CustomerId", "NameEmail"); return PartialView("/Views/Shared/Partials/_CustomerInvoice.cshtml", customer); }
public int? CreateCustomerInvoice(CustomerInvoiceViewModel customerInvoiceViewModel) { CustomerInvoice customerInvoice = null; if (customerInvoiceViewModel.InvoiceId > 0) { customerInvoice = _repository.Find<CustomerInvoice>(x => x.InvoiceId == customerInvoiceViewModel.InvoiceId); if (customerInvoice == null) return null; customerInvoice.CustomerId = customerInvoiceViewModel.CustomerId; customerInvoice.InvoiceNo = customerInvoiceViewModel.InvoiceNo; customerInvoice.BeginDate = customerInvoiceViewModel.BeginDate; customerInvoice.EndDate = customerInvoiceViewModel.EndDate; customerInvoice.TotalHours = customerInvoiceViewModel.TotalHours; customerInvoice.HourlyRate = customerInvoiceViewModel.HourlyRate; customerInvoice.Amount = customerInvoiceViewModel.Amount; customerInvoice.Description = customerInvoiceViewModel.Description; customerInvoice.InternalComments = customerInvoiceViewModel.InternalComments; customerInvoice.ModifiedBy = customerInvoiceViewModel.ModifiedBy; customerInvoice.ModifiedDate = DateTime.Now; _repository.Modify<CustomerInvoice>(customerInvoice); return customerInvoice.InvoiceId; } Mapper.CreateMap<CustomerInvoiceViewModel, CustomerInvoice>(); customerInvoice = Mapper.Map<CustomerInvoiceViewModel, CustomerInvoice>(customerInvoiceViewModel); customerInvoice.CreatedDate = DateTime.Now; customerInvoice.CreatedBy = customerInvoiceViewModel.CreatedBy; customerInvoice.IsDeleted = false; return _repository.Insert<CustomerInvoice>(customerInvoice); }
public CustomerInvoiceViewModel GenerateInvoice(int invoiceId) { using (SecurityAgencyEntities objContext = new SecurityAgencyEntities()) { CustomerInvoiceViewModel objectCustomerInvoiceViewModel = new CustomerInvoiceViewModel(); objectCustomerInvoiceViewModel = (from customer in objContext.Customers join customerInvoice in objContext.CustomerInvoices on customer.CustomerId equals customerInvoice.CustomerId where customerInvoice.InvoiceId == invoiceId select new CustomerInvoiceViewModel { InvoiceNo = customerInvoice.InvoiceNo, Name = customer.Name, HourlyRate=customerInvoice.HourlyRate, Address = customer.Address, Zip = customer.Zip, ContactNo = customer.ContactNo, InvoiceDate = customerInvoice.InvoiceDate, TotalHours = customerInvoice.TotalHours, Description = customerInvoice.Description, Amount = customerInvoice.Amount, BeginDate = customerInvoice.BeginDate, EndDate = customerInvoice.EndDate, CustomerId = customerInvoice.CustomerId }).FirstOrDefault(); //////Get values from hourlog table List<getCustomerInvoiceAmount_Result> objectgetCustomerInvoiceAmount_Result = objContext.getCustomerInvoiceAmount(objectCustomerInvoiceViewModel.BeginDate, objectCustomerInvoiceViewModel.EndDate, objectCustomerInvoiceViewModel.CustomerId).ToList(); if (objectCustomerInvoiceViewModel == null) return null; return objectCustomerInvoiceViewModel; } }
public CustomerInvoiceViewModel GetCustomerHoursAndAmount(int customerId, string type, string beginDate, string endDate, int inoviceId) { CustomerInvoiceViewModel objectCustomerInvoiceViewModel = new CustomerInvoiceViewModel(); using (SecurityAgencyEntities objContext = new SecurityAgencyEntities()) { if (string.IsNullOrEmpty(type)) { //Get beginDate and endDate first CustomerInvoice objectCustomerInvoice = _repository.GetAll<CustomerInvoice>().Where(x => x.CustomerId == customerId && x.IsDeleted == false && x.InvoiceId!= inoviceId).OrderByDescending(i => i.EndDate).FirstOrDefault(); if (objectCustomerInvoice != null) { beginDate = objectCustomerInvoice.EndDate.AddDays(1).ToString(); endDate = objectCustomerInvoice.EndDate.AddDays(7).ToString(); } } //////Get values from hourlog table List<getCustomerInvoiceAmount_Result> objectgetCustomerInvoiceAmount_Result = objContext.getCustomerInvoiceAmount(Convert.ToDateTime(beginDate), Convert.ToDateTime(endDate), customerId).ToList(); objectCustomerInvoiceViewModel.TotalHours = Convert.ToInt32(objectgetCustomerInvoiceAmount_Result.Sum(i=>i.TotHours)); objectCustomerInvoiceViewModel.Amount = Convert.ToInt32(objectgetCustomerInvoiceAmount_Result.Sum(i=>i.Amount)); objectCustomerInvoiceViewModel.BeginDate = Convert.ToDateTime(beginDate); objectCustomerInvoiceViewModel.EndDate = Convert.ToDateTime(endDate); objectCustomerInvoiceViewModel.HourlyRate = Convert.ToDecimal(objectgetCustomerInvoiceAmount_Result.FirstOrDefault().HourlyRate); return objectCustomerInvoiceViewModel; } }
public ActionResult CustomerInvoiceReport() { CustomerInvoiceViewModel objectCustomerInvoiceViewModel = new CustomerInvoiceViewModel(); objectCustomerInvoiceViewModel.CustomerList = new SelectList(_customerComponent.GetAllCustomer(), "CustomerId", "NameEmail"); return View(objectCustomerInvoiceViewModel); }