public ActionResult CustomerInvoiceReport()
{
CustomerInvoiceViewModel objectCustomerInvoiceViewModel = new CustomerInvoiceViewModel();
objectCustomerInvoiceViewModel.CustomerList = new SelectList(_customerComponent.GetAllCustomer(), "CustomerId", "NameEmail");
return(View(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 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 ActionResult GetInvoiceAmount(int id)
{
CustomerInvoiceViewModel objectCustomerInvoiceViewModel = _customerInvoiceComponent.GetCustomerInvoice(id);
return(Json(new
{
TotalHours = objectCustomerInvoiceViewModel.TotalHours,
Amount = objectCustomerInvoiceViewModel.Amount
}, JsonRequestBehavior.AllowGet));
return(null);
}
public ActionResult GetCustomerHoursAndAmount(int customerId, string type, string beginDate, string endDate, int inoviceId)
{
CustomerInvoiceViewModel objectCustomerInvoiceViewModel = _customerInvoiceComponent.GetCustomerHoursAndAmount(customerId, type, beginDate, endDate, inoviceId);
string beginDateDay = (objectCustomerInvoiceViewModel.BeginDate.Day.ToString().Length == 1) ? "0" + objectCustomerInvoiceViewModel.BeginDate.Day.ToString() : objectCustomerInvoiceViewModel.BeginDate.Day.ToString();
string beginDateMonth = (objectCustomerInvoiceViewModel.BeginDate.Month.ToString().Length == 1) ? "0" + objectCustomerInvoiceViewModel.BeginDate.Month.ToString() : objectCustomerInvoiceViewModel.BeginDate.Month.ToString();
string endDateDay = (objectCustomerInvoiceViewModel.EndDate.Day.ToString().Length == 1) ? "0" + objectCustomerInvoiceViewModel.EndDate.Day.ToString() : objectCustomerInvoiceViewModel.EndDate.Day.ToString();
string endDateMonth = (objectCustomerInvoiceViewModel.EndDate.Month.ToString().Length == 1) ? "0" + objectCustomerInvoiceViewModel.EndDate.Month.ToString() : objectCustomerInvoiceViewModel.EndDate.Month.ToString();
return(Json(new
{
beginDate = objectCustomerInvoiceViewModel.BeginDate.Year + "-" + beginDateMonth + "-" + beginDateDay,
endDate = objectCustomerInvoiceViewModel.EndDate.Year + "-" + endDateMonth + "-" + endDateDay,
totalHours = objectCustomerInvoiceViewModel.TotalHours,
amount = objectCustomerInvoiceViewModel.Amount,
hourlyRate = objectCustomerInvoiceViewModel.HourlyRate
}, JsonRequestBehavior.AllowGet));
}
public ResponseModel DeleteInvoice(CustomerInvoiceViewModel model)
{
try
{
var commandText = @"DELETE FROM CustomerInvoiceDetail where CustomerInvoiceId=@Id
DELETE FROM CustomerInvoice where Id=@Id
";
var name = new SqlParameter("@Id", model.Id);
var data = DbContext.Database.SqlQuery <CustomerInvoiceViewModel>(commandText, name).ToList();
}
catch (Exception ex)
{
return(new ResponseModel {
Success = false, Message = "Package can not be delete. Package is using on transaction."
});
}
return(new ResponseModel {
Success = true, Message = "Success"
});
}
public CustomerInvoiceViewModel GetCustomerSettlementList(string customerMainC, string customerSubC)
{
CustomerInvoiceViewModel result = new CustomerInvoiceViewModel();
// get invoice info
var invoice = _customerRepository.Query(cus => cus.CustomerMainC == customerMainC && cus.CustomerSubC == customerSubC).FirstOrDefault();
var invoiceViewModel = Mapper.Map <Customer_M, InvoiceViewModel>(invoice);
result.Invoice = invoiceViewModel;
var settlementList = _customerSettlementRepository.Query(set => set.CustomerMainC == customerMainC && set.CustomerSubC == customerSubC).OrderBy(i => i.ApplyD).ToList();
var settlementListViewModel = Mapper.Map <List <CustomerSettlement_M>, List <CustomerSettlementViewModel> >(settlementList);
result.SettlementList = settlementListViewModel;
// get profit markup list
var profitMarkupList = _customerGrossProfitRepository.Query(p => p.CustomerMainC == customerMainC && p.CustomerSubC == customerSubC).OrderBy(i => i.ApplyD).ToList();
result.ProfitMarkupList = Mapper.Map <List <CustomerGrossProfit_M>, List <CustomerGrossProfitViewModel> >(profitMarkupList);
return(result);
}
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 GetCustomersByMainCodeSubCode(string mainCode, string subCode)
{
var custInvoice = new CustomerInvoiceViewModel();
var customer = _customerRepository.Query(cus => cus.CustomerMainC == mainCode && cus.CustomerSubC == subCode).FirstOrDefault();
if (customer != null)
{
var custViewModel = Mapper.Map <Customer_M, CustomerViewModel>(customer);
var custIndex = FindIndex(customer.CustomerMainC, customer.CustomerSubC);
custViewModel.CustomerIndex = custIndex;
custInvoice.Customer = custViewModel;
if (!string.IsNullOrEmpty(custViewModel.InvoiceMainC) && !string.IsNullOrEmpty(custViewModel.InvoiceSubC))
{
var invoice =
_customerRepository.Query(cus => cus.CustomerMainC == custViewModel.InvoiceMainC && cus.CustomerSubC == custViewModel.InvoiceSubC).FirstOrDefault();
var invoiceViewModel = Mapper.Map <Customer_M, InvoiceViewModel>(invoice);
custInvoice.Invoice = invoiceViewModel;
// get init customer payment
var initCustomerPayment =
_customerBalanceRepository.Get(
p => p.CustomerMainC == mainCode & p.CustomerSubC == "000" & p.CustomerBalanceD == new DateTime(1900, 1, 1));
if (initCustomerPayment != null)
{
custInvoice.Invoice.InitCustomerPayment = initCustomerPayment.TotalAmount;
}
// get settlement list
var settlementList = _customerSettlementRepository.Query(set => set.CustomerMainC == custViewModel.InvoiceMainC && set.CustomerSubC == custViewModel.InvoiceSubC).OrderBy(i => i.ApplyD).ToList();
custInvoice.SettlementList = Mapper.Map <List <CustomerSettlement_M>, List <CustomerSettlementViewModel> >(settlementList);
// get profit markup list
var profitMarkupList = _customerGrossProfitRepository.Query(p => p.CustomerMainC == custViewModel.InvoiceMainC && p.CustomerSubC == custViewModel.InvoiceSubC).OrderBy(i => i.ApplyD).ToList();
custInvoice.ProfitMarkupList = Mapper.Map <List <CustomerGrossProfit_M>, List <CustomerGrossProfitViewModel> >(profitMarkupList);
}
custInvoice.Status = Convert.ToInt32(CustomerStatus.Edit);
}
else
{
customer = _customerRepository.Query(cus => cus.CustomerMainC == mainCode && cus.CustomerSubC == "000").FirstOrDefault();
if (customer != null)
{
var custViewModel = Mapper.Map <Customer_M, CustomerViewModel>(customer);
custInvoice.Customer = custViewModel;
custInvoice.Customer.CustomerSubC = subCode;
if (!string.IsNullOrEmpty(custViewModel.InvoiceMainC) && !string.IsNullOrEmpty(custViewModel.InvoiceSubC))
{
var invoice =
_customerRepository.Query(cus => cus.CustomerMainC == custViewModel.InvoiceMainC && cus.CustomerSubC == custViewModel.InvoiceSubC).FirstOrDefault();
var invoiceViewModel = Mapper.Map <Customer_M, InvoiceViewModel>(invoice);
custInvoice.Invoice = invoiceViewModel;
// get init customer payment
var initCustomerPayment =
_customerBalanceRepository.Get(
p => p.CustomerMainC == mainCode & p.CustomerSubC == "000" & p.CustomerBalanceD == new DateTime(1900, 1, 1));
if (initCustomerPayment != null)
{
custInvoice.Invoice.InitCustomerPayment = initCustomerPayment.TotalAmount;
}
// get settlement list
var settlementList = _customerSettlementRepository.Query(set => set.CustomerMainC == custViewModel.InvoiceMainC && set.CustomerSubC == custViewModel.InvoiceSubC).OrderBy(i => i.ApplyD).ToList();
custInvoice.SettlementList = Mapper.Map <List <CustomerSettlement_M>, List <CustomerSettlementViewModel> >(settlementList);
// get profit markup list
var profitMarkupList = _customerGrossProfitRepository.Query(p => p.CustomerMainC == custViewModel.InvoiceMainC && p.CustomerSubC == custViewModel.InvoiceSubC).OrderBy(i => i.ApplyD).ToList();
custInvoice.ProfitMarkupList = Mapper.Map <List <CustomerGrossProfit_M>, List <CustomerGrossProfitViewModel> >(profitMarkupList);
}
custInvoice.Status = Convert.ToInt32(CustomerStatus.Add);
}
else
{
custInvoice.Status = Convert.ToInt32(CustomerStatus.Add);
}
}
return(custInvoice);
}
public ActionResult PrintInvoice()
{
CustomerInvoiceViewModel objectCustomerInvoiceViewModel = _customerInvoiceComponent.GenerateInvoice(Convert.ToInt32(Request.QueryString["invoiceId"]));
return(View(objectCustomerInvoiceViewModel));
}
public IHttpActionResult Delete([FromBody] CustomerInvoiceViewModel model)
{
return(Ok(_customerInvoiceRepository.DeleteInvoice(model)));
}
