private void dgSalesItem_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
btnCreate.Enabled = false;
lblBtnError.Visible = true;
if (dgSalesItem.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)
{
// int id = Convert.ToInt32(dgPurchaseItem.CurrentRow.Index);
foreach (DataGridViewCell oneCell in dgSalesItem.SelectedCells)
{
var dgWeight = Convert.ToDecimal(dgSalesItem.Rows[oneCell.RowIndex].Cells[3].Value);
var dgKarat = Convert.ToDecimal(dgSalesItem.Rows[oneCell.RowIndex].Cells[5].Value);
var dgMaking = Convert.ToDecimal(dgSalesItem.Rows[oneCell.RowIndex].Cells[7].Value);
var dgRate = Convert.ToDecimal(dgSalesItem.Rows[oneCell.RowIndex].Cells[8].Value);
ttlWeight = ttlWeight - dgWeight;
ttlMaking = ttlMaking - dgMaking;
ttlKarat = ttlKarat - dgKarat;
ttlRate = ttlRate - dgRate;
txtTotalMaking.Text = ttlMaking.ToString();
txtTotalKarat.Text = ttlKarat.ToString();
txtTotalRate.Text = amtFormat.comma(ttlRate).ToString();
double kg = Convert.ToDouble(ttlWeight) / 1000;
if (kg > 0)
{
txtTotalWeight.Text = kg.ToString();
lblUnit.Text = "Kg";
}
else
{
txtTotalWeight.Text = ttlWeight.ToString();
lblUnit.Text = "Gram";
}
if (oneCell.Selected)
{
dgSalesItem.Rows.RemoveAt(oneCell.RowIndex);
}
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(ttlRate)).ToLower();
}
}
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void addPurchaseMaster()
{
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedId).ToList();
List <PurchaseMasterVM> listVm = new List <PurchaseMasterVM>();
List <LedgerDetailsVM> LedgerlistVm = new List <LedgerDetailsVM>();
foreach (var item in data)
{
PurchaseMasterVM vm = new PurchaseMasterVM();
vm.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy");
vm.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
vm.ledgerId = item.ledgerId;
vm.pId = item.pId;
vm.refNo = item.refNo;
vm.remarks = item.remarks;
vm.totalFine = item.totalFine;
vm.totalMaking = item.totalMaking;
vm.totalMelting = item.totalMelting;
vm.totalWeight = item.totalWeight;
vm.unit = item.unit;
vm.totalAmt = item.totalAmt;
ConvertNoToWord toWord = new ConvertNoToWord();
vm.amtinWord = toWord.ConvertNumbertoWords(Convert.ToInt32(item.totalAmt));
listVm.Add(vm);
LedgerDetailsVM ll = new LedgerDetailsVM();
ll.contact = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == item.ledgerId).FirstOrDefault().contact;
ll.address = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == item.ledgerId).FirstOrDefault().address.Trim();
LedgerlistVm.Add(ll);
}
ReportDataSource datasource = new ReportDataSource("DataSet1", listVm);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
datasource = new ReportDataSource("DataSet3", LedgerlistVm);
this.reportViewer1.LocalReport.DataSources.Add(datasource);
}
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 txtRate_Leave(object sender, EventArgs e)
{
try
{
btnCreate.Enabled = true;
lblBtnError.Visible = false;
if (txtitemName.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtitemName, "Enter item Code.");
txtitemName.Focus();
panel3.Visible = true;
lblError.Text = "Enter item code.";
}
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 item weight.");
txtWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter item weight.";
}
else if (txtRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRate, "Enter rate.");
txtRate.Focus();
panel3.Visible = true;
lblError.Text = "Enter rate.";
}
else
{
errorProvider1.Clear();
if (txtitemName.Text != string.Empty && txtQty.Text != string.Empty && txtWeight.Text != string.Empty && txtRate.Text != string.Empty)
{
if (datagridEdit)
{
// MessageBox.Show( dgPurchaseItem.Rows[datagridId].Cells);
dgPurchaseItem.Rows[datagridId].Cells[1].Value = txtitemName.Text;
dgPurchaseItem.Rows[datagridId].Cells[2].Value = txtQty.Text;
dgPurchaseItem.Rows[datagridId].Cells[3].Value = txtWeight.Text;
dgPurchaseItem.Rows[datagridId].Cells[4].Value = comboUnit.Text;
dgPurchaseItem.Rows[datagridId].Cells[5].Value = txtRate.Text;
this.datagridEdit = false;
var dgQty = Convert.ToDecimal(dgPurchaseItem.Rows[datagridId].Cells[2].Value);
var dgWeight = Convert.ToDecimal(dgPurchaseItem.Rows[datagridId].Cells[3].Value);
var dgrate = Convert.ToDecimal(dgPurchaseItem.Rows[datagridId].Cells[5].Value);
}
else
{
dgPurchaseItem.Rows.Add(id.ToString(), txtitemName.Text, txtQty.Text, txtWeight.Text, comboUnit.Text, txtRate.Text);
//dgPurchaseOrderDetails.Rows.Add(id.ToString(), txtitemName.Text, "harsh", "200", "G", "500");
//dgPurchaseItem.Rows.Add(id.ToString(), txtitemName.Text, "harsh", "200", "G", "500");
id = id + 1;
}
if (comboUnit.Text == "Kg")
{
decimal grams = Convert.ToDecimal(txtWeight.Text) * 1000;
ttlWeight = ttlWeight + grams;
}
else
{
ttlWeight = ttlWeight + Convert.ToDecimal(txtWeight.Text);
}
ttlRate = ttlRate + Convert.ToDecimal(txtRate.Text);
}
double kg = Convert.ToDouble(ttlWeight) / 1000;
if (kg > 0)
{
txtTotalWeight.Text = kg.ToString();
lblUnit.Text = "Kg";
}
else
{
txtTotalWeight.Text = ttlWeight.ToString();
lblUnit.Text = "Gram";
}
txtTotalAmt.Text = amtFormat.comma(ttlRate).ToString();
clearDetails();
txtitemName.Focus();
errorProvider1.Clear();
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
var rats = Convert.ToDecimal(txtTotalAmt.Text.Trim().ToString());
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(rats)).ToLower();
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void showAvailData()
{
clear();
clearDetails();
btnCreate.Text = "Update";
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_SalesMaster.Where(x => x.sId == passedSid).FirstOrDefault();
txtBillNo.Text = data.billNo;
dateTimePicker1.Text = data.date.ToString();
txtLedgerName.Text = _entities.tbl_AccLedger.Where(x => x.Id == data.ledgerId).FirstOrDefault().ledgerName;
txtTotalKarat.Text = data.totalKarat.ToString();
txtTotalMaking.Text = amtFormat.comma(data.totalMaking).ToString();
txtTotalRate.Text = amtFormat.comma(data.totalAmt).ToString();
txtTotalWeight.Text = data.totalWeight.ToString();
ttlWeight = Convert.ToDecimal(txtTotalWeight.Text) * 1000;
ttlKarat = Convert.ToDecimal(txtTotalKarat.Text);
ttlRate = Convert.ToDecimal(txtTotalRate.Text);
ttlMaking = Convert.ToDecimal(txtTotalMaking.Text);
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
//int totalRate = Convert.ToInt32(txtTotalRate.Text);
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(data.totalAmt)).ToLower();
_entities = new MicroAccountsEntities1();
var salesDetailsData = _entities.tbl_SalesDetails.Where(x => x.salesId == passedSid).ToList();
id = 1;
foreach (var item in salesDetailsData)
{
var itemCode = _entities.tbl_ItemMaster.Where(x => x.id == item.productId).FirstOrDefault().itemCode;
dgSalesItem.Rows.Add(
id.ToString(),
itemCode,
item.qty,
item.weight,
item.unit,
item.karat,
item.kRate,
item.making,
item.rate);
id = id + 1;
}
var checkLedgername = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault();
decimal drLedgerId = Convert.ToDecimal(checkLedgername.Id);
CrDrDifference crdrDiff = new CrDrDifference();
string valueAmt = crdrDiff.DifferenceCrDr(Convert.ToInt32(drLedgerId), 0);
lblBalance.Text = valueAmt;
}
private void txtRate_Leave(object sender, EventArgs e)
{
try
{
btnCreate.Enabled = true;
lblBtnError.Visible = false;
if (txtItemCode.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtItemCode, "Enter item Code.");
txtItemCode.Focus();
panel3.Visible = true;
lblError.Text = "Enter item code.";
}
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 item weight.");
txtWeight.Focus();
panel3.Visible = true;
lblError.Text = "Enter item weight.";
}
//else if (cmbKarat.SelectedIndex == 0 || cmbKarat.Text == string.Empty)
//{
// errorProvider1.Clear();
// errorProvider1.SetError(cmbKarat, "Enter karat.");
// cmbKarat.Focus();
// panel3.Visible = true;
// lblError.Text = "Enter karat.";
//}
else if (txtKRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtKRate, "Enter karat Rate.");
txtKRate.Focus();
panel3.Visible = true;
lblError.Text = "Enter karat Rate.";
}
else if (txtMaking.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtMaking, "Enter making.");
txtMaking.Focus();
panel3.Visible = true;
lblError.Text = "Enter making.";
}
else if (txtRate.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtRate, "Enter rate.");
txtRate.Focus();
panel3.Visible = true;
lblError.Text = "Enter rate.";
}
else
{
errorProvider1.Clear();
if (txtItemCode.Text != string.Empty && txtQty.Text != string.Empty && txtWeight.Text != string.Empty && cmbKarat.Text != string.Empty && txtMaking.Text != string.Empty && txtRate.Text != string.Empty)
{
if (datagridEdit)
{
// MessageBox.Show( dgPurchaseItem.Rows[datagridId].Cells);
dgSalesItem.Rows[datagridId].Cells[1].Value = txtItemCode.Text;
dgSalesItem.Rows[datagridId].Cells[2].Value = txtQty.Text;
dgSalesItem.Rows[datagridId].Cells[3].Value = txtWeight.Text;
dgSalesItem.Rows[datagridId].Cells[4].Value = cmbUnit.Text;
if (cmbKarat.SelectedIndex == 0)
{
dgSalesItem.Rows[datagridId].Cells[5].Value = 0;
}
else
{
dgSalesItem.Rows[datagridId].Cells[5].Value = cmbKarat.Text;
}
dgSalesItem.Rows[datagridId].Cells[6].Value = txtKRate.Text;
dgSalesItem.Rows[datagridId].Cells[7].Value = txtMaking.Text;
dgSalesItem.Rows[datagridId].Cells[8].Value = txtRate.Text;
this.datagridEdit = false;
var dgWeight = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[3].Value);
var dgMelting = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[5].Value);
var dgmaking = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[7].Value);
var dgrate = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[8].Value);
}
else
{
var kartType = "";
if (cmbKarat.SelectedIndex == 0)
{
kartType = "0";
}
else
{
kartType = cmbKarat.Text;
}
dgSalesItem.Rows.Add(id.ToString(), txtItemCode.Text, txtQty.Text, txtWeight.Text, cmbUnit.Text, kartType, txtKRate.Text, txtMaking.Text, txtRate.Text);
id = id + 1;
}
ttlMaking += Convert.ToDecimal(txtMaking.Text);
//ttlKarat += Convert.ToDecimal(cmbKarat.Text);
if (cmbUnit.Text == "Kg")
{
decimal grams = Convert.ToDecimal(txtWeight.Text) * 1000;
ttlWeight = ttlWeight + grams;
}
else
{
ttlWeight = ttlWeight + Convert.ToDecimal(txtWeight.Text);
}
ttlRate = ttlRate + Convert.ToDecimal(txtRate.Text);
}
txtTotalMaking.Text = ttlMaking.ToString();
//txtTotalKarat.Text = ttlKarat.ToString();
double kg = Convert.ToDouble(ttlWeight) / 1000;
if (kg > 0)
{
txtTotalWeight.Text = kg.ToString();
lblUnit.Text = "Kg";
}
else
{
txtTotalWeight.Text = ttlWeight.ToString();
lblUnit.Text = "Gram";
}
txtTotalRate.Text = amtFormat.comma(ttlRate).ToString();
clearDetails();
txtItemCode.Focus();
errorProvider1.Clear();
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
var rats = Convert.ToDecimal(txtTotalRate.Text.Trim().ToString());
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(rats)).ToLower();
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void SalesMaster_Load(object sender, EventArgs e)
{
try
{
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd-MM-yyyy";
clear();
clearDetails();
_entities = new MicroAccountsEntities1();
var gId = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Debtors").FirstOrDefault().groupId;
var ledgerNameAutoComplete = _entities.tbl_AccLedger.Where(x => x.groupId == gId);
txtLedgerName.AutoCompleteCustomSource.Clear();
foreach (var item in ledgerNameAutoComplete)
{
txtLedgerName.AutoCompleteCustomSource.Add(item.ledgerName.ToString());
}
_entities = new MicroAccountsEntities1();
var itemCodeAutoComplete = _entities.tbl_ItemMaster;
txtItemCode.AutoCompleteCustomSource.Clear();
foreach (var item in itemCodeAutoComplete)
{
txtItemCode.AutoCompleteCustomSource.Add(item.itemCode.ToString());
}
//Edit load
if (passedSid != 0)
{
clear();
clearDetails();
btnCreate.Text = "Update";
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_SalesMaster.Where(x => x.sId == passedSid).FirstOrDefault();
txtBillNo.Text = data.billNo;
dateTimePicker1.Text = data.date.ToString();
txtLedgerName.Text = _entities.tbl_AccLedger.Where(x => x.Id == data.ledgerId).FirstOrDefault().ledgerName;
txtTotalKarat.Text = data.totalKarat.ToString();
txtTotalMaking.Text = data.totalMaking.ToString();
txtTotalRate.Text = data.totalAmt.ToString();
txtTotalWeight.Text = data.totalWeight.ToString();
ttlWeight = Convert.ToDecimal(txtTotalWeight.Text) * 1000;
ttlKarat = Convert.ToDecimal(txtTotalKarat.Text);
ttlRate = Convert.ToDecimal(txtTotalRate.Text);
ttlMaking = Convert.ToDecimal(txtTotalMaking.Text);
txtAmtInWords.Text = "";
ConvertNoToWord convertToWord = new ConvertNoToWord();
//int totalRate = Convert.ToInt32(txtTotalRate.Text);
txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(data.totalAmt)).ToLower();
_entities = new MicroAccountsEntities1();
var salesDetailsData = _entities.tbl_SalesDetails.Where(x => x.salesId == passedSid).ToList();
id = 1;
foreach (var item in salesDetailsData)
{
var itemCode = _entities.tbl_ItemMaster.Where(x => x.id == item.productId).FirstOrDefault().itemCode;
dgSalesItem.Rows.Add(
id.ToString(),
itemCode,
item.qty,
item.weight,
item.unit,
item.karat,
item.making,
item.rate);
id = id + 1;
}
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}