private void showAvailableData()
{
try
{
clear();
clearDetails();
btnSubmit.Text = "Update";
_entities = new TSEntities();
var data = _entities.tbl_SheetMaster.Where(x => x.sheetId == passedId).FirstOrDefault();
txtSheetName.Text = data.sheetName;
txtTotalRate.Text = data.totalRate.ToString();
txtTotalAmount.Text = data.totalAmt.ToString();
txtProfitMargin.Text = data.profitMargin.ToString();
txtTaxRate.Text = data.gstAmt.ToString();
if (data.gstPer == 18)
{
cmbGst.SelectedIndex = 1;
}
if (data.gstPer == 28)
{
cmbGst.SelectedIndex = 2;
}
else
{
cmbGst.SelectedIndex = 0;
}
ttlRate = Convert.ToDecimal(data.totalRate);
//Sheet Details
_entities = new TSEntities();
var sheetDetailsData = _entities.tbl_SheetDetails.Where(x => x.sheetId == passedId).ToList();
datagridId = 1;
foreach (var item in sheetDetailsData)
{
var itemName = _entities.tbl_ProductMaster.Where(x => x.id == item.pId).FirstOrDefault().p_Name;
dgSheetDetails.Rows.Add(
datagridId.ToString(),
itemName,
item.qty,
item.weight,
item.rate,
item.amt);
datagridId = datagridId + 1;
}
}
catch (Exception x)
{
}
}
private void SheetgridBind()
{
ppMsg = new PopupMessage();
try
{
int rowNo = 1;
dgSheetMaster.AutoGenerateColumns = false;
_entities = new TSEntities();
List <SheetMasterVM> modelList = new List <SheetMasterVM>();
var data = _entities.tbl_SheetMaster.OrderBy(x => x.sheetName);
foreach (var item in data)
{
SheetMasterVM model = new SheetMasterVM();
model.rowNo = rowNo;
model.sheetId = item.sheetId;
model.sheetName = item.sheetName;
modelList.Add(model);
rowNo++;
}
dgSheetMaster.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString() + " Rows";
}
catch (Exception x)
{
ppMsg.infoMessage("Something went wrong. Contact your system administrator!");
}
}
private void dgProductMaster_DoubleClick(object sender, EventArgs e)
{
ppMsg = new PopupMessage();
try
{
//ProductId = 0;
if (dgProductMaster.CurrentRow.Index != -1 && dgProductMaster.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dgProductMaster.CurrentRow.Cells[0].Value);
_entities = new TSEntities();
var data = _entities.tbl_ProductMaster.Where(x => x.id == lID).FirstOrDefault();
//clear();
txtpName.Text = data.p_Name;
txtRate.Text = data.rate.ToString();
// ProductId = data.id;
//btnSubmit.Text = "Update";
}
}
catch (Exception x)
{
ppMsg.infoMessage("Something went wrong. Contact your system administrator!");
}
}
private void gridBind()
{
try
{
int rowNo = 1;
dgProductMaster.AutoGenerateColumns = false;
_entities = new TSEntities();
List <ProductMasterVM> modelList = new List <ProductMasterVM>();
var data = _entities.tbl_ProductMaster.OrderBy(x => x.p_Name);
foreach (var item in data)
{
ProductMasterVM model = new ProductMasterVM();
model.rowNo = rowNo;
model.id = item.id;
model.p_Name = item.p_Name;
model.rate = item.rate + " /-";
modelList.Add(model);
rowNo++;
}
dgProductMaster.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString() + " Rows";
}
catch (Exception x)
{
ppMessage.infoMessage("Something went wrong. Contact your system administrator!");
}
}
void addSheetDetailsData()
{
foreach (DataGridViewRow dr in dgSheetDetails.Rows)
{
if (Convert.ToString(dr.Cells[0].Value) != string.Empty)
{
_entities = new TSEntities();
tbl_SheetDetails sheetDetails = new tbl_SheetDetails();
sheetDetails.sheetId = _entities.tbl_SheetMaster.Where(x => x.sheetName == txtSheetName.Text.Trim().ToString()).FirstOrDefault().sheetId;
var gridProductName = dr.Cells[1].Value.ToString();
sheetDetails.pId = _entities.tbl_ProductMaster.Where(x => x.p_Name == gridProductName).FirstOrDefault().id;
sheetDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString());
sheetDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString());
sheetDetails.rate = Convert.ToDecimal(dr.Cells[4].Value.ToString());
sheetDetails.amt = Convert.ToDecimal(dr.Cells[5].Value.ToString());
sheetDetails.cDate = DateTime.Now;
_entities.tbl_SheetDetails.Add(sheetDetails);
_entities.SaveChanges();
//Update Qty in stock
//var itemQty = _entities.tbl_StockItemDetails.Where(x => x.itemId == purchaseDetails.productID).FirstOrDefault();
//itemQty.qty = itemQty.qty + purchaseDetails.qty;
//itemQty.upadtedDate = DateTime.Now;
//_entities.SaveChanges();
}
}
}
private void productNameNameAutoComplete()
{
_entities = new TSEntities();
var productNameAutoComplete = _entities.tbl_ProductMaster;
txtpName.AutoCompleteCustomSource.Clear();
foreach (var item in productNameAutoComplete)
{
txtpName.AutoCompleteCustomSource.Add(item.p_Name.ToString());
}
}
private void txtpName_KeyPress(object sender, KeyPressEventArgs e)
{
ppMsg = new PopupMessage();
try
{
int rowNo = 1;
dgProductMaster.AutoGenerateColumns = false;
_entities = new TSEntities();
List <ProductMasterVM> productMasterListVM = new List <ProductMasterVM>();
List <tbl_ProductMaster> data;
if (txtpName.Text == "")
{
data = _entities.tbl_ProductMaster.ToList();
}
else
{
data = _entities.tbl_ProductMaster.Where(x => x.p_Name.Contains(txtpName.Text.Trim().ToString())).ToList();
}
foreach (var item in data)
{
ProductMasterVM list = new ProductMasterVM();
list.rowNo = rowNo;
list.id = item.id;
list.p_Name = item.p_Name;
list.rate = item.rate.ToString() + " /-";
productMasterListVM.Add(list);
rowNo++;
}
dgProductMaster.DataSource = productMasterListVM;
lblTotalRows.Text = productMasterListVM.Count.ToString() + " Rows";
}
catch (Exception x)
{
ppMsg.infoMessage("Something went wrong. Contact your system administrator!");
}
}
private void txtpName_Leave(object sender, EventArgs e)
{
try
{
_entities = new TSEntities();
if (txtpName.Text != string.Empty)
{
var rates = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim().ToString()).FirstOrDefault();
txtRate.Text = rates.rate.ToString();
ProductgridBind();
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void dgProductMaster_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
ppMsg = new PopupMessage();
try
{
if (dgProductMaster.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 TSEntities();
var cellId = Convert.ToInt32(dgProductMaster.CurrentRow.Cells[0].Value);
var selectedData1 = _entities.tbl_ProductMaster.Where(x => x.id == cellId).OrderBy(x => x.p_Name).FirstOrDefault();
if (selectedData1 != null)
{
_entities.tbl_ProductMaster.Remove(selectedData1);
}
else
{
// MessageBox.Show("Something went wrong. Record cannot be deleted.");
ppMsg.infoMessage("Something went wrong. Record cannot be deleted.");
}
_entities.SaveChanges();
ppMsg.deleteMessage();
//MessageBox.Show("Record deleted ");
ProductgridBind();
}
}
}
catch (Exception x)
{
ppMsg.infoMessage("Something went wrong. Contact your system administrator!");
}
}
private void txtRate_Leave(object sender, EventArgs e)
{
ppMsg = new PopupMessage();
try
{
if (txtQtyWeight.Text != string.Empty)
{
if (txtRate.Text == string.Empty)
{
txtRate.Text = "0.00";
}
_entities = new TSEntities();
var rates = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim().ToString()).FirstOrDefault();
if (Convert.ToDecimal(txtRate.Text.Trim()) != rates.rate)
{
DialogResult myResult;
myResult = MessageBox.Show("Are you really wanna change rate of the item?", "Update Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
rates.rate = Convert.ToDecimal(txtRate.Text.Trim());
_entities.SaveChanges();
ppMsg.updateMessage();
ProductgridBind();
}
else
{
}
txtAmt.Text = Convert.ToDecimal((Convert.ToDecimal(txtQtyWeight.Text.Trim()) * Convert.ToDecimal(txtRate.Text.Trim()))).ToString();
}
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void txtpName_Leave(object sender, EventArgs e)
{
ppMessage = new PopupMessage();
try
{
if (txtpName.Text != string.Empty)
{
_entities = new TSEntities();
var p_nameExists = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim()).FirstOrDefault();
if (p_nameExists.id > 0)
{
ppMessage.infoMessage("Product Name already exists!");
txtpName.Focus();
}
}
}
catch (Exception x)
{
// ppMessage.infoMessage("Something went wrong. Contact your system administrator!");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
ppMsg = new PopupMessage();
try
{
if (txtSheetName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtSheetName, "Enter Sheet Name.");
txtSheetName.Focus();
panel9.Visible = true;
lblError.Text = "Enter Sheet Name.";
}
else if (txtProfitMargin.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtProfitMargin, "Profit margin cannot be blank.");
txtProfitMargin.Focus();
panel9.Visible = true;
lblError.Text = "Profit margin cannot be blank.";
}
else if (txtProfitMargin.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtProfitMargin, "Enter Profit Margin.");
txtProfitMargin.Focus();
panel9.Visible = true;
lblError.Text = "Enter Profit Margin.";
}
//else if (txtTaxRate.Text == string.Empty)
//{
// errorProvider1.Clear();
// errorProvider1.SetError(txtTaxRate, "Enter Tax Amt.");
// txtTaxRate.Focus();
// panel9.Visible = true;
// lblError.Text = "Enter Tax Amt.";
//}
//else if (txtTotalAmount.Text == string.Empty)
//{
// errorProvider1.Clear();
// errorProvider1.SetError(txtTotalAmount, "Enter Total Amount.");
// txtTotalAmount.Focus();
// panel9.Visible = true;
// lblError.Text = "Enter Total Amount.";
//}
else
{
if (btnSubmit.Text == "Submit")
{
// Save Code
_entities = new TSEntities();
tbl_SheetMaster sm = new tbl_SheetMaster();
sm.sheetName = txtSheetName.Text.Trim().ToString();
sm.date = Convert.ToDateTime(dateTimePicker1.Text.ToString()).Date;
sm.totalRate = Convert.ToDecimal(txtTotalRate.Text.Trim());
sm.totalAmt = Convert.ToDecimal(txtTotalAmount.Text.Trim());
sm.profitMargin = Convert.ToDecimal(txtProfitMargin.Text.Trim());
if (cmbGst.SelectedIndex == 1)
{
sm.gstPer = 18;
}
else if (cmbGst.SelectedIndex == 2)
{
sm.gstPer = 28;
}
else
{
sm.gstPer = 0;
}
sm.gstAmt = Convert.ToDecimal(txtTaxRate.Text.Trim());
sm.remarks = txtRemark.Text.Trim().ToString();
sm.cDate = DateTime.Now;
_entities.tbl_SheetMaster.Add(sm);
_entities.SaveChanges();
ppMsg.successMessage();
addSheetDetailsData();
}
else
{
//Update Code
}
clear();
clearDetails();
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
ppMessage = new PopupMessage();
try
{
if (txtpName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtpName, "Enter Product Name.");
txtpName.Focus();
panel4.Visible = true;
lblError.Text = "Enter Product Name.";
}
else if (txtRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRate, "Enter Rate.");
txtRate.Focus();
panel4.Visible = true;
lblError.Text = "Enter Rate.";
}
else
{
if (btnSubmit.Text == "Submit")
{
//Save No Code
_entities = new TSEntities();
tbl_ProductMaster pm = new tbl_ProductMaster();
pm.p_Name = txtpName.Text.Trim().ToString();
pm.rate = Convert.ToDecimal(txtRate.Text.Trim());
_entities.tbl_ProductMaster.Add(pm);
_entities.SaveChanges();
//Notification
ppMessage.successMessage();
}
else
{
// Update No Code
_entities = new TSEntities();
var data = _entities.tbl_ProductMaster.Where(x => x.id == ProductId).FirstOrDefault();
data.p_Name = txtpName.Text.Trim().ToString();
data.rate = Convert.ToDecimal(txtRate.Text.Trim());
_entities.SaveChanges();
ppMessage.updateMessage();
}
// Clear Function Call
clear();
}
}
catch (Exception x)
{
ppMessage.infoMessage("Something went wrong. Contact your system administrator!");
}
}
