// Recept Log out
public PartialViewResult LoadReceiptForm()
{
var blInvoice = new BLInvoice();
//var invoice = blInvoice.GetInvoiceFullInfoByUserId(CurrentUserId, true);
//invoice.TransactionNo = "12355787";
//invoice.Received = DateTime.Now.Date.ToShortDateString();
var invoice = blInvoice.GetInvoiceByUserId(CurrentUserId, false);
if (invoice != null)
{
int?lastOrderId = 0;
var blShopCart = new BLShopCart();
var lastOrderInfo = blShopCart.GetCheckoutStatus(CurrentUserId, invoice.Id, out lastOrderId);
if (lastOrderInfo != null)
{
blInvoice.UpdateInvoiceOrderStatus(lastOrderInfo, invoice.Id, true, lastOrderId.Value, true, true);
invoice = blInvoice.GetInvoiceFullInfoById(invoice.Id);
invoice.Received = lastOrderInfo.Order.Received;
invoice.TransactionNo = lastOrderInfo.Order.Tx;
return(PartialView("LastReceiptForm", invoice));
}
}
return(PartialView("LastReceiptForm", invoice));
}
private void Btn_printInvoices_Click(object sender, EventArgs e)
{
string clientname12 = "";
BLInvoice blinvoice = new BLInvoice();
DataTable dt = new DataTable();
List <InvoiceModel> lista = new List <InvoiceModel>();
if (cmbBoxClient.SelectedValue == null)
{
clientname12 = "";
}
else
{
clientname12 = cmbBoxClient.SelectedItem.ToString();
}
lista = blinvoice.getallinvoices(txtBoxFilterInvoiceNumber.Text, dTPStartFrom.Value.Date, dTPEndAt.Value.Date,
clientname12, checkBoxStartedAt.Checked, checkBoxEndTo.Checked);
var source = new BindingSource(lista, null);
dGVInvoices.DataSource = source;
dGVInvoices.Columns["InvoiceId"].Visible = false;
dGVInvoices.Columns["ClientAddressId"].Visible = false;
dGVInvoices.Columns["ClientId"].Visible = false;
dGVInvoices.Columns["InvoiceNumber"].HeaderText = "Numar factura";
dGVInvoices.Columns["InvoiceDate"].HeaderText = "Data factura";
dGVInvoices.Columns["ClientName"].HeaderText = "Nume Client";
dGVInvoices.Columns["ClientSurname"].HeaderText = "Prenume Client";
dGVInvoices.Columns["Address"].HeaderText = "Adresa";
dGVInvoices.Columns["Obesrvations"].HeaderText = "Observatii";
}
public void LoadChart()
{
BS_Layer.BLInvoice bl = new BLInvoice();
var dt = new DataTable();
dt.Clear();
DataSet ds = bl.Chart();
dt = ds.Tables[0];
var Month = DateTime.Now.Month;
for (int i = 4; i >= 0; i--)
{
var temp = dt.Rows[i].ItemArray[1];
if (temp.ToString() != "")
{
Chart_TotalRevenue.Series["Revenue"].Points.Add(Convert.ToDouble(dt.Rows[i].ItemArray[1]));
}
else
{
Chart_TotalRevenue.Series["Revenue"].Points.Add(0);
}
Chart_TotalRevenue.Series["Revenue"].Points[Math.Abs(i - 4)].Label = "Month " + (Month - i).ToString();
Chart_TotalRevenue.Series["Revenue"].Points[Math.Abs(i - 4)].Color = Color.Blue;
Chart_TotalRevenue.Series["Revenue"].Points[Math.Abs(i - 4)].AxisLabel = "Month " + (Month - i).ToString();
}
}
private void BtnFilter_Click(object sender, EventArgs e)
{
DateTime startDate;
DateTime endDate;
if (checkedStartDate)
{
startDate = dateTimePickerStartDate.Value;
}
else
{
startDate = Convert.ToDateTime("01/01/1980");
}
if (checkedFinishDate)
{
endDate = dateTimePickerFinishDate.Value;
}
else
{
endDate = Convert.ToDateTime("01/01/3000");
}
BLInvoice bliv = new BLInvoice();
BindingList <InvoiceModel> listInvoice = bliv.BLGetInvoice(null, startDate, endDate, txtNrInvoice.Text, comboBoxFilterClientName.Text);
dataGridViewInvoice.Rows.Clear();
foreach (InvoiceModel invoice in listInvoice)
{
dataGridViewInvoice.Rows.Add(invoice.invoiceId, invoice.invoiceNumber, invoice.invoiceDate, invoice.clientId, invoice.clientName, invoice.clientAddressId, invoice.clientAddress, invoice.userId, invoice.observations, invoice.status);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Invoice currentInvoice = BLInvoice.GetInvoiceById(APCContext, id);
if (currentInvoice != null)
{
APCContext.DeleteObject(currentInvoice);
APCContext.SaveChanges();
DeleteInvoicePO(currentInvoice);
deleteInvoice_Product(currentInvoice);
MessageBox.Show("Delete Successfully");
ClearContent();
}
else
{
MessageBox.Show("Invoice Id not found");
}
}
else
{
MessageBox.Show("Invoice Id not found");
}
}
//Invoice List
public ActionResult LoadReceiptList()
{
var blInvoice = new BLInvoice();
var invoice = blInvoice.GetInvoiceByUserId(CurrentUserId, false);
if (invoice != null)
{
int?lastOrderId = 0;
var blShopCart = new BLShopCart();
var lastOrderInfo = blShopCart.GetCheckoutStatus(CurrentUserId, invoice.Id, out lastOrderId);
if (lastOrderInfo != null)
{
//Update all data in one transaction
blInvoice.UpdateInvoiceOrderStatus(lastOrderInfo, invoice.Id, true, lastOrderId.Value, true, true);
invoice.Received = lastOrderInfo.Order.Received;
invoice.TransactionNo = lastOrderInfo.Order.Tx;
}
}
var invoiceIdList = blInvoice.GetInvoiceFullInfoByUserAndStatus(CurrentUserId, true);
if (invoiceIdList != null)
{
return(View("LastReceiptList", invoiceIdList));
}
return(PartialView("_EmptyReviewOrder", new VMHandleErrorInfo
{
ErrorMessage = "There is no receipt."
}));
}
public PartialViewResult LoadExtraMemberInvoiceForm()
{
var blInvoice = new BLInvoice();
var invoice = blInvoice.GetInvoiceByUserId(CurrentUserId, false);
if (invoice != null)
{
int?lastOrderId = 0;
var blShopCart = new BLShopCart();
var lastOrderInfo = blShopCart.GetCheckoutStatus(CurrentUserId, invoice.Id, out lastOrderId);
if (lastOrderInfo != null)
{
blInvoice.UpdateInvoiceOrderStatus(lastOrderInfo, invoice.Id, true, lastOrderId.Value, true, true);
}
}
var invoiceList = blInvoice.GetExtraMemberInvoiceFullInfoByUserId(CurrentUserId);
if (invoiceList == null)
{
return(PartialView("_EmptyReviewOrder", new VMHandleErrorInfo
{
ErrorMessage = "There is no balance to pay for extra members."
}));
}
return(PartialView("ExtraMemberReviewOrderManagement", invoiceList));
}
public void SaveInvoice()
{
if (invoiceIdSelected == 0)
{
LoginForm lf = new LoginForm();
BLInvoice bl = new BLInvoice();
invoiceIdSelected = bl.BLInsertInvoice(txtNrInvoice.Text, dateTimePickerInvoiceDate.Value, comboBoxClientName.Text,
comboBoxClientAddress.Text, LoginForm.id, txtObs.Text);
foreach (InvoiceDetailModel detail in listDetail)
{
detail.invoiceId = invoiceIdSelected;
}
BLInvoiceDetail bli = new BLInvoiceDetail();
bli.BLPrepareInvoiceDetail(listDetail);
MessageBox.Show("Factura a fost adaugata cu succes", "Succes", MessageBoxButtons.OK, MessageBoxIcon.None);
}
else
{
BLInvoice bl = new BLInvoice();
bl.BLUpdateInvoice(invoiceIdSelected, txtNrInvoice.Text, dateTimePickerInvoiceDate.Value, txtObs.Text, comboBoxClientName.Text, comboBoxClientAddress.Text);
BLInvoiceDetail bli = new BLInvoiceDetail();
bli.BLPrepareInvoiceDetail(listDetail);
MessageBox.Show("Factura a fost modificata cu succes", "Succes", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
public ActionResult UpdatePayStatusTeamFullInfoManagement()
{
var blInvoice = new BLInvoice();
var invoiceList = blInvoice.GetInvoiceIds(false);
if (invoiceList != null)
{
foreach (var invoiceId in invoiceList.Ids)
{
int?lastOrderId = 0;
var blShopCart = new BLShopCart();
var lastOrderInfo = blShopCart.GetCheckoutStatus(invoiceId, out lastOrderId);
if (lastOrderInfo != null)
{
//Update all data in one transaction
blInvoice.UpdateInvoiceOrderStatus(lastOrderInfo, invoiceId, true, lastOrderId.Value, true, true);
}
}
}
return(View("TeamFullInfoManagement", new VmTeamFullInfoManagement()));
}
private void btnSearch_Click(object sender, EventArgs e)
{
DateTime startDate = calStartDueDate.Value;
DateTime endDate = calEndDueDate.Value;
List <Invoice> invoiceList = BLInvoice.GetInvoiceByDate(APCContext, startDate, endDate, cbPaid.Checked);
dgPaymentFromCustomer.DataSource = convertListToDataTable(invoiceList);
}
private void btn_Delete_Invoice_Click(object sender, EventArgs e)
{
BLInvoice blI = new BLInvoice();
blI.DeleteInvoice(txt_Invoice_InvoiceID.Text);
dgv_Invoice.DataSource = blI.LoadInvoice();
dgv_Invoice_CellClick(null, null);
}
//public invoicedetailform(int _id, int _userid)
//{
// initializecomponent();
// userid = _userid;
// invoiceid = _id;
// blclient blclient = new blclient();
// cmbclientfullname.datasource = blclient.getclientfullname(0);
// cmbclientfullname.displaymember = "clientfullname";
//}
public InvoiceDetailForm(int _id, int _userId)
{
InitializeComponent();
//userId = _userId;
invoiceId = _id;
userId = _userId;
BLInvoice bLInvoice = new BLInvoice();
List <DisplayInvoiceModel> list = bLInvoice.GetDisplayInvoice(invoiceId, "", DateTime.Now, DateTime.Now, "");
DisplayInvoiceModel displayInvoiceModel = new DisplayInvoiceModel();
if (list.Count > 0)
{
displayInvoiceModel = list[0];
}
//txtAddress.Text = displayInvoiceModel.Address;
//txtClientFullName.Text = displayInvoiceModel.ClientFullName;
txtInvoiceNumber.Text = displayInvoiceModel.InvoiceNumber;
dateInvoice.Value = (displayInvoiceModel.InvoiceDate == DateTime.Parse("1/1/0001 12:00:00 AM")) ? DateTime.Now : displayInvoiceModel.InvoiceDate;
BLClient bLClient = new BLClient();
List <ClientFullNameModel> clients = bLClient.GetClientFullName(0);
cmbClientFullName.DataSource = clients;
ClientFullNameModel clientFullName = bLClient.GetClientFullName(displayInvoiceModel.ClientId)[0];
//int index = clients.IndexOf(clientFullName);
int index = clients.FindIndex(a => a.ClientId == clientFullName.ClientId);
cmbClientFullName.SelectedIndex = index;
//MessageBox.Show(cmbClientFullName.SelectedIndex.ToString());
//cmbClientFullName.
//MessageBox.Show(cmbClientFullName.SelectedItem.ClientId);
//cmbClientFullName.
cmbClientFullName.DisplayMember = "ClientFullName";
//cmbClientFullName.DisplayMember = "ClientSurname";
//txtInvoiceDate.Text = displayInvoiceModel.InvoiceDate.Year.ToString()+"-"+ displayInvoiceModel.InvoiceDate.Month.ToString()+"-"+ displayInvoiceModel.InvoiceDate.Day.ToString();
txtObservations.Text = displayInvoiceModel.Observations;
BLInvoiceDetail bLInvoiceDetail = new BLInvoiceDetail();
dataGridDetails.DataSource = bLInvoiceDetail.GetInvoiceDetail(invoiceId);
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 LoadView()
{
var dt = new DataTable();
BS_Layer.BLInvoice bl = new BLInvoice();
DataSet ds = bl.ListOfInvoicesHasPaid();
dt = ds.Tables[0];
Analysis_DataGridView.DataSource = dt;
}
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 setId(int invoiceId, APCEntities APCContext1)
{
APCContext = APCContext1;
DataTable dtPaymentFromCustomer = BLInvoice.GetInvoiceById(invoiceId);
if (dtPaymentFromCustomer.Rows.Count > 0)
{
DataRow invoiceRow = dtPaymentFromCustomer.Rows[0];
//int invoiceId = int.Parse(invoiceRow["Id"].ToString());
tbInvoiceId.Text = invoiceRow["Id"].ToString();
tbPaymentDue.Text = ((decimal.Parse(invoiceRow["TotalDue"].ToString())) - TotalPaid(invoiceId)).ToString("N");
}
}
private void ComboBoxItem_DropDown(object sender, EventArgs e)
{
BLInvoice blItem = new BLInvoice();
List <ItemModel> lista = new List <ItemModel>();
lista = blItem.getItems();
var source = new BindingSource(lista, null);
comboBoxItem.ValueMember = "ClientId";
comboBoxItem.DisplayMember = "Fullname";
comboBoxItem.DataSource = source;
}
private void btn_Calculate_Click(object sender, EventArgs e)
{
BLInvoice blI = new BLInvoice();
if (cmb_Month.Text == "None")
{
rtxt_Total.Text = "Total revenues in " + cmb_Year.Text + " is: " + blI.CalculateRevenue(cmb_Month.Text, cmb_Year.Text) + "$";
}
else
{
rtxt_Total.Text = "Total revenues in " + cmb_Month.Text + ", " + cmb_Year.Text + " is: " + blI.CalculateRevenue(cmb_Month.Text, cmb_Year.Text) + "$";
}
}
public PartialViewResult LoadInvoiceForm()
{
var blInvoice = new BLInvoice();
var invoice = blInvoice.GetInvoiceByUserId(CurrentUserId, false);
if (invoice != null)
{
int?lastOrderId = 0;
var blShopCart = new BLShopCart();
var lastOrderInfo = blShopCart.GetCheckoutStatus(CurrentUserId, invoice.Id, out lastOrderId);
if (lastOrderInfo != null)
{
blInvoice.UpdateInvoiceOrderStatus(lastOrderInfo, invoice.Id, true, lastOrderId.Value, true, true);
invoice = blInvoice.GetInvoiceFullInfoByUserId(CurrentUserId, false);
}
}
var invoiceList = blInvoice.GetInvoiceFullInfoByUserId(CurrentUserId, false);
if (invoiceList == null)
{
return(PartialView("_EmptyReviewOrder", new VMHandleErrorInfo
{
ErrorMessage = "There are no team(s) to pay." +
"Please, complete all team member(s) registration forms before you could proceed to payment"
}));
}
List <VmTeamSelection> teamSelectionList = new List <VmTeamSelection>();
foreach (var item in invoiceList.InvoiceDetails)
{
teamSelectionList.Add(new VmTeamSelection
{
Checked = item.IsChecked,
IsFirstTeam = item.IsFirstTeam,
TeamId = item.TeamId
});
}
blInvoice.ProcessInvoice(CurrentUserId, invoiceList.LastCheckedId, teamSelectionList);
invoiceList = blInvoice.GetInvoiceFullInfoByUserId(CurrentUserId, false);
return(PartialView("ReviewOrderManagement", invoiceList));
}
public void InvoicePopulateForm(DateTime date)
{
BLInvoice bl = new BLInvoice();
BindingList <InvoiceModel> list = bl.BLGetInvoice(invoiceIdSelected, date, date, "", "");
foreach (InvoiceModel invoice in list)
{
txtNrInvoice.Text = invoice.invoiceNumber;
dateTimePickerInvoiceDate.Value = invoice.invoiceDate;
comboBoxClientName.Text = invoice.clientName;
comboBoxClientAddress.Text = invoice.clientAddress;
txtObs.Text = invoice.observations;
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
decimal paymentDue = 0;
if (decimal.TryParse(tbPaymentDue.Text, out paymentDue))
{
if (calDueDate.Value != null)
{
//if (ddlPO.SelectedValue != null)
//{
if (ddlProject.SelectedValue != null)
{
Project selectedProject = BLProject.GetProjectById(APCContext, int.Parse(ddlProject.SelectedValue.ToString()));
bool success = false;
Invoice selectedInvoice = BLInvoice.insertInvoice(APCContext, DateTime.Today, paymentDue, calDueDate.Value, tbScannedDoc.Text, selectedProject);
if (InsertInvoicePO(selectedInvoice))
{
insertInvoice_Product(selectedInvoice);
success = true;
}
if (success == true)
{
MessageBox.Show("Invoice Successfully Added");
ClearContent();
}
else
{
MessageBox.Show("Please check your input");
}
}
else
{
MessageBox.Show("Please select the associated Project Number");
}
//}
//else
// MessageBox.Show("Please select the associated PO Number");
}
else
{
MessageBox.Show("Please specify Due Date");
}
}
else
{
MessageBox.Show("Please specify correct amount of Payment Due");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Invoice invoice = BLInvoice.GetInvoiceListById(APCContext,int.Parse(tbInvoiceId.Text));
BLPaymentFromClient.insertPaymentFromClient(APCContext,invoice,decimal.Parse(tbPaymentAmount.Text), calPaidDate.Value);
//check if payment has been made full - if yes then can mark as paid.
if (invoice.TotalDue <= TotalPaid(invoice.Id))
{
invoice.Paid = true;
invoice.DatePaid = DateTime.Now;
APCContext.SaveChanges();
}
MessageBox.Show("Payment has been recorded");
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (dataGridViewInvoice.Rows.Count != 0)
{
int i = dataGridViewInvoice.SelectedCells[0].RowIndex;
int selectedId = Convert.ToInt32(dataGridViewInvoice.Rows[i].Cells[0].Value.ToString());
dataGridViewInvoice.Rows.RemoveAt(i);
BLInvoice bl = new BLInvoice();
bl.BLDeleteInvoice(selectedId);
}
else
{
MessageBox.Show("Nu se poate sterge nicio factura deoarece nu exista niciuna", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private bool InsertInvoicePO(Invoice selectedInvoice)
{
bool success = true;
DataTable dtPO = (DataTable)dgPO.DataSource;
if (dtPO != null)
{
for (int i = 0; i < dtPO.Rows.Count; i++)
{
PO selectedPO = BLPO.GetPOById(APCContext, int.Parse(dtPO.Rows[i]["POId"].ToString()));
if (!BLInvoice.insertInvoicePO(APCContext, selectedInvoice, selectedPO))
{
success = false;
}
}
}
return(success);
}
private bool DeleteInvoicePO(Invoice selectedInvoice)
{
bool success = true;
List <Invoice_PO> invoicePOList = BLInvoice.GetListInvoicePOByInvoiceId(APCContext, selectedInvoice.Id);
if (invoicePOList != null)
{
for (int i = 0; i < invoicePOList.Count; i++)
{
PO selectedPO = invoicePOList[i].PO;
selectedPO.Invoiced = false;
Invoice_PO currentInvoicePO = BLInvoice.GetInvoicePOByInvoiceIdAndPOId(APCContext, selectedInvoice.Id, selectedPO.Id);
APCContext.DeleteObject(currentInvoicePO);
APCContext.SaveChanges();
}
}
return(success);
}
private void InvoiceForm_Load(object sender, EventArgs e)
{
BLClient bl = new BLClient();
BindingList <ClientModel> listClients = bl.GetClientBi("", "", "", null, null, null);
foreach (ClientModel client in listClients)
{
comboBoxFilterClientName.Items.Add(client.ClientName + ' ' + client.ClientSurname);
}
this.dateTimePickerStartDate.CustomFormat = " ";
this.dateTimePickerStartDate.Format = DateTimePickerFormat.Custom;
this.dateTimePickerFinishDate.CustomFormat = " ";
this.dateTimePickerFinishDate.Format = DateTimePickerFormat.Custom;
dateTimePickerStartDate.ValueChanged += DateTimePickerStartDate_ValueChanged;
dateTimePickerStartDate.ShowCheckBox = true;
dateTimePickerFinishDate.ValueChanged += DateTimePickerFinishDate_ValueChanged;
dateTimePickerFinishDate.ShowCheckBox = true;
dataGridViewInvoice.Columns.Add("invoiceId", "invoiceId");
dataGridViewInvoice.Columns.Add("invoiceNumber", "Numar Factura");
dataGridViewInvoice.Columns.Add("invoiceDate", "Data Factura");
dataGridViewInvoice.Columns.Add("clientId", "clientId");
dataGridViewInvoice.Columns.Add("clientName", "Nume Client");
dataGridViewInvoice.Columns.Add("clientAddressId", "clientAddressId");
dataGridViewInvoice.Columns.Add("clientAddress", "Adresa Client");
dataGridViewInvoice.Columns.Add("userId", "userId");
dataGridViewInvoice.Columns.Add("invoiceObs", "Observatii");
dataGridViewInvoice.Columns.Add("invoiceStatus", "invoiceStatus");
dataGridViewInvoice.AutoGenerateColumns = false;
dataGridViewInvoice.Columns[0].Visible = false;
dataGridViewInvoice.Columns[3].Visible = false;
dataGridViewInvoice.Columns[5].Visible = false;
dataGridViewInvoice.Columns[7].Visible = false;
dataGridViewInvoice.Columns[9].Visible = false;
BLInvoice bliv = new BLInvoice();
BindingList <InvoiceModel> listInvoice = bliv.BLGetInvoice(null, Convert.ToDateTime("01/01/1980"), Convert.ToDateTime("01/01/3000"), txtNrInvoice.Text, comboBoxFilterClientName.Text);
foreach (InvoiceModel invoice in listInvoice)
{
dataGridViewInvoice.Rows.Add(invoice.invoiceId, invoice.invoiceNumber, invoice.invoiceDate, invoice.clientId, invoice.clientName, invoice.clientAddressId, invoice.clientAddress, invoice.userId, invoice.observations, invoice.status);
}
}
private void btn_Invoice_Click(object sender, EventArgs e)
{
TabControl_Main.TabPages.Clear();
TabControl_Main.TabPages.Add(TabPage_Invoice);
dgv_Invoice.AutoResizeColumns();
BLInvoice dbI = new BLInvoice();
var data = dbI.LoadInvoice();
if (data != null)
{
dgv_Invoice.DataSource = data;
}
else
{
dgv_Invoice.DataSource = null;
}
dgv_Invoice_CellClick(null, null);
txt_Invoice_InvoiceID.Enabled = false;
}
private void btn_Save_Invoice_Click(object sender, EventArgs e)
{
BLInvoice blI = new BLInvoice();
//if (SaveStatus == 1)
//{
// blI.Checkin(txt_Invoice_CustomerID.Text, txt_Invoice_RoomID.Text, txt_Invoice_NumberOfDay.Text, txt_Invoice_EmployeeID.Text, txt_Invoice_InvoiceTotal.Text, txt_Invoice_CheckInDate.Text, txt_Invoice_CheckOutDate.Text, checkBox_CheckInvoice.Checked);
//}
//else if (SaveStatus == 2)
//{
// blI.UpdateInvoice(txt_Invoice_InvoiceID.Text, txt_Invoice_CustomerID.Text, txt_Invoice_RoomID.Text, txt_Invoice_NumberOfDay.Text, txt_Invoice_EmployeeID.Text, txt_Invoice_InvoiceTotal.Text, txt_Invoice_CheckInDate.Text, txt_Invoice_CheckOutDate.Text, checkBox_CheckInvoice.Checked);
//}
//SaveStatus = 0;
blI.UpdateInvoice(txt_Invoice_InvoiceID.Text, txt_Invoice_CustomerID.Text, txt_Invoice_RoomID.Text, txt_Invoice_EmployeeID.Text, txt_Invoice_InvoiceTotal.Text, txt_Invoice_CheckInDate.Text, txt_Invoice_CheckOutDate.Text, checkBox_HasPaid.Checked);
dgv_Invoice.DataSource = blI.LoadInvoice();
dgv_Invoice_CellClick(null, null);
btn_Update_Invoice.Enabled = true;
btn_Save_Invoice.Enabled = false;
}
private void BtnGetInvoice_Click(object sender, EventArgs e)
{
lblMessage.Text = "Selectati o factura pentru a sterge sau modifica";
string clientName = txtClientName.Text;
DateTime dateFrom = dateTimeFrom.Value;
DateTime dateTo = dateTimeTo.Value;
//MessageBox.Show(DateTime.Now.ToString());
string invoiceNumber = txtInvoiceNumber.Text;
BLInvoice bLInvoice = new BLInvoice();
List <DisplayInvoiceModel> list = bLInvoice.GetDisplayInvoice(-1, clientName, dateFrom, dateTo, invoiceNumber);
//dataGridInvoice.Columns["ClientId"].Visible = false;
if (list.Count == 0)
{
MessageBox.Show("Nu sunt inregistrari cu parametrii introdusi!!!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
dataGridInvoice.DataSource = list;
dataGridInvoice.Columns["ClientId"].Visible = false;
dataGridInvoice.Columns["InvoiceId"].Visible = false;
dataGridInvoice.Columns["InvoiceNumber"].HeaderText = "Numar Factura";
dataGridInvoice.Columns["InvoiceDate"].HeaderText = "Data Factura";
dataGridInvoice.Columns["ClientFullName"].HeaderText = "Nume Client";
dataGridInvoice.Columns["Address"].HeaderText = "Adresa";
dataGridInvoice.Columns["Observations"].HeaderText = "Observatii";
dataGridInvoice.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridInvoice.RowHeaderMouseDoubleClick += DataGridInvoice_RowHeaderMouseDoubleClick;
//dataGridInvoice.RowHeaderMouseDoubleClick += DataGridClient_RowHeaderMouseDoubleClick;
//dataGridClient.RowHeaderMouseClick += DataGridClient_RowHeaderMouseClick;
//dataGridClient.SelectedRows[0].Cells[0].Value;
//dataGridClient.Columns.GetFirstColumn.Hide();
}
//Invoice Menu
public PartialViewResult LoadReceiptDetail(int id)
{
var blInvoice = new BLInvoice();
var invoice = blInvoice.GetInvoiceFullInfoById(id);
if (invoice == null)
{
return(PartialView("_EmptyReviewOrder", new VMHandleErrorInfo
{
ErrorMessage = "In order to see the detail of your receipt, " +
"please complete all team member(s) registration forms."
}));
}
var blOrder = new BLOrder();
var completeOrderInfo = blOrder.GetCompleteOrder(CurrentUserId, id);
invoice.Received = completeOrderInfo.Received.Value.ToShortDateString();
invoice.TransactionNo = completeOrderInfo.TransactionNo;
return(PartialView("LastReceiptForm", invoice));
}
public ActionResult ProcessInvoice(int currentTeamId, List <VmTeamSelection> teamSelectionList)
{
var blInvoice = new BLInvoice();
var finishedInvoice = blInvoice.GetInvoiceByUserId(CurrentUserId, true);
// if (finishedInvoice == null && teamSelectionList.Count(t => t.Checked == true) > 0 && teamSelectionList.Count(t => t.IsFirstTeam == true) != 1)
if (blInvoice.GetPayedTeamCount(CurrentUserId) == 0 && teamSelectionList.Count(t => t.Checked == true) > 0 && teamSelectionList.Count(t => t.IsFirstTeam == true) != 1)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new
{
hasError = true,
message = "One team must be as a first team",
}, JsonRequestBehavior.DenyGet));
}
blInvoice.ProcessInvoice(CurrentUserId, currentTeamId, teamSelectionList);
var invoice = blInvoice.GetInvoiceFullInfoByUserId(CurrentUserId, false);
invoice.LastCheckedId = currentTeamId;
return(PartialView("~/Views/Invoice/_ReviewOrder.cshtml", invoice));
}
