public void UpdateInvoice(Invoice invoice)
{
try
{
var currentInvoice = context.Invoices.Find(invoice.InvoiceID);
context.Entry(currentInvoice).CurrentValues.SetValues(invoice);
SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public List<Invoice> GetInvoice(Invoice invoice)
{
var invoices = (from p in context.Invoices
where p.InvoiceNumber == invoice.InvoiceNumber && p.CompanyID==invoice.CompanyID
select p).ToList();
return invoices;
}
public long InsertInvoice(Invoice invoice)
{
try
{
context.Entry(invoice).State = EntityState.Added;
SaveChanges();
return invoice.InvoiceID;
}
catch (Exception ex)
{
throw ex;
}
}
public long OrderToInvoiceInsert(Invoice invoice)
{
return invoiceRepository.InsertInvoice(invoice);
}
protected void ConvertButton_Click(object sender, EventArgs e)
{
long invoiceID;
int companyid = Convert.ToInt32(HttpContext.Current.Session["CompanyID"]);
long userid = Convert.ToInt32(HttpContext.Current.Session["UserID"]);
long orderID = Convert.ToInt32(Session["EditOrderID"]);
var orders = orderBL.ConvertOrderByID(orderID);
if (orders.Count() > 0)
{
foreach (var order in orders)
{
long orderId = order.OrderID;
Invoice invoice = new Invoice();
invoice.OrderID = orderId;
string number = "invoice";
var generateNumber = GenerateCustomizeNumber(number);
string invoiceNumber = generateNumber.Replace("Insert", "I");
invoice.Name = order.Name;
invoice.InvoiceNumber = invoiceNumber;
invoice.CreatedTime = DateTime.Now;
invoice.ModifiedTime = DateTime.Now;
invoice.CompanyID = companyid;
invoice.CreatedBy = userid;
invoiceID = orderBL.OrderToInvoiceInsert(invoice);
if (invoiceID > 0)
{
orderBL.UpdateConvertOrder(orderId);
Literal1.Text = "Convert Successfully";
Label1.Text = "This Order is Convert to Invoice Successfully";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "script", "ShowAlertModal();", true);
}
}
}
else
{
Literal1.Text = "!!!Not converted";
Label1.Text = "This Order is already converted to Invoice";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "script", "ShowAlertModal();", true);
}
}
private void ValidateInvoice(Invoice invoice)
{
if(invoice.InvoiceID!=null)
{
var duplicateInvoice = invoiceRepository.GetInvoice(invoice).FirstOrDefault();
if (duplicateInvoice != null && duplicateInvoice.InvoiceID != invoice.InvoiceID)
{
if (duplicateInvoice.InvoiceNumber == invoice.InvoiceNumber)
{
throw new InvoiceException(String.Format("Invoice {0} already exists",duplicateInvoice.Name, duplicateInvoice.InvoiceNumber));
}
}
}
}
public void UpdateInvoice(Invoice invoice)
{
try
{
//ValidateInvoice(invoice);
// invoiceRepository.UpdateInvoice(invoice);
}
catch (Exception ex)
{
throw ex;
}
}
public long InsertInvoice(Invoice invoice)
{
try
{
ValidateInvoice(invoice);
return invoiceRepository.InsertInvoice(invoice);
}
catch (Exception ex)
{
throw ex;
}
}
