public ActionResult CreateQuote(IPQuotesModel model)
{
model.type = 0;
var id = quoteService.Add(model);
return(RedirectToAction("Quote", "IPQuote", new { id = id }));
}
public static IPQuotesModel Convert(ip_quotes iPQuotesDB)
{
if (iPQuotesDB == null)
{
//throw new ArgumentNullException(nameof(iPQuotesDB));
}
var model = new IPQuotesModel();
model.quote_id = iPQuotesDB.quote_id;
model.client_id = iPQuotesDB.client_id;
model.invoice_group_id = iPQuotesDB.invoice_group_id;
model.notes = iPQuotesDB.notes;
model.quote_date_created = iPQuotesDB.quote_date_created;
model.quote_date_expires = iPQuotesDB.quote_date_expires;
model.quote_date_modified = iPQuotesDB.quote_date_modified;
model.quote_discount_amount = iPQuotesDB.quote_discount_amount.HasValue ? iPQuotesDB.quote_discount_amount.Value : 0;
model.quote_discount_percent = iPQuotesDB.quote_discount_percent.HasValue ? iPQuotesDB.quote_discount_percent.Value : 0;
model.quote_number = iPQuotesDB.quote_number;
model.quote_password = iPQuotesDB.quote_password;
model.quote_status_id = iPQuotesDB.quote_status_id;
model.quote_url_key = iPQuotesDB.quote_url_key;
model.taxType = iPQuotesDB.taxType.HasValue ? iPQuotesDB.taxType.Value : 0;
model.user_id = iPQuotesDB.user_id;
model.client = Convert(iPQuotesDB.ip_clients);
model.quote_amount = Convert(iPQuotesDB.ip_quote_amounts.FirstOrDefault());
IIPPayments paymentService = new IPPaymentsRepository();
model.payment = paymentService.FilterIPPaymentsByQuoteID(iPQuotesDB.quote_id);
return(model);
}
public IEnumerable <IPQuotesModel> FilterIPQuotes()
{
//var allIPQuotesDB = AMDSystemsEntities.ip_quotes.Where(e => !(e.is_quote_delete.HasValue && e.is_quote_delete.Value)).Where(c => c.type == 0).Select(c => c).OrderByDescending(e => e.quote_id).ToList();
var allIPQuotesDB = AMDSystemsEntities.ip_quotes.Join(AMDSystemsEntities.ip_clients, a => a.client_id, b => b.client_id, (a, b) => new { a, b })
.Join(AMDSystemsEntities.ip_quote_amounts, c => c.a.quote_id, d => d.quote_id, (c, d) => new { c, d })
.Where(e => !(e.c.a.is_quote_delete.HasValue && e.c.a.is_quote_delete.Value))
.Where(c => c.c.a.type == 0).Select(c => c)
.OrderByDescending(e => e.c.a.quote_id).ToList();
var allIPQuotesModel = new List <IPQuotesModel>();
//allIPQuotesDB.ForEach(c => allIPQuotesModel.Add(Mapper.Convert(c)));
foreach (var item in allIPQuotesDB)
{
IPQuotesModel ip_q_temp = new IPQuotesModel();
ip_q_temp.client_id = item.c.a.client_id;
ip_q_temp.delivery_notes = item.c.a.delivery_notes;
ip_q_temp.invoice_group_id = item.c.a.invoice_group_id;
ip_q_temp.notes = item.c.a.notes;
ip_q_temp.quote_id = item.c.a.quote_id;
ip_q_temp.user_id = item.c.a.user_id;
ip_q_temp.quote_status_id = item.c.a.quote_status_id;
ip_q_temp.quote_date_created = item.c.a.quote_date_created;
ip_q_temp.quote_date_modified = item.c.a.quote_date_modified;
ip_q_temp.client_id = item.c.a.client_id;
ip_q_temp.quote_discount_amount = item.c.a.quote_discount_amount;
ip_q_temp.client_name = item.c.b.client_name;
ip_q_temp.quote_total = item.d.quote_total;
allIPQuotesModel.Add(ip_q_temp);
}
return(allIPQuotesModel);
}
public static IPInvoicesModel Map(IPQuotesModel iPQuotesModel, IPInvoicesModel ipQuotesDB)
{
//throw new NotImplementedException();
if (iPQuotesModel == null)
{
//throw new ArgumentNullException(nameof(iPQuotesModel));
}
if (ipQuotesDB == null)
{
//throw new ArgumentNullException(nameof(ipQuotesDB));
}
ipQuotesDB.client_id = iPQuotesModel.client_id;
ipQuotesDB.invoice_group_id = iPQuotesModel.invoice_group_id;
ipQuotesDB.type = iPQuotesModel.type;
ipQuotesDB.notes = iPQuotesModel.notes;
ipQuotesDB.quote_date_created = iPQuotesModel.quote_date_created;
ipQuotesDB.quote_date_expires = iPQuotesModel.quote_date_expires;
ipQuotesDB.quote_date_modified = iPQuotesModel.quote_date_modified;
ipQuotesDB.quote_discount_amount = iPQuotesModel.quote_discount_amount;
ipQuotesDB.quote_discount_percent = iPQuotesModel.quote_discount_percent;
ipQuotesDB.quote_number = iPQuotesModel.quote_number;
ipQuotesDB.quote_password = iPQuotesModel.quote_password;
ipQuotesDB.quote_status_id = iPQuotesModel.quote_status_id;
ipQuotesDB.quote_url_key = iPQuotesModel.quote_url_key;
ipQuotesDB.user_id = iPQuotesModel.user_id;
return(ipQuotesDB);
}
// GET: IPQuote
public ActionResult CreateQuote(int?Client_ID)
{
IPQuotesModel quoteModel = new IPQuotesModel();
if (Client_ID.HasValue)
{
quoteModel.client_id = Client_ID.Value;
}
return(View(quoteModel));
}
public ActionResult CreateBilling(IPQuotesModel model)
{
model.type = 3;
var id = quoteService.Add(model);
return(RedirectToAction("Billing", "Billing", new
{
id = id
}));
}
// GET: Billing
public ActionResult CreateBilling(int?Billing_Id)
{
IPQuotesModel quoteModel = new IPQuotesModel();
if (Billing_Id.HasValue)
{
quoteModel.client_id = Billing_Id.Value;
}
return(View(quoteModel));
}
public IPQuoteAmountsModel FilterIPQuoteAmounts(IPQuotesModel model)
{
var allIPQuoteAmountsDB = AMDSystemsEntities.ip_quote_amounts.Where(qa => qa.quote_id == model.quote_id).FirstOrDefault();
if (allIPQuoteAmountsDB == null)
{
return(new IPQuoteAmountsModel());
}
return(Mapper.Convert(allIPQuoteAmountsDB));
}
public void UpdateStatus(IPInvoicesModel iPInvoiceModel)
{
IPQuotesModel iPQuotesModel = Mapper.Map(iPInvoiceModel, new IPQuotesModel());
var ipQuotesDB = AMDSystemsEntities.ip_quotes.Where(c => c.quote_id == iPQuotesModel.quote_id).FirstOrDefault();
ipQuotesDB.quote_status_id = iPQuotesModel.quote_status_id;
ipQuotesDB.quote_date_modified = DateTime.Now;
ipQuotesDB.is_quote = iPQuotesModel.quote_status_id == 4 ? false : true;
ipQuotesDB.taxType = iPInvoiceModel.taxType;
AMDSystemsEntities.SaveChanges();
}
public IPQuoteTaxRatesModel FilterIPQuoteTaxRates(IPQuotesModel model)
{
var ipQuoteTaxRatesDB = AMDSystemsEntities.ip_quote_tax_rates.Where(qtr => qtr.quote_id == model.quote_id).FirstOrDefault();
if (ipQuoteTaxRatesDB == null)
{
return(new IPQuoteTaxRatesModel());
}
var ipQuoteTaxRatesModel = Mapper.Convert(ipQuoteTaxRatesDB);
return(ipQuoteTaxRatesModel);
}
public void UpdateStatus(IPQuotesModel iPQuotesModel)
{
var ipQuotesDB = AMDSystemsEntities.ip_quotes.Where(c => c.quote_id == iPQuotesModel.quote_id).FirstOrDefault();
ipQuotesDB.quote_status_id = iPQuotesModel.quote_status_id;
ipQuotesDB.quote_date_modified = DateTime.Now;
ipQuotesDB.is_quote = iPQuotesModel.quote_status_id == 4 ? false : true;
ipQuotesDB.taxType = iPQuotesModel.taxType;
ipQuotesDB.client_id = iPQuotesModel.client_id;
ipQuotesDB.quote_date_expires = iPQuotesModel.quote_date_expires;
AMDSystemsEntities.SaveChanges();
}
public IEnumerable <IPQuoteItemsModel> FilterIPQuoteItems(IPQuotesModel model)
{
var ipQuoteItemsDB = AMDSystemsEntities.ip_quote_items.Where(qt => qt.quote_id == model.quote_id).ToList();
if (ipQuoteItemsDB.Count() == 0)
{
return(new List <IPQuoteItemsModel>());
}
var ipQuoteItemsModel = ipQuoteItemsDB.Select(e => Mapper.Convert(e));
return(ipQuoteItemsModel);
}
public void Update(IPQuotesModel iPQuotesModel)
{
if (iPQuotesModel == null)
{
//throw new ArgumentNullException(nameof(iPQuotesModel));
}
iPQuotesModel.quote_date_modified = DateTime.Now;
var ipQuotesDB = AMDSystemsEntities.ip_quotes.Where(c => c.client_id == iPQuotesModel.quote_id).FirstOrDefault();
ipQuotesDB = Mapper.Map(iPQuotesModel, ipQuotesDB);
AMDSystemsEntities.ip_quotes.Add(ipQuotesDB);
AMDSystemsEntities.SaveChanges();
}
public void UpdateInvoice(IPQuotesModel iPQuotesModel)
{
var ipQuotesDB = AMDSystemsEntities.ip_quotes.Where(c => c.quote_id == iPQuotesModel.quote_id).FirstOrDefault();
ipQuotesDB.quote_date_modified = DateTime.Now;
ipQuotesDB.payment_method = iPQuotesModel.payment_method;
ipQuotesDB.delivery_notes = iPQuotesModel.delivery_notes;
ipQuotesDB.delivery_date = iPQuotesModel.delivery_date == DateTime.MinValue ? DateTime.Now : iPQuotesModel.delivery_date;
ipQuotesDB.payment_notes = iPQuotesModel.payment_notes;
ipQuotesDB.client_id = iPQuotesModel.client_id;
ipQuotesDB.quote_date_expires = iPQuotesModel.quote_date_expires;
ipQuotesDB.is_quote = iPQuotesModel.quote_status_id == 4 ? false : true;
AMDSystemsEntities.SaveChanges();
}
private object GetInvoiceDetails2(IPQuotesModel invoiceModel)
{
StringBuilder HTMLContent = new StringBuilder();
//var client = clientService.FilterIPClients(clientID);
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Invoice Date", DateTime.Now.ToShortDateString()));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Delivery Date", DateTime.Now.ToShortDateString()));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Order Date", DateTime.Now.ToShortDateString()));
HTMLContent.Append(string.Format("{0} \t{1}" + "<br/>", DateTime.Now.ToString(), ""));
HTMLContent.Append(string.Format("{0} \t{1}" + "<br/>", "7500", ""));
HTMLContent.Append(string.Format("{0} \t{1}" + "<br/>", "CHEQ", ""));
HTMLContent.Append(string.Format("{0} \t{1}" + "<br/>", "33ANYPA2110Q1ZV", ""));
HTMLContent.Append(string.Format("{0} \t{1}" + "<br/>", "ANYPA2110Q", ""));
return(HTMLContent);
}
private object GetInvoiceDetails1(IPQuotesModel invoiceModel)
{
StringBuilder HTMLContent = new StringBuilder();
//var client = clientService.FilterIPClients(clientID);
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Invoice Number", invoiceModel.quote_number.ToString()));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Delivery Notes", "Delivery by Hand"));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Order by", " "));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Due Date", " "));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Amount Due", " "));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Payment Method", " "));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "Tax Code", " "));
HTMLContent.Append(string.Format("{0} :\t{1}" + "<br/>", "VAT", " "));
return(HTMLContent);
}
public ActionResult UpdateBilling(IPQuotesModel model)
{
// model.quote_tax_rate.quote_id = model.quote_id;
//model.quote_amount.quote_id = model.quote_id;
quoteService.UpdateStatus(model);
if (model.quote_items != null)
{
quoteItemService.Update(model.quote_items, model.quote_id);
}
model.quote_amount.quote_id = model.quote_id;
quoteAmountsService.Update(model.quote_amount);
//quoteTaxRatesService.Update(model.quote_tax_rate);
return(RedirectToAction("Billing", new
{
id = model.quote_id
}));
}
public int Add(IPQuotesModel iPQuotesModel)
{
if (iPQuotesModel == null)
{
//throw new ArgumentNullException(nameof(iPQuotesModel));
}
var count = AMDSystemsEntities.ip_quotes.Where(e => e.type == iPQuotesModel.type).Count();
iPQuotesModel.quote_number = count.ToString();
iPQuotesModel.quote_date_created = DateTime.Now;
iPQuotesModel.quote_date_modified = DateTime.Now;
iPQuotesModel.quote_date_expires = DateTime.Now.AddMonths(12);
iPQuotesModel.quote_url_key = string.IsNullOrEmpty(iPQuotesModel.quote_url_key) ? string.Empty : iPQuotesModel.quote_url_key;
iPQuotesModel.invoice_group_id = iPQuotesModel.invoice_group_id == 0 ? 1 : iPQuotesModel.invoice_group_id;
iPQuotesModel.user_id = iPQuotesModel.user_id == 0 ? 1 : iPQuotesModel.user_id;
ip_quotes ipQuotesDB = Mapper.Map(iPQuotesModel, new ip_quotes());
AMDSystemsEntities.ip_quotes.Add(ipQuotesDB);
AMDSystemsEntities.SaveChanges();
return(ipQuotesDB.quote_id);
}
public ActionResult UpdateQuote(IPQuotesModel model)
{
// model.quote_tax_rate.quote_id = model.quote_id;
//model.quote_amount.quote_id = model.quote_id;
if (!string.IsNullOrEmpty(model.quote_date_expires_string))
{
model.quote_date_expires = DateTime.ParseExact(model.quote_date_expires_string, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
model.quote_date_expires = DateTime.Now;
}
quoteService.UpdateStatus(model);
if (model.quote_items != null)
{
quoteItemService.Update(model.quote_items, model.quote_id);
}
model.quote_amount.quote_id = model.quote_id;
quoteAmountsService.Update(model.quote_amount);
//quoteTaxRatesService.Update(model.quote_tax_rate);
return(RedirectToAction("Quote", new { id = model.quote_id }));
}
public ActionResult UpdateInvoices(IPQuotesModel model)
{
if (!string.IsNullOrEmpty(model.quote_date_expires_string))
{
model.quote_date_expires = DateTime.ParseExact(model.quote_date_expires_string, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
model.quote_date_expires = DateTime.Now;
}
quoteService.UpdateInvoice(model);
if (model.quote_items != null)
{
quoteItemService.Update(model.quote_items, model.quote_id);
}
model.quote_amount.quote_id = model.quote_id;
quoteAmountsService.Update(model.quote_amount);
if (model.payment != null)
{
model.payment.quote_id = model.quote_id;
paymentService.Update(model.payment);
}
return(RedirectToAction("Invoices", new { id = model.quote_id }));
}
// GET: IPQuote
public ActionResult CreateEstimate()
{
IPQuotesModel quoteModel = new IPQuotesModel();
return(View(quoteModel));
}
