private void button1_Click(object sender, EventArgs e)
{
try
{
int rowNo = 1;
List <SalesMasterVM> modelList = new List <SalesMasterVM>();
List <tbl_SalesMaster> data = new List <tbl_SalesMaster>();
DateTime fromdate = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
DateTime todate = DateTime.ParseExact(dateTimePicker2.Text, "dd-MM-yyyy", null);
if (fromdate > todate)
{
MessageBox.Show("Invalid date entered. Select valid dates");
return;
}
else
{
if (txtSearch.Text == string.Empty)
{
data = _entities.tbl_SalesMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.sId).ToList();
}
else
{
data = _entities.tbl_SalesMaster.Where(x => x.date >= fromdate && x.date <= todate && x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.sId).ToList();
}
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 = 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");
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)
{
}
}
private void addSalesMaster()
{
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_SalesMaster.Where(x => x.sId == passedId).ToList();
List <SalesMasterVM> listVm = new List <SalesMasterVM>();
List <LedgerDetailsVM> LedgerlistVm = new List <LedgerDetailsVM>();
foreach (var item in data)
{
SalesMasterVM vm = new SalesMasterVM();
vm.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy");
vm.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName.Trim();
vm.ledgerId = item.ledgerId;
vm.sId = item.sId;
vm.billNo = item.billNo;
vm.remarks = item.remarks;
vm.totalMaking = item.totalMaking;
vm.totalKarat = item.totalKarat;
vm.totalWeight = item.totalWeight;
vm.unit = item.unit;
AmtFormatting amtFormat = new AmtFormatting();
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);
}
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 txtLedgerName_KeyUp(object sender, KeyEventArgs e)
{
try
{
int rowNo = 1;
dgSalesDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <SalesMasterVM> modelList = new List <SalesMasterVM>();
var data = _entities.tbl_SalesMaster.Where(x => x.billNo.Contains(txtSearch.Text) || x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text)).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 = 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");
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("Something went wrong. Contact your system administrator");
}
}
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 dataBind()
{
try
{
// if (dgBillRef.Rows.Count > 0)
{
int count = 0;
var id = Convert.ToInt32(cmbBillRef.SelectedValue);
//int checkDatagridId = Convert.ToInt32(dgBillRef.Rows[datagridId].Cells[0].Value);
foreach (DataGridViewRow dr in dgBillRef.Rows)
{
if (Convert.ToInt32(dr.Cells[0].Value) == id)
{
count = 1;
}
}
if (count != 1 && !deleteDataGridRow)
{
if (passedAmt > 0)
{
if (datagridId == 0)
{
idPassedToCmbArray = new List <long?>();
}
_entities = new MicroAccountsEntities1();
if (passedVoucherType == 1)
{
#region for Purchase(Payment)
var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == id).FirstOrDefault();
PurchaseMasterVM pvm = new PurchaseMasterVM();
pvm.IdForGrid = data.pId;
pvm.refNoBillNoForGrid = data.refNo;
var checkPayDetailsData = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == id).ToList();
if (checkPayDetailsData != null)
{
foreach (var item in checkPayDetailsData)
{
totalAmtPaymentDetails += item.amtPaid;
}
totalAmtPaymentDetails = data.totalAmt - totalAmtPaymentDetails;
}
else
{
totalAmtPaymentDetails = data.totalAmt;
}
pvm.totalAmt = totalAmtPaymentDetails;
dgBillRef.Rows.Add(pvm);
dgBillRef.Rows[datagridId].Cells[0].Value = data.pId;
dgBillRef.Rows[datagridId].Cells[1].Value = "#";
dgBillRef.Rows[datagridId].Cells[2].Value = data.refNo;
dgBillRef.Rows[datagridId].Cells[3].Value = data.date;
if (totalAmtPaymentDetails > passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt;
}
else if (totalAmtPaymentDetails < passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = totalAmtPaymentDetails;
idPassedToCmbArray.Add(data.pId);
cmbBInd(idPassedToCmbArray);
}
else if (totalAmtPaymentDetails == passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt;
idPassedToCmbArray.Add(data.pId);
cmbBInd(idPassedToCmbArray);
}
passedAmt = passedAmt - Convert.ToDecimal(dgBillRef.Rows[datagridId].Cells[4].Value);
datagridId++;
lblRows.Text = datagridId.ToString() + " Rows"; //Number of rows showing label
count = 0;
#endregion
}
else if (passedVoucherType == 2)
{
#region for Sales(Receipt)
var data = _entities.tbl_SalesMaster.Where(x => x.sId == id).FirstOrDefault();
SalesMasterVM pvm = new SalesMasterVM();
pvm.IdForGrid = data.sId;
pvm.refNoBillNoForGrid = data.billNo;
var checkPayDetailsData = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == id).ToList();
if (checkPayDetailsData != null)
{
foreach (var item in checkPayDetailsData)
{
totalAmtPaymentDetails += item.amtPaid;
}
totalAmtPaymentDetails = data.totalAmt - totalAmtPaymentDetails;
}
else
{
totalAmtPaymentDetails = data.totalAmt;
}
pvm.totalAmt = totalAmtPaymentDetails;
dgBillRef.Rows.Add(pvm);
dgBillRef.Rows[datagridId].Cells[0].Value = data.sId;
dgBillRef.Rows[datagridId].Cells[1].Value = "#";
dgBillRef.Rows[datagridId].Cells[2].Value = data.billNo;
dgBillRef.Rows[datagridId].Cells[3].Value = data.date;
if (totalAmtPaymentDetails > passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt;
}
else if (totalAmtPaymentDetails < passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = totalAmtPaymentDetails;
idPassedToCmbArray.Add(data.sId);
cmbBInd(idPassedToCmbArray);
}
else if (totalAmtPaymentDetails == passedAmt)
{
dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt;
idPassedToCmbArray.Add(data.sId);
cmbBInd(idPassedToCmbArray);
}
passedAmt = passedAmt - Convert.ToDecimal(dgBillRef.Rows[datagridId].Cells[4].Value);
datagridId++;
lblRows.Text = datagridId.ToString() + " Rows"; //Number of rows showing label
count = 0;
#endregion
}
}
//else
//{
// MessageBox.Show("Something went wrong. Cannot add this row.");
//}
}
//else
//{
// MessageBox.Show("Cannot add same row.");
//}
}
}
catch (Exception x)
{
}
}
