void dataGridBind()
{
try
{
int rowNo = 1;
dgSalesDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <SalesMasterVM> modelList = new List <SalesMasterVM>();
var data = _entities.tbl_SalesMaster.OrderByDescending(x => x.sId);
foreach (var item in data)
{
SalesMasterVM model = new SalesMasterVM();
model.rowNo = rowNo;
model.sId = item.sId;
model.billNo = item.billNo;
model.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
model.date = 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);
rowNo++;
}
dgSalesDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void datagridBind()
{
try
{
dgReceivableAmt.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_AccLedger.Where(x => x.tbl_AccGroup.groupName == "Sundry Creditors").ToList();
List <LedgerDetailsVM> modelList = new List <LedgerDetailsVM>();
decimal ttlAmt = 0;
foreach (var item in data)
{
LedgerDetailsVM model = new LedgerDetailsVM();
CrDrDifference crdrDiff = new CrDrDifference();
string valueAmt = crdrDiff.DifferenceCrDr(Convert.ToInt32(item.Id), 0);
string valueAmtDR = valueAmt.Substring(0, 2);
if (valueAmtDR == "Cr")
{
string pAmtString = valueAmt.Substring(3);
model.rowNo = rowNo;
model.id = item.Id;
model.ledgerName = item.ledgerName.ToString();
model.pendingAmt = Convert.ToDecimal(amtFormat.comma(Convert.ToDecimal(pAmtString)));
rowNo++;
modelList.Add(model);
ttlAmt += Convert.ToDecimal(pAmtString);
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
}
dgReceivableAmt.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
}
}
private void dgPaymentDetails_DoubleClick(object sender, EventArgs e)
{
if (dgPaymentDetails.CurrentRow.Index != -1)
{
_entities = new MicroAccountsEntities1();
var gID = Convert.ToInt32(dgPaymentDetails.CurrentRow.Cells[0].Value);
var data = _entities.tbl_Entry.Where(x => x.voucherRefNo == gID).FirstOrDefault();
// txtGroupName.Text = lblhiddenGName.Text = data.groupName;
cmbLedgerDR.SelectedValue = data.drId;
cmbLedgerCR.SelectedValue = data.crId;
updateVouId = data.voucherRefNo;
txtAmt.Text = amtFormat.comma(data.amt).ToString();
txtRemark.Text = data.remarks;
btnCreate.Text = "Update";
}
}
private void cmbKarat_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
_entities = new MicroAccountsEntities1();
var dateToday = DateTime.Now.Date;
if (cmbKarat.SelectedIndex == 0)
{
var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().eighteenC;
amtFormat = new AmtFormatting();
txtKRate.Text = amtFormat.comma(rate);
}
else if (cmbKarat.SelectedIndex == 1)
{
var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().twentyTwoC;
amtFormat = new AmtFormatting();
txtKRate.Text = amtFormat.comma(rate);
}
else if (cmbKarat.SelectedIndex == 2)
{
var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().twentyThreeC;
amtFormat = new AmtFormatting();
txtKRate.Text = amtFormat.comma(rate);
}
else if (cmbKarat.SelectedIndex == 3)
{
var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().fineGold;
amtFormat = new AmtFormatting();
txtKRate.Text = amtFormat.comma(rate);
}
else if (cmbKarat.SelectedIndex == 4)
{
var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().hallmark;
amtFormat = new AmtFormatting();
txtKRate.Text = amtFormat.comma(rate);
}
}
catch (Exception x)
{
}
}
private void DashBoard_Load(object sender, EventArgs e)
{
try
{
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd-MM-yyyy";
dateTimePicker2.Format = DateTimePickerFormat.Custom;
dateTimePicker2.CustomFormat = "dd-MM-yyyy";
dataGridBind();
_entities = new MicroAccountsEntities1();
DateTime todayDate = DateTime.Today.Date;
var data = _entities.DailyRates.Where(x => x.date == todayDate).FirstOrDefault();
if (data == null)
{
btnEnterRates.Enabled = true;
}
else
{
btnEnterRates.Enabled = false;
}
lblFine.Text = amtFormat.comma(data.fineGold).ToString();
lbl22C.Text = amtFormat.comma(data.twentyTwoC).ToString();
lbl23C.Text = amtFormat.comma(data.twentyThreeC).ToString();
lblhallMarkBuyBack.Text = amtFormat.comma(data.hallmarkBuyBack).ToString();
lblHallMark.Text = amtFormat.comma(data.hallmark).ToString();
lblSilver.Text = amtFormat.comma(data.silver).ToString();
}
catch (Exception x)
{
}
}
private void datagridBind(string type)
{
try
{
dgPurchaseReport.AutoGenerateColumns = false;
dgSalesReport.AutoGenerateColumns = false;
ttlAmt = 0;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>();
List <SalesMasterVM> modelListSales = new List <SalesMasterVM>();
List <tbl_SalesMaster> dataSales = new List <tbl_SalesMaster>();
if (type == "--All--")
{
#region PurchaseData
data = _entities.tbl_PurchaseMaster.ToList();
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
DateTime dt = Convert.ToDateTime(item.date).Date;
model.monthYear = dt.Date.ToString("dd-MM-yyyy");
model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt));
rowNo++;
modelList.Add(model);
ttlAmt += Convert.ToDecimal(item.totalAmt);
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
dgPurchaseReport.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
#endregion
#region Salesregion
ttlAmt = 0;
rowNo = 1;
dataSales = new List <tbl_SalesMaster>();
dataSales = _entities.tbl_SalesMaster.ToList();
foreach (var item in dataSales)
{
SalesMasterVM model = new SalesMasterVM();
model.rowNo = rowNo;
DateTime dt = Convert.ToDateTime(item.date).Date;
model.monthYear = dt.Date.ToString("dd-MM-yyyy");
model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt));
rowNo++;
modelListSales.Add(model);
ttlAmt += Convert.ToDecimal(item.totalAmt);
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
dgSalesReport.DataSource = modelListSales;
lblSalesRow.Text = modelList.Count.ToString();
#endregion
}
else if (type == "Month")
{
#region Purchase Data
ttlAmt = 0;
rowNo = 1;
dgPurchaseReport.DataSource = null;
dgPurchaseReport.Rows.Clear();
_entities = new MicroAccountsEntities1();
data = new List <tbl_PurchaseMaster>();
data = _entities.tbl_PurchaseMaster.ToList();
string dates = "";
decimal?amt = 0;
int rowId = -1;
foreach (var item in data)
{
var date = Convert.ToDateTime(item.date).Date;
string dd = date.ToString("MMM");
if (dd != dates)
{
dgPurchaseReport.Rows.Add("0", rowNo, dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.totalAmt;
dgPurchaseReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblTotalRows.Text = rowNo.ToString();
#endregion
#region Sales Data
ttlAmt = 0;
rowNo = 1;
dgSalesReport.DataSource = null;
dgSalesReport.Rows.Clear();
_entities = new MicroAccountsEntities1();
dataSales = new List <tbl_SalesMaster>();
dataSales = _entities.tbl_SalesMaster.ToList();
dates = "";
amt = 0;
rowId = -1;
foreach (var item in dataSales)
{
var date = Convert.ToDateTime(item.date).Date;
string dd = date.ToString("MMM");
if (dd != dates)
{
dgSalesReport.Rows.Add("0", rowNo, dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.totalAmt;
dgSalesReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblSalesRow.Text = rowNo.ToString();
#endregion
}
else
{
#region Purchase Data
ttlAmt = 0;
rowNo = 1;
dgPurchaseReport.DataSource = null;
dgPurchaseReport.Rows.Clear();
_entities = new MicroAccountsEntities1();
data = new List <tbl_PurchaseMaster>();
data = _entities.tbl_PurchaseMaster.ToList();
string dates = "";
decimal?amt = 0;
int rowId = -1;
foreach (var item in data)
{
var date = Convert.ToDateTime(item.date).Date;
string dd = date.ToString("yyyy");
if (dd != dates)
{
dgPurchaseReport.Rows.Add("0", rowNo, dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.totalAmt;
dgPurchaseReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblTotalRows.Text = rowNo.ToString();
#endregion
#region Sales Data
ttlAmt = 0;
rowNo = 1;
dgSalesReport.DataSource = null;
dgSalesReport.Rows.Clear();
_entities = new MicroAccountsEntities1();
dataSales = new List <tbl_SalesMaster>();
dataSales = _entities.tbl_SalesMaster.ToList();
dates = "";
amt = 0;
rowId = -1;
foreach (var item in dataSales)
{
var date = Convert.ToDateTime(item.date).Date;
string dd = date.ToString("yyyy");
if (dd != dates)
{
dgSalesReport.Rows.Add("0", rowNo, dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.totalAmt;
dgSalesReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblSalesRow.Text = rowNo.ToString();
#endregion
}
}
catch (Exception x)
{
}
}
private void PaymentReceiptBillReference_Load(object sender, EventArgs e)
{
try
{
// if (passedVoucherType == 1)
{
//payment mate
_entities = new MicroAccountsEntities1();
var isDataPresent = _entities.tbl_EntryDetails.Where(x => x.voucherRefNo == this.passedVoucherNo).FirstOrDefault();
if (isDataPresent == null)
{
cmbBillRef.SelectedIndex = -1;
cmbBInd(idPassedToCmbArray);
}
else
{
AmtFormatting amtFormat = new AmtFormatting();
comestoUpdate = true;
cmbRefType.SelectedIndex = 1;
idPassedToCmbArray = new List <long?>();
idPassedToCmbArray.Add(0);
cmbBInd(idPassedToCmbArray); //calling combobox method
btnCreate.Text = "Update";
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_EntryDetails.Where(x => x.voucherRefNo == this.passedVoucherNo).ToList();
int id = 1;
idPassedToCmbArray = new List <long?>();
foreach (var item in data)
{
idPassedToCmbArray.Add(item.purchaseSalesIds);
// paymentDetailsTotalAmt += item.amtPaid;
var billNo = _entities.tbl_PurchaseMaster.Where(x => x.pId == item.purchaseSalesIds).FirstOrDefault();
dgBillRef.Rows.Add(
item.purchaseSalesIds,
"#",
billNo.refNo,
billNo.date,
amtFormat.comma(item.amtPaid),
item.pDetailsId
);
id = id + 1;
}
datagridId = data.Count;
lblRows.Text = datagridId.ToString() + " Rows";
}
}
//else
{
//receipt mate
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
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 showAvailableData()
{
clear();
clearDetails();
btnCreate.Text = "Update";
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault();
txtRefNo.Text = data.refNo;
dateTimePicker1.Text = data.date.ToString();
txtLedgerName.Text = _entities.tbl_AccLedger.Where(x => x.Id == data.ledgerId).FirstOrDefault().ledgerName;
txtTotalMelting.Text = data.totalMelting.ToString();
txtTotalMaking.Text = data.totalMaking.ToString();
txtTotalAmt.Text = amtFormat.comma(data.totalAmt).ToString();
txtTotalWeight.Text = data.totalWeight.ToString();
txtTotalFine.Text = data.totalFine.ToString();
txtTotalPurchMelting.Text = data.totalPurchaseMelting.ToString();
ttlWeight = Convert.ToDecimal(txtTotalWeight.Text) * 1000;
ttlMelting = Convert.ToDecimal(txtTotalMelting.Text);
ttlRate = Convert.ToDecimal(txtTotalAmt.Text);
ttlMaking = Convert.ToDecimal(txtTotalMaking.Text);
ttlFine = Convert.ToDecimal(txtTotalFine.Text);
ttlPurchaseMelting = Convert.ToDecimal(txtTotalPurchMelting.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 purchaseDetailsData = _entities.tbl_PurchaseDetail.Where(x => x.purchaseID == passedPid).ToList();
id = 1;
foreach (var item in purchaseDetailsData)
{
var itemCode = _entities.tbl_ItemMaster.Where(x => x.id == item.productID).FirstOrDefault().itemCode;
dgPurchaseItem.Rows.Add(
id.ToString(),
itemCode,
item.qty,
item.weight,
item.unit,
item.karat,
item.kRate,
item.melting,
item.purchaseMelting,
item.fine,
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;
}