private void button1_Click(object sender, EventArgs e)
{
try
{
int rowNo = 1;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <PurchaseMasterVM> purchaseMasterList = new List <PurchaseMasterVM>();
List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>();
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_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.pId).ToList();
}
else
{
data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate && x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList();
}
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
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 = item.totalAmt;
model.totalMelting = item.totalMelting;
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");
purchaseMasterList.Add(model);
rowNo++;
}
dgPurchaseDetails.DataSource = purchaseMasterList;
lblTotalRows.Text = purchaseMasterList.Count.ToString();
}
}
catch (Exception x)
{
}
}
private void txtSearch_KeyUp(object sender, KeyEventArgs e)
{
try
{
int rowNo = 1;
dgPurchaseDetails.AutoGenerateColumns = false;
totalAmts = 0;
if (txtSearch.Text == string.Empty)
{
dataGridBind();
return;
}
_entities = new KBBQEntities();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text.Trim()) || x.partyName.Contains(txtSearch.Text.Trim())).OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
model.partyName = item.partyName;
model.remarks = item.remarks;
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");
}
totalAmts += item.totalAmt;
modelList.Add(model);
rowNo++;
}
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
lblTotalAmt.Text = amtFormat.comma(totalAmts);
}
catch (Exception x)
{
}
}
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 dataGridBind()
{
try
{
int rowNo = 1;
totalAmts = 0;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
model.partyName = item.partyName;
model.remarks = item.remarks;
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);
totalAmts += item.totalAmt;
rowNo++;
}
lblTotalAmt.Text = amtFormat.comma(totalAmts);
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
void dataGridBind()
{
try
{
int rowNo = 1;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
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.totalMelting = item.totalMelting;
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++;
}
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
private void txtSearch_KeyUp(object sender, KeyEventArgs e)
{
try
{
int rowNo = 1;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
var data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text) || x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text)).OrderByDescending(x => x.pId);
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
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.totalMelting = item.totalMelting;
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++;
}
dgPurchaseDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.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 cmbBInd(List <long?> val)
{
_entities = new MicroAccountsEntities1();
// var idss = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId).FirstOrDefault().pId;
// var checkBillNo=_entities.tbl_PaymentDetails.Where(x=>x.purchaseId==)
if (passedVoucherType == 1)
{
#region for purchase(Payment)
List <tbl_PurchaseMaster> data;
if (val.Contains(0) || val.Count == 0)
{
data = new List <tbl_PurchaseMaster>();
data = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId).ToList();
}
else
{
data = new List <tbl_PurchaseMaster>();
data = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId && !val.Contains(x.pId)).ToList();
}
List <PurchaseMasterVM> modelLst = new List <PurchaseMasterVM>();
PurchaseMasterVM model = new PurchaseMasterVM();
model.combineRefNo = "--Select--";
modelLst.Add(model);
foreach (var item in data)
{
var dataPaymentDetails = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == item.pId).ToList();
foreach (var items in dataPaymentDetails)
{
paymentDetailsTotalAmt += items.amtPaid;
}
if ((item.totalAmt - paymentDetailsTotalAmt) >= 0)
{
model = new PurchaseMasterVM();
model.pId = item.pId;
model.combineRefNo = "Ref. No: " + item.refNo + " | Amount: " + (item.totalAmt - paymentDetailsTotalAmt);
modelLst.Add(model);
}
paymentDetailsTotalAmt = 0;
}
cmbBillRef.DataSource = modelLst;
cmbBillRef.DisplayMember = "combineRefNo";
cmbBillRef.ValueMember = "pId";
#endregion
}
else
{
#region for Sales(Receipt)
List <tbl_SalesMaster> data;
if (val.Contains(0) || val.Count == 0)
{
data = new List <tbl_SalesMaster>();
data = _entities.tbl_SalesMaster.Where(x => x.ledgerId == passedLedgerId).ToList();
}
else
{
data = new List <tbl_SalesMaster>();
data = _entities.tbl_SalesMaster.Where(x => x.ledgerId == passedLedgerId && !val.Contains(x.sId)).ToList();
}
List <PurchaseMasterVM> modelLst = new List <PurchaseMasterVM>();
PurchaseMasterVM model = new PurchaseMasterVM();
model.combineRefNo = "--Select--";
modelLst.Add(model);
foreach (var item in data)
{
var dataPaymentDetails = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == item.sId).ToList();
foreach (var items in dataPaymentDetails)
{
paymentDetailsTotalAmt += items.amtPaid;
}
if ((item.totalAmt - paymentDetailsTotalAmt) >= 0)
{
model = new PurchaseMasterVM();
model.pId = item.sId;
model.combineRefNo = "Ref. No: " + item.billNo + " | Amount: " + (item.totalAmt - paymentDetailsTotalAmt);
modelLst.Add(model);
}
paymentDetailsTotalAmt = 0;
}
cmbBillRef.DataSource = modelLst;
cmbBillRef.DisplayMember = "combineRefNo";
cmbBillRef.ValueMember = "pId";
#endregion
}
}
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)
{
}
}
private void datagridBind(string type)
{
try
{
dgPurchaseReport.AutoGenerateColumns = false;
dgSalesReport.AutoGenerateColumns = false;
ttlAmt = 0;
int rowNo = 1;
_entities = new KBBQEntities();
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>();
List <DetailSettlementVM> modelListSales = new List <DetailSettlementVM>();
List <detailsSettlement> dataSales = new List <detailsSettlement>();
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));
model.KOT = item.refNo;
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 <detailsSettlement>();
dataSales = _entities.detailsSettlements.ToList();
foreach (var item in dataSales)
{
DetailSettlementVM model = new DetailSettlementVM();
model.rowNo = rowNo;
DateTime dt = Convert.ToDateTime(item.paidDate).Date;
model.monthYear = dt.Date.ToString("dd-MM-yyyy");
model.AmountPaid = Convert.ToDecimal(amtFormat.comma(item.bill));
model.KOT = item.receiptno;
rowNo++;
modelListSales.Add(model);
ttlAmt += Convert.ToDecimal(item.bill);
_entities = new KBBQEntities();
var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault();
if (checkForAdvancePay != null)
{
ttlAmt += checkForAdvancePay.advancePayment;
model.advancePaid = checkForAdvancePay.advancePayment;
}
else
{
model.advancePaid = 0;
}
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 KBBQEntities();
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[4].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblTotalRows.Text = modelList.Count.ToString();
#endregion
#region Sales Data
ttlAmt = 0;
rowNo = 1;
dgSalesReport.DataSource = null;
dgSalesReport.Rows.Clear();
_entities = new KBBQEntities();
dataSales = new List <detailsSettlement>();
dataSales = _entities.detailsSettlements.ToList();
dates = "";
amt = 0;
rowId = -1;
decimal?advPay = 0;
foreach (var item in dataSales)
{
var date = Convert.ToDateTime(item.paidDate).Date;
string dd = date.ToString("MMM");
if (dd != dates)
{
dgSalesReport.Rows.Add("0", rowNo, "--", dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.bill;
dgSalesReport.Rows[rowId].Cells[5].Value = amtFormat.comma(amt);
ttlAmt += item.bill;
_entities = new KBBQEntities();
var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault();
if (checkForAdvancePay != null)
{
ttlAmt += checkForAdvancePay.advancePayment;
advPay += checkForAdvancePay.advancePayment;
dgSalesReport.Rows[rowId].Cells[4].Value = advPay;
}
rowNo++;
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblSalesRow.Text = modelList.Count.ToString();
#endregion
}
else
{
#region Purchase Data
ttlAmt = 0;
rowNo = 1;
dgPurchaseReport.DataSource = null;
dgPurchaseReport.Rows.Clear();
_entities = new KBBQEntities();
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[4].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.totalAmt;
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblTotalRows.Text = modelList.Count.ToString();
#endregion
#region Sales Data
ttlAmt = 0;
rowNo = 1;
dgSalesReport.DataSource = null;
dgSalesReport.Rows.Clear();
_entities = new KBBQEntities();
dataSales = new List <detailsSettlement>();
dataSales = _entities.detailsSettlements.ToList();
dates = "";
amt = 0;
rowId = -1;
decimal?advPay = 0;
foreach (var item in dataSales)
{
var date = Convert.ToDateTime(item.paidDate).Date;
string dd = date.ToString("yyyy");
if (dd != dates)
{
dgSalesReport.Rows.Add("0", rowNo, "--", dd);
dates = dd;
amt = 0;
rowId++;
}
amt += item.bill;
dgSalesReport.Rows[rowId].Cells[5].Value = amtFormat.comma(amt);
rowNo++;
ttlAmt += item.bill;
_entities = new KBBQEntities();
var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault();
if (checkForAdvancePay != null)
{
ttlAmt += checkForAdvancePay.advancePayment;
advPay += checkForAdvancePay.advancePayment;
dgSalesReport.Rows[rowId].Cells[4].Value = advPay;
}
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
lblSalesRow.Text = modelList.Count.ToString();
#endregion
}
}
catch (Exception x)
{
}
}
private void btnDatSearcsh_Click(object sender, EventArgs e)
{
DateTime fromdate = DateTime.ParseExact(dtpFromDate.Text, "dd-MM-yyyy", null);
DateTime todate = DateTime.ParseExact(dtpToDate.Text, "dd-MM-yyyy", null);
if (todate.Date < fromdate.Date)
{
MessageBox.Show("Invalid Date Entered", "Error - King Bar beque Restaurant", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtpToDate.Focus();
return;
}
List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>();
List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>();
List <DetailSettlementVM> modelListSales = new List <DetailSettlementVM>();
List <detailsSettlement> dataSales = new List <detailsSettlement>();
#region PurchaseData
_entities = new KBBQEntities();
data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).ToList();
int rowNo = 1;
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));
model.KOT = item.refNo;
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 <detailsSettlement>();
dataSales = _entities.detailsSettlements.Where(x => x.paidDate >= fromdate && x.paidDate <= todate).ToList();
foreach (var item in dataSales)
{
DetailSettlementVM model = new DetailSettlementVM();
model.rowNo = rowNo;
DateTime dt = Convert.ToDateTime(item.paidDate).Date;
model.monthYear = dt.Date.ToString("dd-MM-yyyy");
model.AmountPaid = Convert.ToDecimal(amtFormat.comma(item.bill));
model.KOT = item.receiptno;
rowNo++;
modelListSales.Add(model);
ttlAmt += Convert.ToDecimal(item.bill);
lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
dgSalesReport.DataSource = modelListSales;
lblSalesRow.Text = modelList.Count.ToString();
#endregion
}
private void RptPurchase_Load(object sender, EventArgs e)
{
try
{
cnn.Open();
//SqlDataAdapter dap = new SqlDataAdapter("SELECT tbl_PurchaseMaster.*, tbl_AccLedger.* FROM tbl_AccLedger INNER JOIN tbl_PurchaseMaster ON tbl_AccLedger.Id = tbl_PurchaseMaster.ledgerId where refNo='" + this.passedId + "'", cnn);
//PurchaseDataSet ds = new PurchaseDataSet();
//dap.Fill(ds, "DataTable1");
_en = new MicroAccountsEntities1();
var data = _en.tbl_PurchaseMaster.ToList();
List <PurchaseMasterVM> listVm = new List <PurchaseMasterVM>();
foreach (var item in data)
{
PurchaseMasterVM vm = new PurchaseMasterVM();
vm.ledgerName = _en.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
listVm.Add(vm);
}
ReportDataSource datasource = new ReportDataSource();
datasource.Name = "DataSet1";
datasource.Value = listVm;
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
ReportDataSource datasource1 = new ReportDataSource();
_en = new MicroAccountsEntities1();
var data1 = _en.tbl_PurchaseDetail.ToList();
List <PurchaseDetailsVM> DetailslistVm = new List <PurchaseDetailsVM>();
foreach (var item in data1)
{
PurchaseDetailsVM vm = new PurchaseDetailsVM();
vm.purchaseID = item.purchaseID;
DetailslistVm.Add(vm);
}
datasource1.Name = "DataSet2";
datasource1.Value = DetailslistVm;
this.reportViewer1.LocalReport.DataSources.Add(datasource1);
//reportViewer1.LocalReport.ReportEmbeddedResource = "Redport1.rdlc";
//ReportDataSource datasource = new ReportDataSource("PurchaseDataSet", ds.Tables[0]);
//this.reportViewer1.LocalReport.DataSources.Clear();
//this.reportViewer1.LocalReport.DataSources.Add(data.ToList());
this.reportViewer1.RefreshReport();
cnn.Close();
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
this.reportViewer1.RefreshReport();
//this.reportViewer1.RefreshReport();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
int rowNo = 1;
totalAmts = 0;
dgPurchaseDetails.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <PurchaseMasterVM> purchaseMasterList = new List <PurchaseMasterVM>();
List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>();
DateTime fromdate = DateTime.ParseExact(dateFrom.Text, "dd-MM-yyyy", null);
DateTime todate = DateTime.ParseExact(dateTo.Text, "dd-MM-yyyy", null);
if (fromdate > todate)
{
MessageBox.Show("Invalid date entered. Select valid dates");
return;
}
else
{
if (txtSearch.Text == string.Empty)
{
if (dateFrom.Text == DateTime.Now.Date.ToString("dd-MM-yyyy") && dateTo.Text == DateTime.Now.Date.ToString("dd-MM-yyyy"))
{
data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId).ToList();
}
else
{
data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.pId).ToList();
}
}
else
{
if (dateFrom.Text == DateTime.Now.Date.ToString("dd-MM-yyyy") && dateTo.Text == DateTime.Now.Date.ToString("dd-MM-yyyy"))
{
data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList();
}
else
{
data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate && x.refNo.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList();
}
}
foreach (var item in data)
{
PurchaseMasterVM model = new PurchaseMasterVM();
model.rowNo = rowNo;
model.pId = item.pId;
model.refNo = item.refNo;
model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy");
model.totalWeight = item.totalWeight;
model.totalAmt = 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");
}
purchaseMasterList.Add(model);
totalAmts += item.totalAmt;
rowNo++;
}
lblTotalAmt.Text = amtFormat.comma(totalAmts);
dgPurchaseDetails.DataSource = purchaseMasterList;
lblTotalRows.Text = purchaseMasterList.Count.ToString();
}
}
catch (Exception x)
{
}
}
