protected void Search_Click(object sender, EventArgs e)
{
int tempBranchId = Convert.ToInt32(PMDropdownlist.SelectedItem.Value);
// string fdt = datepicker.Text;
//string tdt = datepicker1.Text;
DateTime tdt;
if (datepicker1.Text != "")
{
tdt = DateTime.Parse(datepicker1.Text);
}
else
{
tdt = System.DateTime.Now;
}
DateTime fdt = DateTime.Parse(datepicker.Text);
try
{
using (AdvInvSystemEntities dbobj = new AdvInvSystemEntities())
{
IEnumerable <sp_Search_Expense_Result> se = dbobj.sp_Search_Expense(tempBranchId, fdt, tdt);
GridView1.DataSource = se;
GridView1.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void Search_Click(object sender, EventArgs e)
{
int tempBranchId = Convert.ToInt32(PMDropdownlist.SelectedItem.Value);
DateTime tdt;
if (datepicker1.Text != "")
{
tdt = DateTime.Parse(datepicker1.Text);
}
else
{
tdt = System.DateTime.Now;
}
DateTime fdt = DateTime.Parse(datepicker.Text);
try
{
using (AdvInvSystemEntities dbobj = new AdvInvSystemEntities())
{
GridView1.DataSource = dbobj.sp_search_saleInvoices(tempBranchId, fdt, tdt).ToList();
GridView1.DataBind();
GridView2.DataSource = dbobj.sp_search_purchaseInvoices(tempBranchId, fdt, tdt).ToList();
GridView2.DataBind();
GridView3.DataSource = dbobj.sp_Search_Expense(tempBranchId, fdt, tdt).ToList();
GridView3.DataBind();
}
int tempSaleAm = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
tempSaleAm += Convert.ToInt32(GridView1.Rows[i].Cells[3].Text);
}
saleTxt.Text = tempSaleAm.ToString();
int tempPurcAm = 0;
for (int i = 0; i < GridView2.Rows.Count; i++)
{
tempPurcAm += Convert.ToInt32(GridView2.Rows[i].Cells[3].Text);
}
purchTxt.Text = tempPurcAm.ToString();
int tempExpAm = 0;
for (int i = 0; i < GridView3.Rows.Count; i++)
{
tempExpAm += Convert.ToInt32(GridView3.Rows[i].Cells[4].Text);
}
ExpTxt.Text = tempExpAm.ToString();
}
catch (Exception ex)
{
}
}
public void loadGv()
{
int tempBranchId = Convert.ToInt32(PMDropdownlist.SelectedItem.Value);
// string fdt = datepicker.Text;
//string tdt = datepicker1.Text;
DateTime tdt;
if (datepicker1.Text != "")
{
tdt = DateTime.Parse(datepicker1.Text);
}
else
{
tdt = System.DateTime.Now;
}
DateTime fdt = DateTime.Parse(datepicker.Text);
try
{
using (AdvInvSystemEntities dbobj = new AdvInvSystemEntities())
{
// IEnumerable<sp_search_purchaseInvoices_Result> spi = dbobj.sp_search_purchaseInvoices(tempBranchId, fdt, tdt);
var spi = dbobj.sp_Search_Expense(tempBranchId, fdt, tdt).ToList();
GridView1.DataSource = spi;
GridView1.DataBind();
int tempPurcAm = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
tempPurcAm += Convert.ToInt32(GridView1.Rows[i].Cells[5].Text);
}
tSale.Visible = true;
tSaleTxt.Text = tempPurcAm.ToString();
}
}
catch (Exception)
{
}
}
protected void tdp_TextChanged(object sender, EventArgs e)
{
DateTime tdt;
if (datept.Text != "")
{
tdt = DateTime.Parse(datept.Text);
}
else
{
tdt = System.DateTime.Now;
}
DateTime fdt = DateTime.Parse(datepf.Text);
try
{
using (AdvInvSystemEntities dbobj = new AdvInvSystemEntities())
{
// Sale invoice for shop
var si = dbobj.sp_search_saleInvoices(1, fdt, tdt).ToList();
TSaleInv1 = si.Count().ToString();
for (int i = 0; i < si.Count(); i++)
{
TSaleAmount1 += si[i].Amount;
TSalePayable += si[i].Payable;
TSaleDiscount += Convert.ToInt32(si[i].Discount);
TSalePaid += si[i].Paid;
TSaleCredit = TSalePayable - TSalePaid;
}
// Sale invoice for Factory
var si1 = dbobj.sp_search_saleInvoices(2, fdt, tdt).ToList();
TSaleInv2 = si1.Count().ToString();
for (int i = 0; i < si1.Count(); i++)
{
TSaleAmount2 += si1[i].Amount;
TSalePayable2 += si1[i].Payable;
TSaleDiscount2 += Convert.ToInt32(si1[i].Discount);
TSalePaid2 += si1[i].Paid;
TSaleCredit2 = TSalePayable2 - TSalePaid2;
}
var pi = dbobj.sp_search_purchaseInvoices(1, fdt, tdt).ToList();
TPurchaseInv = pi.Count();
for (int i = 0; i < pi.Count(); i++)
{
TPurchasePay += pi[i].Amount;
TPurchasePaid += pi[i].Paid;
TPurchaseRemain = TPurchasePay - TPurchasePaid;
}
var pi1 = dbobj.sp_search_purchaseInvoices(2, fdt, tdt).ToList();
TPurchaseInv1 = pi1.Count();
for (int i = 0; i < pi1.Count(); i++)
{
TPurchasePay1 += pi1[i].Amount;
TPurchasePaid1 += pi1[i].Paid;
TPurchaseRemain1 = TPurchasePay1 - TPurchasePaid1;
}
var exp = dbobj.sp_Search_Expense(1, fdt, tdt).ToList();
for (int i = 0; i < exp.Count; i++)
{
TExpense += exp[i].Amount;
}
var exp1 = dbobj.sp_Search_Expense(2, fdt, tdt).ToList();
for (int i = 0; i < exp1.Count; i++)
{
TExpense1 += exp1[i].Amount;
}
var exc = dbobj.sp_Search_Exclude(1, fdt, tdt).ToList();
for (int i = 0; i < exc.Count; i++)
{
Exclude += Convert.ToInt32(exc[i].Worth);
}
var exc1 = dbobj.sp_Search_Exclude(2, fdt, tdt).ToList();
for (int i = 0; i < exc1.Count; i++)
{
Exclude1 += Convert.ToInt32(exc1[i].Worth);
}
var st = dbobj.sp_finalStockList(1).ToList();
for (int i = 0; i < st.Count; i++)
{
StockSale += st[i].SalePrice * st[i].Quantity;
StockPurch += st[i].PurchasePrice * st[i].Quantity;
}
var st1 = dbobj.sp_finalStockList(2).ToList();
for (int i = 0; i < st1.Count; i++)
{
StockSale1 += st1[i].SalePrice * st1[i].Quantity;
StockPurch1 += st1[i].PurchasePrice * st1[i].Quantity;
}
var acc = (from a in dbobj.Accounts where a.AccountId == 1 select a).First();
AccBal = Convert.ToInt32(acc.CurrentBalance);
var acc1 = (from a in dbobj.Accounts where a.AccountId == 2 select a).First();
AccBal1 = Convert.ToInt32(acc1.CurrentBalance);
}
}
catch (Exception)
{
}
}
