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();
}
}
}
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();
}
}
}
//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 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 txtitemName_Leave(object sender, EventArgs e)
{
try
{
_entities = new KBBQEntities();
if (txtitemName.Text != string.Empty)
{
var checkLedgername = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim().ToString()).FirstOrDefault();
if (checkLedgername == null)
{
DialogResult myResult;
myResult = MessageBox.Show("No such product exists. Want to create new product?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
//frmAddPurchaseProduct ledger = new frmAddPurchaseProduct(0,txtitemName.Text.Trim());
//ledger.ShowDialog();
purchaseProduct pp = new purchaseProduct();
pp.pName = txtitemName.Text.Trim().ToString();
_entities.purchaseProducts.Add(pp);
_entities.SaveChanges();
itemAutocomplete();
txtitemName.Focus();
}
else
{
txtitemName.Focus();
}
}
}
}
catch (Exception x)
{
}
}
private void dgAdvBookingDetails_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgAdvBookingDetails.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(dgAdvBookingDetails.CurrentRow.Cells[0].Value);
var selectedData1 = _entities.tblAdvBookings.Where(x => x.id == cellId).FirstOrDefault();
if (selectedData1 != null)
{
_entities.tblAdvBookings.Remove(selectedData1);
}
else
{
MessageBox.Show("Something went wrong. Record cannot be deleted.");
}
_entities.SaveChanges();
MessageBox.Show("Record deleted ");
gridViewBind();
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtRefNo.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRefNo, "Enter reference number.");
txtRefNo.Focus();
panel3.Visible = true;
lblError.Text = "Enter reference number.";
}
else if (txtTotalWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalWeight, "Enter total weight.");
txtTotalWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter total weight.";
}
else if (txtTotalAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtTotalAmt, "Enter total rate.");
txtTotalAmt.Focus();
panel3.Visible = true;
lblError.Text = "Enter total rate.";
}
else
{
if (btnCreate.Text == "Create")
{
//Save Code
_entities = new KBBQEntities();
tbl_PurchaseMaster purchaseData = new tbl_PurchaseMaster();
purchaseData.refNo = txtRefNo.Text.Trim().ToString();
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
purchaseData.date = date;
purchaseData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseData.unit = lblUnit.Text;
purchaseData.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseData.remarks = txtRemark.Text.ToString();
purchaseData.createdDate = DateTime.Now;
purchaseData.updateDate = DateTime.Now;
purchaseData.partyName = txtPartyName.Text.Trim().ToString();
_entities.tbl_PurchaseMaster.Add(purchaseData);
_entities.SaveChanges();
//add data to purchase detials
addPurchaseDetailsData();
MessageBox.Show("Record Successfull Saved");
}
else
{
//Update Code
_entities = new KBBQEntities();
var purchaseDataUpdate = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault();
purchaseDataUpdate.refNo = txtRefNo.Text.Trim().ToString();
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
purchaseDataUpdate.date = Convert.ToDateTime(date);
purchaseDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text);
purchaseDataUpdate.unit = lblUnit.Text;
purchaseDataUpdate.totalAmt = Convert.ToDecimal(txtTotalAmt.Text);
purchaseDataUpdate.remarks = txtRemark.Text.ToString();
purchaseDataUpdate.updateDate = DateTime.Now;
purchaseDataUpdate.partyName = txtPartyName.Text.Trim().ToString();
_entities.SaveChanges();
var purchaseDetailsUpdate = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == passedPid).ToList();
foreach (var item in purchaseDetailsUpdate)
{
_entities.tbl_PurchaseDetails.Remove(item);
_entities.SaveChanges();
}
addPurchaseDetailsData(); //grid data entry in purchse details
//Update transaction
MessageBox.Show("Record Successfull Updated");
}
clear();
clearDetails();
count = 0;
passedPid = 0;
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtCustName.Text == string.Empty && txtMob.Text == string.Empty && txtChild.Text == string.Empty && txtAdults.Text == string.Empty && txtAdvPayment.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtCustName, "Enter all details.");
txtCustName.Focus();
panel3.Visible = true;
lblError.Text = "Enter all details.";
}
else if (txtCustName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtCustName, "Enter Customer-name");
txtCustName.Focus();
panel3.Visible = true;
lblError.Text = "Enter Customer-name.";
}
else if (txtMob.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtMob, "Enter Mobile Number.");
txtMob.Focus();
panel3.Visible = true;
lblError.Text = "Enter Qty.";
}
else if (txtAdults.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtAdults, "Enter Adults.");
txtAdults.Focus();
panel3.Visible = true;
lblError.Text = "There must be atleast 1 adult.";
}
else if (txtAdvPayment.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtAdvPayment, "Enter Adv. Payment.");
txtAdvPayment.Focus();
panel3.Visible = true;
lblError.Text = "Adv. Payment.";
}
else
{
//DateTime date = DateTime.ParseExact(dateToday.Text, "yyyy-MM-dd", null);
if (btnCreate.Text == "Create")
{
tblAdvBooking data = new tblAdvBooking();
data.custName = txtCustName.Text.Trim().ToString();
data.mob = txtMob.Text.Trim().ToString();
data.child = Convert.ToInt32(txtChild.Text.ToString());
data.adults = Convert.ToInt32(txtAdults.Text);
data.eventDate = dtpBookingDate.Value.Date;
data.todayDate = dateToday.Value.Date;
data.advancePayment = Convert.ToDecimal(txtAdvPayment.Text);
data.status = "UNPAID";
data.cdate = DateTime.Now;
_entities.tblAdvBookings.Add(data);
_entities.SaveChanges();
MessageBox.Show("Record Created Successfully");
DialogResult myResult;
myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
_entities = new KBBQEntities();
long lastId = _entities.tblAdvBookings.OrderByDescending(x => x.id).FirstOrDefault().id;
frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(lastId);
rpt.ShowDialog();
}
}
else
{
//Update Code
_entities = new KBBQEntities();
//var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id;
var advBookingData = _entities.tblAdvBookings.Where(x => x.id == passedId).FirstOrDefault();
advBookingData.custName = txtCustName.Text.Trim().ToString();
advBookingData.mob = txtMob.Text.Trim().ToString();
advBookingData.child = Convert.ToInt32(txtChild.Text.ToString());
advBookingData.adults = Convert.ToInt32(txtAdults.Text);
advBookingData.eventDate = dtpBookingDate.Value.Date;
advBookingData.todayDate = dateToday.Value.Date;
advBookingData.advancePayment = Convert.ToDecimal(txtAdvPayment.Text);
_entities.SaveChanges();
MessageBox.Show("Record Updated Successfully");
DialogResult myResult;
myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
_entities = new KBBQEntities();
frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(passedId);
rpt.ShowDialog();
}
}
clear();
gridViewBind();
}
}
catch (Exception x)
{
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txtitemName.Text == string.Empty && txtQty.Text == string.Empty && txtWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtitemName, "Enter all details.");
txtitemName.Focus();
panel3.Visible = true;
lblError.Text = "Enter all details.";
}
else if (txtitemName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtitemName, "Enter Product-name");
txtitemName.Focus();
panel3.Visible = true;
lblError.Text = "Enter Party-name.";
}
else if (txtQty.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtQty, "Enter Qty.");
txtQty.Focus();
panel3.Visible = true;
lblError.Text = "Enter Qty.";
}
else if (txtWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtWeight, "Enter Weight.");
txtWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter Weight.";
}
else
{
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
if (btnCreate.Text == "Create")
{
//save code
_entities = new KBBQEntities();
var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id;
//var checkForExisitingData = _entities.tblPurchaseOrders.Where(x => x.productId == pId).FirstOrDefault();
//if (checkForExisitingData != null)
//{
// MessageBox.Show("Entry Already Exists. Update the Exisiting Entry.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// clear();
// txtitemName.Focus();
// return;
//}
//else
//{
//save Code
tblPurchaseOrder proDate = new tblPurchaseOrder();
proDate.productId = pId;
proDate.qty = Convert.ToDecimal(txtQty.Text);
proDate.weight = Convert.ToDecimal(txtWeight.Text);
proDate.unit = comboUnit.Text.ToString();
proDate.date = date;
proDate.cdate = DateTime.Now;
_entities.tblPurchaseOrders.Add(proDate);
_entities.SaveChanges();
clear();
MessageBox.Show("Record Added Successfully");
//}
}
else
{
//Update Code
_entities = new KBBQEntities();
var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id;
var proDataUpdate = _entities.tblPurchaseOrders.Where(x => x.id == passedId).FirstOrDefault();
proDataUpdate.productId = pId;
proDataUpdate.qty = Convert.ToDecimal(txtQty.Text);
proDataUpdate.weight = Convert.ToDecimal(txtWeight.Text);
proDataUpdate.unit = comboUnit.Text.ToString();
proDataUpdate.date = date;
proDataUpdate.udate = DateTime.Now;
_entities.SaveChanges();
clear();
MessageBox.Show("Record Updated Successfully");
}
dataGridBind();
}
}
catch (Exception x)
{
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtProductName.Text == string.Empty && txtQuantity.Text == string.Empty && txtWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtProductName, "Enter all details.");
txtProductName.Focus();
panel3.Visible = true;
lblError.Text = "Enter all details.";
}
else if (txtProductName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtProductName, "Enter Product-name");
txtProductName.Focus();
panel3.Visible = true;
lblError.Text = "Enter Party-name.";
}
else if (txtQuantity.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtQuantity, "Enter Qty.");
txtQuantity.Focus();
panel3.Visible = true;
lblError.Text = "Enter Qty.";
}
else if (txtWeight.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtWeight, "Enter Weight.");
txtWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter Weight.";
}
else
{
DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null);
if (btnSubmit.Text == "Submit")
{
//save code
_entities = new KBBQEntities();
purchaseProduct proDate = new purchaseProduct();
proDate.pName = txtProductName.Text.Trim().ToString();
proDate.qty = Convert.ToDecimal(txtQuantity.Text);
proDate.weight = Convert.ToDecimal(txtWeight.Text);
proDate.unit = comboUnit.Text.ToString();
proDate.date = date;
proDate.cdate = DateTime.Now;
_entities.purchaseProducts.Add(proDate);
_entities.SaveChanges();
clear();
MessageBox.Show("Record Added Successfully");
}
else
{
//update code
_entities = new KBBQEntities();
var proDataUpdate = _entities.purchaseProducts.Where(x => x.id == passedId).FirstOrDefault();
proDataUpdate.pName = txtProductName.Text.Trim().ToString();
proDataUpdate.qty = Convert.ToDecimal(txtQuantity.Text);
proDataUpdate.weight = Convert.ToDecimal(txtWeight.Text);
proDataUpdate.unit = comboUnit.Text.ToString();
proDataUpdate.date = date;
proDataUpdate.udate = DateTime.Now;
_entities.SaveChanges();
clear();
MessageBox.Show("Record Updated Successfully");
}
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtExpName.Text == string.Empty && txtExpBy.Text == string.Empty && txtAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtExpName, "Enter all details.");
txtExpName.Focus();
panel3.Visible = true;
lblError.Text = "Enter all details.";
}
else if (txtExpName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtExpName, "Enter Expense-name");
txtExpName.Focus();
panel3.Visible = true;
lblError.Text = "Enter Customer-name.";
}
else if (txtExpBy.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtExpBy, "Enter Expense By.");
txtExpBy.Focus();
panel3.Visible = true;
lblError.Text = "Enter Expense By.";
}
else if (txtAmt.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtAmt, "Enter Amount.");
txtAmt.Focus();
panel3.Visible = true;
lblError.Text = "Enter Amount.";
}
else
{
//DateTime date = DateTime.ParseExact(dateToday.Text, "yyyy-MM-dd", null);
if (btnCreate.Text == "Save")
{
tblExpens data = new tblExpens();
data.expName = txtExpName.Text.Trim().ToString();
data.expBy = txtExpBy.Text.Trim().ToString();
data.expDate = dtpExpDate.Value.Date;
data.amount = Convert.ToDecimal(txtAmt.Text);
data.cdate = DateTime.Now;
_entities.tblExpenses.Add(data);
_entities.SaveChanges();
MessageBox.Show("Record Created Successfully");
}
else
{
//Update Code
_entities = new KBBQEntities();
//var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id;
var expData = _entities.tblExpenses.Where(x => x.id == passedId).FirstOrDefault();
expData.expName = txtExpName.Text.Trim().ToString();
expData.expBy = txtExpBy.Text.Trim().ToString();
expData.expDate = dtpExpDate.Value.Date;
expData.amount = Convert.ToDecimal(txtAmt.Text);
expData.udate = DateTime.Now;
_entities.SaveChanges();
Clear();
MessageBox.Show("Record Updated Successfully");
}
dataGridViewBind();
}
}
catch (Exception x)
{
}
}
