public InvoiceDetailForm(InvoiceDetailModel model)
{
InitializeComponent();
_presenter = new InvoiceDetailPresenter(this, model);
this.Load += InvoiceDetailForm_Load;
}
private void UpdateCart(ProductViewModel data)
{
if (context.CartItems.Any(a => a.ProductId == data.Id))
{
//Item Exists
foreach (InvoiceDetailModel item in context.CartItems)
{
if (item.ProductId == data.Id)
{
item.QuantityInCart++;
item.Total = item.QuantityInCart * item.Rate;
item.OnPropertyChange("QuantityInCart");
item.OnPropertyChange("Total");
}
}
UpdateTotals(context.CartItems.Sum(a => a.Total));
}
else
{
var cartItem = new InvoiceDetailModel
{
ProductId = data.Id,
QuantityInCart = 1,
Name = data.Name,
Rate = data.Rate,
Barcode = data.Barcode,
Total = data.Rate
};
UpdateTotals(cartItem.Total);
context.CartItems.Add(cartItem);
}
}
private void BtnAddInvoiceDetail_Click(object sender, EventArgs e)
{
if (butonApasat != 1)
{
invoiceform.Show();
List <InvoiceDetailModel> invoicedetail = new List <InvoiceDetailModel>();
InvoiceDetailModel invoicedetailModel = new InvoiceDetailModel();
invoicedetail = invoiceDetailModels;
invoicedetailModel.InvoiceDetailId = 0;
invoicedetailModel.InvoiceId = invoiceform.InvoiceId;
invoicedetailModel.Item = new ItemModel
{
ItemName = comboBoxItem.SelectedItem.ToString(),
ItemId = Convert.ToInt32(comboBoxItem.SelectedIndex.ToString())
};
invoicedetailModel.Qtty = Convert.ToDecimal(txtBoxQtty.Text);
invoicedetailModel.Price = Convert.ToDecimal(txtBoxPrice.Text);
invoicedetailModel.Amount = Convert.ToDecimal(txtBoxAmount.Text);
invoicedetailModel.Observations = txtObservations.Text.ToString();
invoicedetailModel.status = 1;
invoicedetail.Add(invoicedetailModel);
invoiceform.refreshGrid(invoicedetail);
butonApasat = 0;
this.Close();
}
else
{
invoiceform.Show();
List <InvoiceDetailModel> invoicedetail = new List <InvoiceDetailModel>();
InvoiceDetailModel invoicedetailModel = new InvoiceDetailModel();
invoicedetail = invoiceDetailModels;
for (int i = 0; i < invoicedetail.Count; i++)
{
if (invoicedetail[i].status == 2)
{
invoicedetailModel.InvoiceDetailId = 0;
invoicedetailModel.InvoiceId = invoiceform.InvoiceId;
invoicedetailModel.Item = new ItemModel
{
ItemName = comboBoxItem.SelectedItem.ToString(),
ItemId = Convert.ToInt32(comboBoxItem.SelectedIndex.ToString())
};
invoicedetailModel.Qtty = Convert.ToDecimal(txtBoxQtty.Text);
invoicedetailModel.Price = Convert.ToDecimal(txtBoxPrice.Text);
invoicedetailModel.Amount = Convert.ToDecimal(txtBoxAmount.Text);
invoicedetailModel.Observations = txtObservations.Text.ToString();
invoicedetailModel.status = 2;
invoicedetail[i] = invoicedetailModel;
invoiceform.refreshGrid(invoicedetail);
butonApasat = 0;
this.Close();
}
}
}
}
public ActionResult AddinvoiceDetail(InvoiceDetailModel model)
{
var productModel = _productService.GetProductByCode(model.ProductCode);
if (productModel == null)
{
return(Json(new
{
IsProductSkusNotFound = true
}));
}
if (_invoiceService.CheckProductExistedInInvoice(model.InvoiceId, productModel.Id))
{
return(Json(new
{
IsDupp = true
}));
}
model.ProductId = productModel.Id;
model.Quantity = model.Quantity;
_invoiceService.InsertInvoiceDetail(model);
return(Json(new { }));
}
public void InsertInvoiceDetail(InvoiceDetailModel invoiceDetailModel)
{
var invoiceDetail = Mapper.Map <InvoiceDetail>(invoiceDetailModel);
_shoppingContext.InvoiceDetails.Add(invoiceDetail);
_shoppingContext.SaveChanges();
}
public ActionResult ProductAddPopup(string btnId, string formId, int invoiceId, ProductListSelected request)
{
if (request.ProductIds != null)
{
if (!string.IsNullOrEmpty(request.ProductIds))
{
var productIds = request.ProductIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var productId in productIds)
{
var id = Int32.Parse(productId);
var isExisted = _invoiceService.CheckProductExistedInInvoice(invoiceId, id);
if (isExisted)
{
continue;
}
var product = _productService.GetProductById(id);
var invoiceDetailModel = new InvoiceDetailModel()
{
Quantity = 1,
ProductId = id,
InvoiceId = invoiceId,
UnitPrice = product.Price
};
_invoiceService.InsertInvoiceDetail(invoiceDetailModel);
}
}
}
return(RedirectToAction("Edit", new { id = invoiceId }));
}
public static void UpdateInvoiceDetail(InvoiceDetailModel model)
{
InvoiceModel invoice = SessionHelper.Invoice;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).InvoiceSourceId = model.InvoiceSourceId;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).ItemId = model.ItemId;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).Quantity = model.Quantity;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).Rate = model.Rate;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).TaxId = model.TaxId;
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).Amount = model.Quantity * model.Rate;
if (model.TaxId != null)
{
TaxDetailModel taxDetail = TaxHelper.GetTaxDetail(invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).TaxId.ToString()).FirstOrDefault(x => x.StartDate <= SessionHelper.Invoice.InvoiceDate && x.EndDate >= SessionHelper.Invoice.InvoiceDate);
if (taxDetail != null)
{
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).TaxAmount = invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).Amount *taxDetail.Rate / 100;
}
else
{
invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id).TaxAmount = 0;
}
}
}
public void DeleteInvoiceDetail(InvoiceDetailModel detail)
{
SqlConnection connection = null;
try
{
connection = new SqlConnection(Properties.Resources.ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("DeleteInvoiceDetail", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@InvoiceDetailId", detail.invoiceDetailId));
command.ExecuteNonQuery();
command.Parameters.Clear();
}
catch (SqlException se)
{
throw se;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
public void RefreshUpdate(InvoiceDetailModel detail)
{
List <InvoiceDetailModel> list = new List <InvoiceDetailModel>();
for (int i = 0; i < dataGridDetails.Rows.Count; i++)
{
InvoiceDetailModel detailModel = new InvoiceDetailModel();
detailModel = (InvoiceDetailModel)dataGridDetails.Rows[i].DataBoundItem;
if (detailModel.InvoiceDetailId == detail.InvoiceDetailId)
{
list.Add(detail);
}
else
{
list.Add(detailModel);
}
}
dataGridDetails.DataSource = list;
dataGridDetails.Columns["InvoiceDetailId"].Visible = false;
dataGridDetails.Columns["ItemId"].Visible = false;
dataGridDetails.Columns["InvoiceId"].Visible = false;
dataGridDetails.Columns["Status"].Visible = false;
dataGridDetails.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public static void DeleteInvoiceDetail(InvoiceDetailModel model)
{
InvoiceModel invoice = SessionHelper.Invoice;
InvoiceDetailModel invoiceDetail = invoice.InvoiceDetail.FirstOrDefault(x => x.Id == model.Id);
invoice.InvoiceDetail.Remove(invoiceDetail);
}
public BindingList <InvoiceDetailModel> BLGetInvoiceDetail(int invoiceId, int?invoiceDetailId)
{
DAInvoiceDetail dac = new DAInvoiceDetail();
DataTable dt = new DataTable();
dt = dac.GetInvoiceDetail(invoiceId, invoiceDetailId);
BindingList <InvoiceDetailModel> list = new BindingList <InvoiceDetailModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
InvoiceDetailModel detail = new InvoiceDetailModel();
detail.invoiceDetailId = Convert.ToInt32(dt.Rows[i]["InvoiceDetailId"].ToString());
detail.invoiceId = Convert.ToInt32(dt.Rows[i]["InvoiceId"].ToString());
detail.itemId = Convert.ToInt32(dt.Rows[i]["itemId"].ToString());
detail.itemName = dt.Rows[i]["ItemName"].ToString();
detail.qtty = Convert.ToDecimal(dt.Rows[i]["Qtty"].ToString());
detail.price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString());
detail.amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());
detail.observation = dt.Rows[i]["Observation"].ToString();
detail.status = 3;
detail.unique = detail.RandomString(8);
list.Add(detail);
}
return(list);
}
public ActionResult UpdatePartial(InvoiceDetailModel model)
{
if (ModelState.IsValid)
{
try
{
if (model.ItemId == null && model.InvoiceSourceId == null)
{
ViewData["EditError"] = "Either Invoice Source or Item is required.";
}
else if (model.ItemId != null && model.InvoiceSourceId != null)
{
ViewData["EditError"] = "Only Invoice Source or Item can be entered at a time.";
}
else
{
InvoiceHelper.UpdateInvoiceDetail(model);
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
return(PartialView("_Detail", InvoiceHelper.GetInvoiceDetail()));
}
public void RefreshAdd(InvoiceDetailModel detail)
{
List <InvoiceDetailModel> list = new List <InvoiceDetailModel>();
//BLAddress bLAddress = new BLAddress();
for (int i = 0; i < dataGridDetails.Rows.Count; i++)
{
InvoiceDetailModel details = new InvoiceDetailModel();
details = (InvoiceDetailModel)dataGridDetails.Rows[i].DataBoundItem;
//addressModel.status = 1;
list.Add(details);
}
//list = bLAddress.Address(id);
//address.status = 1;
//address.ClientAddressId = -1;
list.Add(detail);
//MessageBox.Show(address.ClientAddressId.ToString());
dataGridDetails.DataSource = list;
dataGridDetails.Columns["InvoiceDetailId"].Visible = false;
dataGridDetails.Columns["ItemId"].Visible = false;
dataGridDetails.Columns["InvoiceId"].Visible = false;
dataGridDetails.Columns["Status"].Visible = false;
dataGridDetails.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void BtnAddDetail_Click(object sender, EventArgs e)
{
ItemModel item = (ItemModel)cmbItem.SelectedItem;
//string itemName = item.ItemName;
double qtty = Convert.ToDouble(txtQtty.Text);
double price = Convert.ToDouble(txtUnitPrice.Text);
double amount = Convert.ToDouble(txtAmount.Text);
string observations = txtObservations.Text;
InvoiceDetailModel invoiceDetail = new InvoiceDetailModel();
invoiceDetail.Amount = amount;
invoiceDetail.ItemName = item.ItemName;
invoiceDetail.InvoiceId = invoiceId;
invoiceDetail.Qtty = qtty;
invoiceDetail.UnitPrice = price;
invoiceDetail.Observations = observations;
invoiceDetail.Status = 1;
parent.RefreshAdd(invoiceDetail);
parent.Refresh();
parent.Show();
this.Hide();
parent.FormClosed += Parent_FormClosed;
}
public ActionResult SearchArticle(InvoiceDetailModel viewModel)
{
var strMessage = string.Empty;
try
{
if (ModelState.IsValid)
{
//var entity = viewModel.ToEntity();
//_invInvoiceService.BMSUnit.InvoiceRepository.Add(entity);
//_invInvoiceService.BMSUnit.InvoiceRepository.SaveChanges();
return(Content(Boolean.TrueString));
//return Content("Information has been saved successfully");
}
strMessage = Common.GetModelStateErrorMessage(ModelState);
}
catch (Exception ex)
{
strMessage = CommonExceptionMessage.GetExceptionMessage(ex, CommonAction.Save);
}
return(Content(strMessage));
}
private InvoiceDetailModel InitEditPanel()
{
InvoiceDetailModel detail = new InvoiceDetailModel();
initializareComboBox();
foreach (DataGridViewRow row in dataGridViewDetalii.SelectedRows)
{
tbAmount.Text = row.Cells[5].Value.ToString();
detail.InvoiceDetailId = Convert.ToInt32(row.Cells[0].Value.ToString());
tbObservations.Text = row.Cells[6].Value.ToString();
tbPrice.Text = row.Cells[4].Value.ToString();
tbQtty.Text = row.Cells[3].Value.ToString();
tbAmount.Text = ((Convert.ToDecimal(row.Cells[4].Value.ToString())) *
(Convert.ToDecimal(row.Cells[3].Value.ToString()))).ToString();
DataTable items = new DataTable();
BLItems blItems = new BLItems();
try
{
items = blItems.GetItemNameById(Convert.ToInt32(row.Cells[2].Value.ToString()));
cbItems.Text = items.Rows[0]["ItemName"].ToString();
}
catch (Exception ex)
{
Console.WriteLine("Eroare INIT PANEL!! " + ex.Message);
}
}
return(detail);
}
private void BtnEditDetail_Click(object sender, EventArgs e)
{
InvoiceDetailModel detaliuModificat = new InvoiceDetailModel();
BLInvoiceDetails bLInvoiceDetails = new BLInvoiceDetails();
try
{
detaliuModificat.InvoiceDetailId = this.EditDetailId;
detaliuModificat.Price = Convert.ToDecimal(tbPrice.Text);
detaliuModificat.Qtty = Convert.ToDecimal(tbQtty.Text);
detaliuModificat.Amount = Convert.ToDecimal(tbAmount.Text);
detaliuModificat.Observations = tbObservations.Text;
detaliuModificat.Articol.ItemId = Convert.ToInt32(cbItems.SelectedValue);
DialogResult dialogResult = MessageBox.Show("Sigur doriti sa modificati detaliul?", "Modificare Detaliu Factura", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
bLInvoiceDetails.UpdateInvoiceDetail(detaliuModificat, out bool status, out string message);
MessageBox.Show(message, "Status", MessageBoxButtons.OK,
MessageBoxIcon.Information);
panel1.Visible = false;
initializareDataGrid(this.factura.InvoiceId);
}
else if (dialogResult == DialogResult.No)
{
this.Hide();
}
}
catch (Exception ex)
{
Console.WriteLine("EROARE UPDATE DETAIL! " + ex.Message);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
InvoiceDetailModel detaliu = new InvoiceDetailModel();
BLInvoiceDetails blInvoice = new BLInvoiceDetails();
if (String.IsNullOrWhiteSpace(tbPrice.Text))
{
errorProvider1.SetError(tbPrice, "Camp obligatoriu!");
}
else if (String.IsNullOrWhiteSpace(tbQtty.Text))
{
errorProvider1.SetError(tbPrice, "Camp obligatoriu!");
}
else
{
try
{
detaliu.Price = Convert.ToDecimal(tbPrice.Text);
detaliu.Qtty = Convert.ToDecimal(tbQtty.Text);
detaliu.Amount = Convert.ToDecimal(tbAmount.Text);
detaliu.Observations = tbObservations.Text;
detaliu.Factura.InvoiceId = factura.InvoiceId;
detaliu.Articol.ItemId = Convert.ToInt32(cbItems.SelectedValue);
blInvoice.InsertInvoiceDetail(detaliu, out bool status, out string message);
MessageBox.Show(message, "Status", MessageBoxButtons.OK,
MessageBoxIcon.Information);
panel1.Visible = false;
initializareDataGrid(this.factura.InvoiceId);
}
catch (Exception ex)
{
Console.WriteLine("EROARE INSERARE DETALIU! " + ex.Message);
}
}
}
private void Button1_Click_1(object sender, EventArgs e)
{
AddInvoiceDetailForm addInvoice = new AddInvoiceDetailForm(this);
addInvoice.butonApasat = 1;
addInvoice.Show();
this.Hide();
if (Convert.ToInt32(dGVInvoiceDetails.SelectedRows[0].Cells[7].Value) == 1)
{
dGVInvoiceDetails.SelectedRows[0].Cells[7].Value = 1;
}
else
{
dGVInvoiceDetails.SelectedRows[0].Cells[7].Value = 2;
}
List <InvoiceDetailModel> invoiceDetailModels = new List <InvoiceDetailModel>();
for (int i = 0; i < dGVInvoiceDetails.RowCount; i++)
{
InvoiceDetailModel invoicedetail = new InvoiceDetailModel();
invoicedetail = (InvoiceDetailModel)dGVInvoiceDetails.Rows[i].DataBoundItem;
invoiceDetailModels.Add(invoicedetail);
}
addInvoice.invoiceDetailModels = invoiceDetailModels;
addInvoice.txtBoxPrice.Text = dGVInvoiceDetails.SelectedRows[0].Cells[5].Value.ToString();
addInvoice.txtBoxAmount.Text = dGVInvoiceDetails.SelectedRows[0].Cells[4].Value.ToString();
addInvoice.txtBoxQtty.Text = dGVInvoiceDetails.SelectedRows[0].Cells[3].Value.ToString();
addInvoice.txtObservations.Text = dGVInvoiceDetails.SelectedRows[0].Cells[6].Value.ToString();
}
private static InvoiceDetail getEntityByModel(InvoiceDetailModel model)
{
if (model == null)
{
return(null);
}
InvoiceDetail entity = new InvoiceDetail();
if (model.Id == 0)
{
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
}
else
{
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
}
entity.Amount = model.Amount;
entity.Id = model.Id;
entity.InvoiceId = model.InvoiceId;
entity.InvoiceSourceId = model.InvoiceSourceId;
entity.ItemId = model.ItemId;
entity.Quantity = model.Quantity;
entity.Rate = model.Rate;
entity.TaxAmount = model.TaxAmount;
entity.TaxId = model.TaxId;
entity.UpdateBy = AuthenticationHelper.UserId;
entity.UpdateDate = DateTime.Now;
return(entity);
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (dataGridViewItems.Rows.Count != 0)
{
int i = dataGridViewItems.SelectedCells[0].RowIndex;
int selectedInvoiceDetailId = Convert.ToInt32(dataGridViewItems.Rows[i].Cells[0].Value.ToString());
InvoiceDetailModel iv = new InvoiceDetailModel()
{
invoiceDetailId = selectedInvoiceDetailId,
invoiceId = invoiceIdSelected,
itemId = Convert.ToInt32(dataGridViewItems.Rows[i].Cells[2].Value.ToString()),
itemName = dataGridViewItems.Rows[i].Cells[3].Value.ToString(),
qtty = Convert.ToDecimal(dataGridViewItems.Rows[i].Cells[4].Value.ToString()),
price = Convert.ToDecimal(dataGridViewItems.Rows[i].Cells[5].Value.ToString()),
amount = Convert.ToDecimal(dataGridViewItems.Rows[i].Cells[6].Value.ToString()),
observation = dataGridViewItems.Rows[i].Cells[7].Value.ToString(),
status = 2,
unique = dataGridViewItems.Rows[i].Cells[9].Value.ToString()
};
if (listDetail.Count == 0)
{
listDetail.Add(iv);
}
else
{
foreach (InvoiceDetailModel model in listDetail)
{
if (model.unique == iv.unique && model.invoiceDetailId != 0)
{
model.status = 2;
break;
}
else if (model.unique == iv.unique && model.invoiceDetailId == 0)
{
listDetail.Remove(model);
break;
}
else if (iv.invoiceDetailId != 0)
{
listDetail.Add(iv);
break;
}
else
{
continue;
}
}
}
dataGridViewItems.Rows.RemoveAt(i);
}
else
{
MessageBox.Show("Nu se poate sterge niciun detaliu de factura deoarece nu exista niciunul", "Atentie", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
public void AddItemToDataGridViewAndList(InvoiceDetailForm iva)
{
InvoiceDetailModel detail = iva.GetInvoiceDetail();
if (!iva.IsAddedorModify())
{
changeDataGridView = false;
}
if (detail.status == 0)
{
dataGridViewItems.Rows.Add(detail.invoiceDetailId, detail.invoiceId, detail.itemId, detail.itemName, detail.qtty, detail.price, detail.amount, detail.observation, detail.status, detail.unique);
listDetail.Add(detail);
}
else if (detail.status == 1)
{
foreach (DataGridViewRow row in dataGridViewItems.Rows)
{
if (row.Cells[9].Value.ToString() == detail.unique.ToString() && row.Cells[0].Value.ToString() == detail.invoiceDetailId.ToString())
{
row.Cells[2].Value = detail.itemId.ToString();
row.Cells[3].Value = detail.itemName.ToString();
row.Cells[4].Value = detail.qtty.ToString();
row.Cells[5].Value = detail.price.ToString();
row.Cells[6].Value = detail.amount.ToString();
row.Cells[7].Value = detail.observation.ToString();
row.Cells[8].Value = detail.status.ToString();
bool verifyList = listDetail.Any(item => item.unique == detail.unique && item.invoiceDetailId == detail.invoiceDetailId);
if (!verifyList)
{
listDetail.Add(detail);
}
else
{
foreach (InvoiceDetailModel model in listDetail)
{
if (model.unique == detail.unique && model.invoiceDetailId == detail.invoiceDetailId)
{
model.itemId = detail.itemId;
model.itemName = detail.itemName;
model.qtty = detail.qtty;
model.price = detail.price;
model.amount = detail.amount;
model.observation = detail.observation;
break;
}
}
}
break;
}
}
}
}
public void UpdateInvoiceDetail(InvoiceDetailModel det, out bool status, out string errorMessage)
{
status = false;
errorMessage = "OK";
DAInvoiceDetails da = new DAInvoiceDetails();
da.UpdateInvoiceDetail(det);
errorMessage = "Detaliu modificat!";
}
public void InsertInvoiceDetail(InvoiceDetailModel det, out bool status, out string errorMessage)
{
status = false;
errorMessage = "OK";
DAInvoiceDetails da = new DAInvoiceDetails();
da.InsertInvoiceDetail(det);
errorMessage = "Detaliu adaugat!";
}
public InvoiceDetailsSubmitViewModel(InvoiceDetailModel invoice, INavigation navigation)
{
IsReturn = true;
_navigation = navigation;
submitCommand = new Command(async() => await submitInvoiceCommand());
isRefundCommand = new Command <bool>(setIsRefund);
isReturnCommand = new Command <bool>(setIsReturn);
invoiceDetail = invoice;
_IAllDataServices = new AllDataServices();
}
private void BtnAddInvoice_Click(object sender, EventArgs e)
{
InvoiceId += 1;
if (String.IsNullOrWhiteSpace(txtBoxInvoiceNumber.Text))
{
MessageBox.Show("Numarul facturii nu este completat!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(comboBoxClient.Text))
{
MessageBox.Show("Nu este ales nciun partenere!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (string.IsNullOrEmpty(comboBoxClientAddress.Text))
{
MessageBox.Show("Nu este ales nciun partenere!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (dateInvoiceDate.Text.Length == 0)
{
MessageBox.Show("Nu ai ales data!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DATotCeFolosescLaInvoice invoice = new DATotCeFolosescLaInvoice();
string numarfactura = txtBoxInvoiceNumber.Text;
DateTime dataFactura = dateInvoiceDate.Value.Date;
int idpar = ((ClientModel)comboBoxClient.SelectedItem).ClientId;
int idadresa = ((ClientAddressModel)comboBoxClientAddress.SelectedItem).ClientAddressId;
string obser = txtBoxObservations.Text;
List <InvoiceDetailModel> invoiceDetailModels = new List <InvoiceDetailModel>();
for (int i = 0; i < dGVInvoiceDetails.RowCount; i++)
{
InvoiceDetailModel invoicedetail = new InvoiceDetailModel();
invoicedetail = (InvoiceDetailModel)dGVInvoiceDetails.Rows[i].DataBoundItem;
invoiceDetailModels.Add(invoicedetail);
}
bool status = invoice.insertInvoice(numarfactura, dataFactura, idpar, idadresa, UserId, obser, invoiceDetailModels);
if (status == true)
{
MessageBox.Show("Factura adaugata!", "Wew", MessageBoxButtons.OK, MessageBoxIcon.Information);
InvoicesForm invoicesForm = new InvoicesForm();
invoicesForm.Show();
this.Hide();
invoicesForm.FormClosed += invoice_from_formClosed;
}
else
{
MessageBox.Show("Factura neadaugata!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public async Task <IActionResult> SearchAllInvoices([FromBody] InvoiceDetailModel model)
{
try
{
dynamic response = await new InvoiceManager().SearchAllInvoices(model);
return(Ok(response));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
private void Save(int invoiceId, int userId)
{
BLInvoice bLInvoice = new BLInvoice();
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
if (userId != 0 & invoiceId == 0)
{
string invoiceNumber = txtInvoiceNumber.Text;
DateTime invoiceDate = dateInvoice.Value;
ClientFullNameModel clientFullName = (ClientFullNameModel)cmbClientFullName.SelectedItem;
FullAddressModule fullAddress = (FullAddressModule)cmbAddress.SelectedItem;
if (fullAddress == null)
{
MessageBox.Show("Clientul nu are o adresa, adaugati o adresa clientului pentru a creea o factura!");
return;
}
int clientId = clientFullName.ClientId;
int clientAddressId = fullAddress.ClientAddressId;
string observations = txtObservations.Text;
MessageBox.Show(clientAddressId.ToString());
bLInvoice.AddInvoice(invoiceNumber, invoiceDate, clientId, clientAddressId, userId, observations);
MessageBox.Show("Factura a fost adaugata cu succes.");
int invoiceIdValue = bLInvoice.GetInvoiceList(-1, "", DateTime.Now, DateTime.Now, invoiceNumber)[0].InvoiceId;
Save(invoiceIdValue, 0);
}
if (userId == 0 & invoiceId != 0)
{
for (int i = 0; i < dataGridDetails.Rows.Count; i++)
{
InvoiceDetailModel detail = new InvoiceDetailModel();
detail = (InvoiceDetailModel)dataGridDetails.Rows[i].DataBoundItem;
if (detail.Status == 1)
{
bLInvoiceDetail.AddDetail(invoiceId, detail.ItemName, detail.Qtty, detail.UnitPrice, detail.Amount, detail.Observations);
}
//INSERT
if (detail.Status == 2)
{
bLInvoiceDetail.UpdateDetail(invoiceId, detail.InvoiceDetailId, detail.ItemName, detail.Qtty, detail.UnitPrice, detail.Amount, detail.Observations);
}
//UPDATE
if (detail.Status == 3)
{
bLInvoiceDetail.DeleteDetail(invoiceId, detail.InvoiceDetailId);
}
}
}
}
public void UpdateInvoiceDetail(InvoiceDetailModel invoiceDetailModel)
{
var invoiceDetail = _shoppingContext.InvoiceDetails.Find(invoiceDetailModel.Id);
if (invoiceDetail == null)
{
return;
}
invoiceDetail = Mapper.Map <InvoiceDetail>(invoiceDetailModel);
_shoppingContext.InvoiceDetails.AddOrUpdate(invoiceDetail);
_shoppingContext.SaveChanges();
}
private void DGVInvoices_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
InvoiceForm invoiceForm = new InvoiceForm();
invoiceForm.Show();
this.Hide();
int index = e.RowIndex;
DataGridViewRow selectedRow = dGVInvoices.Rows[index];
invoiceForm.UserId = Convert.ToInt32(selectedRow.Cells[1].Value);
invoiceForm.txtBoxInvoiceNumber.Text = selectedRow.Cells[1].Value.ToString();
invoiceForm.txtBoxObservations.Text = selectedRow.Cells[6].Value.ToString();
invoiceForm.comboBoxClient.SelectedItem = selectedRow.Cells[3].Value.ToString();
invoiceForm.comboBoxClientAddress.Text = selectedRow.Cells[4].Value.ToString();
invoiceForm.dateInvoiceDate.Value = Convert.ToDateTime(selectedRow.Cells[4].Value);
DATotCeFolosescLaInvoice detalii = new DATotCeFolosescLaInvoice();
DataTable dt = new DataTable();
dt = detalii.getInvoiceDetails(Convert.ToInt32(selectedRow.Cells[0].Value));
for (int i = 0; i < dt.Rows.Count; i++)
{
InvoiceDetailModel invoicemode = new InvoiceDetailModel();
invoicemode.InvoiceId = Convert.ToInt32(dt.Rows[i]["InvoiceId"].ToString());
invoicemode.InvoiceDetailId = Convert.ToInt32(dt.Rows[i]["InvoiceDetailId"].ToString());
invoicemode.Item = new ItemModel
{
ItemName = dt.Rows[i]["Item"].ToString()
};
invoicemode.Qtty = Convert.ToDecimal(dt.Rows[i]["Qtty"].ToString());
invoicemode.Price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString());
invoicemode.Amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());
invoicemode.Observations = dt.Rows[i]["Observations"].ToString();
//invoiceForm.lista.Add(invoicemode);
}
invoiceForm.dGVInvoiceDetails.DataSource = detalii.getInvoiceDetails(Convert.ToInt32(selectedRow.Cells[0].Value));
invoiceForm.dGVInvoiceDetails.Columns["InvoiceDetailId"].Visible = false;
invoiceForm.dGVInvoiceDetails.Columns["InvoiceId"].Visible = false;
invoiceForm.dGVInvoiceDetails.Columns["Item"].HeaderText = "Item";
invoiceForm.dGVInvoiceDetails.Columns["Qtty"].HeaderText = "Cantitate";
invoiceForm.dGVInvoiceDetails.Columns["Price"].HeaderText = "Pret";
invoiceForm.dGVInvoiceDetails.Columns["Amount"].HeaderText = "Amount";
invoiceForm.dGVInvoiceDetails.Columns["Observations"].HeaderText = "Observatii";
invoiceForm.FormClosed += ClientDetail_Form_Closed;
}