private void dataGridView2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView2.Columns[e.ColumnIndex].Name == "Delete")
{
DialogResult myResult;
myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
_entities = new KBBQEntities();
var cellId = Convert.ToInt32(dataGridView2.CurrentRow.Cells[0].Value);
updateClass = new clsUpdate();
updateClass.updateBillAndSettlement(cellId.ToString(), "CANCELLED", "", 0);
_entities = new KBBQEntities();
var data = _entities.DailySales.Where(x => x.KOT == cellId.ToString()).ToList();
foreach (var item in data)
{
_entities.DailySales.Remove(item);
_entities.SaveChanges();
}
bindGridViewForPageLoad();
}
}
}
private void textBox1_Leave(object sender, EventArgs e)
{
try
{
if (txtCode.Text != string.Empty)
{
_entities = new KBBQEntities();
var coupCode = _entities.billAndSettlements.ToList();
foreach (var item in coupCode)
{
if (item.couponCode != null)
{
var avail = item.couponCode.Trim().ToString();
if (avail == txtCode.Text.Trim().ToString())
{
MessageBox.Show("Coupon Code already existed.", "Error - King Bar beque Restaurant Coupon Code", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCode.Focus();
return;
}
else
{
}
}
}
}
}
catch (Exception x)
{
}
}
void dataGridBind()
{
try
{
_entities = new KBBQEntities();
var data = _entities.billAndSettlements.Where(x => x.mode == "PAID").ToList();
List <billAndSettlementVM> modelList = new List <billAndSettlementVM>();
int row = 1;
foreach (var item in data)
{
billAndSettlementVM model = new billAndSettlementVM();
model.rowNo = row;
model.kot = _entities.detailsSettlements.Where(x => x.KOT == item.kot).FirstOrDefault().receiptno;
model.orderDecrip = item.orderDecrip;
model.ordDate = item.ordDate.ToString("dd-MMM-yyyy");
model.tax1_Amt = item.tax1_Amt;
model.tax2_Amt = item.tax2_Amt;
row++;
modelList.Add(model);
}
dataGridView2.DataSource = modelList;
}
catch (Exception x)
{
}
}
private void dataGridbind()
{
try
{
_entities = new KBBQEntities();
List <ProductTypeVM> modelList = new List <ProductTypeVM>();
var data = _entities.tblProTypes.OrderBy(x => x.proSubCate).ToList();
int rowNo = 1;
foreach (var item in data)
{
ProductTypeVM model = new ProductTypeVM();
model.prodTypeName = item.prodTypeName;
model.proSubCate = item.proSubCate;
model.proTypeID = item.proTypeID;
model.rowNo = rowNo;
modelList.Add(model);
rowNo++;
}
lblTotalRecord.Text = modelList.Count.ToString();
dataGridView1.DataSource = modelList;
}
catch (Exception x)
{
}
}
private void dgPurchaseOrderDetails_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgPurchaseOrderDetails.CurrentRow.Index != -1 && dgPurchaseOrderDetails.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dgPurchaseOrderDetails.CurrentRow.Cells[0].Value);
_entities = new KBBQEntities();
var seeData = _entities.tblPurchaseOrders.Where(x => x.id == lID).FirstOrDefault();
if (seeData != null)
{
var pName = _entities.purchaseProducts.Where(x => x.id == seeData.productId).FirstOrDefault().pName;
txtitemName.Text = pName.Trim().ToString();
txtQty.Text = seeData.qty.ToString();
txtWeight.Text = seeData.weight.ToString();
comboUnit.Text = seeData.unit;
passedId = seeData.id;
btnCreate.Text = "Update";
}
else
{
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void dgvExpenses_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvExpenses.CurrentRow.Index != -1 && dgvExpenses.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dgvExpenses.CurrentRow.Cells[0].Value);
_entities = new KBBQEntities();
var seeData = _entities.tblExpenses.Where(x => x.id == lID).FirstOrDefault();
if (seeData != null)
{
txtExpName.Text = seeData.expName.Trim().ToString();
txtExpBy.Text = seeData.expBy.Trim().ToString();
txtAmt.Text = seeData.amount.ToString();
dtpExpDate.Text = seeData.expDate.ToString();
passedId = seeData.id;
btnCreate.Text = "Update";
}
else
{
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dataGridView1.CurrentRow.Index != -1 && dataGridView1.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
_entities = new KBBQEntities();
var seeData = _entities.tblProTypes.Where(x => x.proTypeID == lID).FirstOrDefault();
if (seeData != null)
{
txtCategory.Text = seeData.proSubCate.Trim().ToString();
cboProductTypeName.Text = seeData.prodTypeName.Trim().ToString();
passedId = seeData.proTypeID;
btnSave.Text = "Update";
}
else
{
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void frmViewOrderInfo_Load(object sender, EventArgs e)
{
try
{
// viewClass.viewOrderInfo(dataGridView1);
//dateFrom.Format = DateTimePickerFormat.Custom;
//dateFrom.CustomFormat = "dd-MM-yyyy";
//dateTo.Format = DateTimePickerFormat.Custom;
//dateTo.CustomFormat = "dd-MM-yyyy";
dataGridView1.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
var data = _entities.tblOrderInfoes.OrderBy(x => x.id).ToList();
if (data != null)
{
foreach (var item in data)
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = item.KOT;
model.orderType = item.orderType;
model.tableNo = item.tableNo;
model.ordDate = item.ordDate;
model.ordTime = item.ordTime;
model.guests = item.fname + " " + item.lname;
model.adultNo = item.adultNo;
model.childrenNo = item.childrenNo;
model.mode = _entities.billAndSettlements.Where(x => x.kot == item.KOT).FirstOrDefault().mode;
var empName = _entities.tblEmployees.Where(x => x.empID == item.empID).FirstOrDefault();
if (empName != null)
{
model.empName = empName.fname;
}
modelList.Add(model);
}
dataGridView1.DataSource = modelList;
foreach (DataGridViewColumn item in dataGridView1.Columns)
{
dataGridView1.Sort(dataGridView1.Columns[item.Name], System.ComponentModel.ListSortDirection.Ascending);
}
}
}
catch (Exception x)
{
}
}
private void txtitemName_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (txtitemName.Text != string.Empty)
{
dgPurchaseOrderDetails.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new KBBQEntities();
List <PurchaseOrderVM> modelList = new List <PurchaseOrderVM>();
var pId = _entities.purchaseProducts.Where(x => x.pName.Contains(txtitemName.Text.ToString())).FirstOrDefault();
if (pId != null)
{
var categoryData = _entities.tblPurchaseOrders.Where(x => x.productId == pId.id).ToList();
foreach (var item in categoryData)
{
PurchaseOrderVM model = new PurchaseOrderVM();
model.rowNo = rowNo;
model.id = item.id;
var productName = _entities.purchaseProducts.Where(x => x.id == item.productId).FirstOrDefault().pName;
model.pName = productName;
model.qty = item.qty;
model.weight = item.weight + " " + item.unit;
model.date = item.date.ToString();
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt");
if (item.udate == null)
{
model.udate = "--";
}
else
{
model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
}
dgPurchaseOrderDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
//DateTime fromdate = DateTime.ParseExact(dateFrom.Text, "dd-MM-yyyy", null);
//DateTime todate = DateTime.ParseExact(dateTo.Text, "dd-MM-yyyy", null);
viewClass.viewOrderInfoByDates(dataGridView1, Convert.ToDateTime(dateFrom.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(dateTo.Text).ToString("yyyy-MM-dd"));
dataGridView1.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
DateTime fromDate = Convert.ToDateTime(dateFrom.Text);
DateTime toDate = Convert.ToDateTime(dateTo.Text);
var data = _entities.tblOrderInfoes.Where(x => x.ordDate >= fromDate && x.ordDate <= toDate).OrderBy(x => x.KOT).ToList();
if (data != null)
{
foreach (var item in data)
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = item.KOT;
model.orderType = item.orderType;
model.tableNo = item.tableNo;
model.ordDate = item.ordDate;
model.ordTime = item.ordTime;
model.guests = item.fname + " " + item.lname;
model.adultNo = item.adultNo;
model.childrenNo = item.childrenNo;
model.mode = _entities.billAndSettlements.Where(x => x.kot == item.KOT).FirstOrDefault().mode;
var empName = _entities.tblEmployees.Where(x => x.empID == item.empID).FirstOrDefault();
if (empName != null)
{
model.empName = empName.fname;
}
modelList.Add(model);
}
dataGridView1.DataSource = modelList;
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void txtSearch_KeyUp(object sender, KeyEventArgs e)
{
try
{
int rowNo = 1;
dgPurchaseDetails.AutoGenerateColumns = false;
totalAmts = 0;
if (txtSearch.Text == string.Empty)
{
dataGridBind();
return;
}
_entities = new KBBQEntities();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text.Trim()) || x.partyName.Contains(txtSearch.Text.Trim())).OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
model.partyName = item.partyName;
model.remarks = item.remarks;
model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy");
model.totalWeight = item.totalWeight;
model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt));
model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt");
if (item.updateDate == null)
{
model.updateDate = "--";
}
else
{
model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt");
}
totalAmts += item.totalAmt;
modelList.Add(model);
rowNo++;
}
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
lblTotalAmt.Text = amtFormat.comma(totalAmts);
}
catch (Exception x)
{
}
}
private void itemAutocomplete()
{
_entities = new KBBQEntities();
var ledgerNameAutoComplete = _entities.purchaseProducts.OrderBy(x => x.pName);
txtitemName.AutoCompleteCustomSource.Clear();
foreach (var item in ledgerNameAutoComplete)
{
txtitemName.AutoCompleteCustomSource.Add(item.pName.ToString());
}
}
private void partyAutocomplete()
{
_entities = new KBBQEntities();
var ledgerNameAutoComplete = _entities.tbl_PurchaseMaster.OrderBy(x => x.partyName);
txtPartyName.AutoCompleteCustomSource.Clear();
foreach (var item in ledgerNameAutoComplete)
{
txtPartyName.AutoCompleteCustomSource.Add(item.partyName.ToString());
}
}
private void billNumberAutoComplete()
{
_entities = new KBBQEntities();
var billNoAutoComplete = _entities.tbl_PurchaseMaster.OrderBy(x => x.pId);
txtSearch.AutoCompleteCustomSource.Clear();
foreach (var item in billNoAutoComplete)
{
txtSearch.AutoCompleteCustomSource.Add(item.refNo.ToString());
}
}
//REMOVE DULPICATE
public void _CheckProductExist()
{
try
{
if (btnSave.Text == "Save")
{
SqlConnection con = new SqlConnection(insertClass.dbPath);
string sql = "select proSubCate from tblProType where proSubCate = @proSubCate";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@proSubCate", txtCategory.Text.Trim());
adapt.Fill(ds);
con.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1
//meaning user already exist
if (count == 1)
{
MessageBox.Show("Menu Subgroup Already Exist", "Help - King Bar Beque", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
else
{
//PERFORM INSERT
insertClass.insertToProType(cboProductTypeName, txtCategory.Text);
_setInitialState();
}
}
else
{
_entities = new KBBQEntities();
var data = _entities.tblProTypes.Where(x => x.proTypeID == passedId).FirstOrDefault();
if (data != null)
{
data.prodTypeName = cboProductTypeName.Text.ToString();
data.proSubCate = txtCategory.Text.Trim();
_entities.SaveChanges();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message, "Throwing Exception - Fronty", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void getTableNo()
{
_entities = new KBBQEntities();
var data = _entities.billAndSettlements.Where(x => x.mode == "UNPAID").OrderBy(x => x.kot).ToList();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
if (data != null)
{
foreach (var item in data)
{
var dataTableNo = _entities.tblOrderInfoes.Where(x => x.KOT == item.kot).FirstOrDefault();
if (dataTableNo != null)
{
var datas = _entities.tblOrderInfoes.ToList();
foreach (var itemss in modelList)
{
if (itemss.tableNo == dataTableNo.tableNo)
{
count = 1;
}
}
if (count == 1)
{
count = 0;
}
else
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = dataTableNo.KOT;
model.tableNo = dataTableNo.tableNo;
modelList.Add(model);
tabl = model.tableNo;
count = 0;
//cmbTableNo.Items.Add(tabl);
}
}
}
cmbTableNo.ValueMember = "KOT";
cmbTableNo.DisplayMember = "tableNo";
cmbTableNo.DataSource = modelList.OrderBy(x => x.tableNo).ToList();
}
}
private void cmbTableNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
btnMergePay.Visible = true;
_entities = new KBBQEntities();
//var data = _entities.tblOrderInfoes.Where(x => x.tableNo == cmbTableNo.SelectedText.ToString()).ToList();
//foreach (var item in data)
//{
// selectClass.selectBillAndSettlementTableNo(dataGridView1, cmbTableNo.SelectedValue.ToString());
//}
dataGridView2.Refresh();
recNoToPass = new List <billAndSettlementVM>();
string tablCMBSelected = cmbTableNo.Text.ToString();
List <billAndSettlementVM> modelList = new List <billAndSettlementVM>();
var data = _entities.tblOrderInfoes.Where(x => x.tableNo == tablCMBSelected).ToList();
foreach (var item in data)
{
var dataSettlement = _entities.billAndSettlements.Where(x => x.kot == item.KOT && x.mode == "UNPAID").FirstOrDefault();
if (dataSettlement != null)
{
billAndSettlementVM model = new billAndSettlementVM();
model.kot = dataSettlement.kot;
model.orderDecrip = dataSettlement.orderDecrip;
model.guestName = dataSettlement.fname + " " + dataSettlement.lname;
model.ordDate = Convert.ToDateTime(item.ordDate).ToString("dd-MMM-yyyy");
model.ordTime = dataSettlement.ordTime;
model.totalDue = dataSettlement.totalDue;
model.mobile = dataSettlement.mobile;
modelList.Add(model);
recNoToPass.Add(model);
}
}
dataGridView2.DataSource = modelList;
dataGridView2.ClearSelection();
}
catch (Exception x)
{
}
}
private void dataGridBind()
{
try
{
dgPurchaseOrderDetails.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new KBBQEntities();
List <PurchaseOrderVM> modelList = new List <PurchaseOrderVM>();
var categoryData = _entities.tblPurchaseOrders.Where(x => x.date == dateTimePicker1.Value.Date).ToList();
foreach (var item in categoryData)
{
PurchaseOrderVM model = new PurchaseOrderVM();
model.rowNo = rowNo;
model.id = item.id;
var productName = _entities.purchaseProducts.Where(x => x.id == item.productId).FirstOrDefault().pName;
model.pName = productName;
model.qty = item.qty;
model.weight = item.weight + " " + item.unit;
model.date = item.date.ToString();
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt");
if (item.udate == null)
{
model.udate = "--";
}
else
{
model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
dgPurchaseOrderDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void dgPurchaseDetails_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgPurchaseDetails.Columns[e.ColumnIndex].Name == "Delete")
{
DialogResult myResult;
myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
_entities = new KBBQEntities();
var cellId = Convert.ToInt32(dgPurchaseDetails.CurrentRow.Cells[0].Value);
var selectedData1 = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == cellId).FirstOrDefault();
var selectedData2 = _entities.tbl_PurchaseMaster.Where(x => x.pId == cellId).FirstOrDefault();
if (selectedData1 != null)
{
_entities.tbl_PurchaseDetails.Remove(selectedData1);
}
else
{
MessageBox.Show("Something went wrong. Record cannot be deleted.");
}
if (selectedData2 != null)
{
_entities.tbl_PurchaseMaster.Remove(selectedData2);
}
else
{
MessageBox.Show("Something went wrong. Record cannot be deleted.");
}
_entities.SaveChanges();
MessageBox.Show("Record deleted ");
dataGridBind();
}
else
{
//No delete
}
}
}
catch (Exception x)
{
MessageBox.Show("Record Cannot be deleted. Reference of this record is present in other entries");
}
}
private void dataGridBind()
{
try
{
int rowNo = 1;
totalAmts = 0;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
model.partyName = item.partyName;
model.remarks = item.remarks;
model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy");
model.totalWeight = item.totalWeight;
model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt));
model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt");
if (item.updateDate == null)
{
model.updateDate = "--";
}
else
{
model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
totalAmts += item.totalAmt;
rowNo++;
}
lblTotalAmt.Text = amtFormat.comma(totalAmts);
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void showAvailableData()
{
clear();
btnSubmit.Text = "Update";
_entities = new KBBQEntities();
var data = _entities.purchaseProducts.Where(x => x.id == passedId).FirstOrDefault();
txtProductName.Text = data.pName.Trim().ToString();
txtQuantity.Text = data.qty.ToString();
txtWeight.Text = data.weight.ToString();
}
private void showAvailableData()
{
clear();
clearDetails();
btnCreate.Text = "Update";
_entities = new KBBQEntities();
var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault();
txtRefNo.Text = data.refNo;
dateToday.Text = data.date.ToString();
txtRemark.Text = data.remarks.ToString();
txtPartyName.Text = data.partyName.Trim().ToString();
txtTotalAmt.Text = amtFormat.comma(data.totalAmt).ToString();
txtTotalWeight.Text = data.totalWeight.ToString();
ttlWeight = Convert.ToDecimal(txtTotalWeight.Text) * 1000;
ttlRate = Convert.ToDecimal(txtTotalAmt.Text);
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
//int totalRate = Convert.ToInt32(txtTotalRate.Text);
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(data.totalAmt)).ToLower();
_entities = new KBBQEntities();
var purchaseDetailsData = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == passedPid).ToList();
id = 1;
foreach (var item in purchaseDetailsData)
{
var pName = _entities.purchaseProducts.Where(x => x.id == item.productID).FirstOrDefault().pName;
dgPurchaseItem.Rows.Add(
id.ToString(),
pName,
item.qty,
item.weight,
item.unit,
item.rate);
id = id + 1;
}
}
private void addPurchaseOrder()
{
try
{
int rowNo = 1;
_entities = new KBBQEntities();
List <PurchaseOrderVM> modelList = new List <PurchaseOrderVM>();
var categoryData = _entities.tblPurchaseOrders.Where(x => x.date == datePassed).ToList();
foreach (var item in categoryData)
{
PurchaseOrderVM model = new PurchaseOrderVM();
model.rowNo = rowNo;
model.id = item.id;
var productName = _entities.purchaseProducts.Where(x => x.id == item.productId).FirstOrDefault().pName;
model.pName = productName;
model.qty = item.qty;
model.weight = item.weight + " " + item.unit;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt");
if (item.udate == null)
{
model.udate = "--";
}
else
{
model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
ReportDataSource datasource = new ReportDataSource("DataSet1", modelList);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void orderInfo_Load(object sender, EventArgs e)
{
try
{
txtFirst.Focus();
_entities = new KBBQEntities();
var getempName = _entities.tblEmployees.OrderBy(x => x.fname).ToList();
cmbWaiter.ValueMember = "id";
cmbWaiter.DisplayMember = "fname";
cmbWaiter.DataSource = getempName;
}
catch (Exception x)
{
}
}
private void dataGridBind()
{
try
{
_entities = new KBBQEntities();
int rowNo = 1;
dgItemDetails.AutoGenerateColumns = false;
List <PurchaseProductVM> modelList = new List <PurchaseProductVM>();
var data = _entities.purchaseProducts.OrderBy(x => x.pName);
foreach (var item in data)
{
PurchaseProductVM model = new PurchaseProductVM();
model.rowNo = rowNo;
model.id = Convert.ToInt32(item.id);
model.pName = item.pName;
model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy");
model.weight = item.weight + " " + item.unit;
model.qty = item.qty;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt");
if (item.udate == null)
{
model.udate = "--";
}
else
{
model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
dgItemDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void frmVTaxSales_Load(object sender, EventArgs e)
{
dataGridView2.AutoGenerateColumns = false;
clsView viewClass = new clsView();
//viewClass.viewTaxSales(dataGridView1);
_entities = new KBBQEntities();
var cgstPer = _entities.tblTaxes.FirstOrDefault().tax_1;
var sgstPer = _entities.tblTaxes.FirstOrDefault().tax_2;
// dataGridView2.Columns[4].HeaderText = "CGST( " + cgstPer.ToString().Substring(0, 4) + " %)";
// dataGridView2.Columns[5].HeaderText = "( " + sgstPer.ToString().Substring(0, 4) + " %)";
dataGridBind();
}
private void button2_Click(object sender, EventArgs e)
{
_entities = new KBBQEntities();
orderInfo infoOrder = new orderInfo();
infoOrder.txtWaiterName.Text = this.statGetUser.Text;
infoOrder.txtTableNo.Text = "0";
infoOrder.hiddFashCash = 1;
//infoOrder.txtAdultNo.Text = "1";
//infoOrder.txtChild.Text = "0";
infoOrder.txtReceiptType.Text = "Fast Cash";
infoOrder.orderType = button2.Text;
var empIDD = selectClass.getEmployeeByID(statGetUser.Text.ToString());
infoOrder.cmbWaiter.SelectedText = this.statGetUser.Text;
infoOrder.ShowDialog();
}
private void showData()
{
try
{
int rowNo = 1;
_entities = new KBBQEntities();
List <advBookingVM> modelList = new List <advBookingVM>();
var advanceBookingData = _entities.tblAdvBookings.Where(x => x.id == passedId).ToList();
foreach (var item in advanceBookingData)
{
advBookingVM model = new advBookingVM();
model.id = item.id;
model.rowNo = rowNo;
model.adults = item.adults;
model.child = item.child;
model.custName = item.custName;
model.mob = item.mob;
model.advancePayment = item.advancePayment;
model.eventDate = Convert.ToDateTime(item.eventDate).ToString("dd-MMM-yyyy");
model.totalPayment = item.totalPayment;
model.status = item.status;
model.udate = item.udate;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MMM-yyyy");
model.recptNo = item.recptNo;
model.id = item.id;
modelList.Add(model);
}
ReportDataSource datasource = new ReportDataSource("DataSet1", modelList);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
}
catch (Exception x)
{
}
}
void addPurchaseDetailsData()
{
foreach (DataGridViewRow dr in dgPurchaseItem.Rows)
{
if (Convert.ToString(dr.Cells[0].Value) != string.Empty)
{
_entities = new KBBQEntities();
tbl_PurchaseDetails purchaseDetails = new tbl_PurchaseDetails();
purchaseDetails.purchaseID = _entities.tbl_PurchaseMaster.Where(x => x.refNo == txtRefNo.Text).FirstOrDefault().pId;
var gridItemCode = dr.Cells[1].Value.ToString();
purchaseDetails.productID = _entities.purchaseProducts.Where(x => x.pName == gridItemCode).FirstOrDefault().id;
purchaseDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString());
purchaseDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString());
purchaseDetails.unit = dr.Cells[4].Value.ToString();
purchaseDetails.rate = Convert.ToDecimal(dr.Cells[5].Value.ToString());
purchaseDetails.createdDate = DateTime.Now;
_entities.tbl_PurchaseDetails.Add(purchaseDetails);
_entities.SaveChanges();
//Update Qty in stock
var itemQty = _entities.purchaseProducts.Where(x => x.id == purchaseDetails.productID).FirstOrDefault();
if (itemQty != null)
{
itemQty.qty = itemQty.qty + purchaseDetails.qty;
itemQty.udate = DateTime.Now;
}
else
{
itemQty.qty = purchaseDetails.qty;
itemQty.udate = DateTime.Now;
}
_entities.SaveChanges();
}
}
}
private void dgAdvBookingDetails_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgAdvBookingDetails.CurrentRow.Index != -1 && dgAdvBookingDetails.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dgAdvBookingDetails.CurrentRow.Cells[0].Value);
_entities = new KBBQEntities();
var seeData = _entities.tblAdvBookings.Where(x => x.id == lID).FirstOrDefault();
if (seeData != null)
{
if (seeData.status == "UNPAID")
{
txtCustName.Text = seeData.custName.Trim().ToString();
txtMob.Text = seeData.mob.ToString();
txtAdults.Text = seeData.adults.ToString();
txtChild.Text = seeData.child.ToString();
txtAdvPayment.Text = seeData.advancePayment.ToString();
dtpBookingDate.Text = seeData.eventDate.ToString();
passedId = seeData.id;
btnCreate.Text = "Update";
}
else
{
MessageBox.Show("Cannot able to update as payment is settled", "Error - King Bar beque Restaurant", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
