protected void insertdata()
{
BsolutionWebApp.Collecting object1 = new BsolutionWebApp.Collecting();
object1.Collecting_No = Int32.Parse(TextCollectingNo.Text);
object1.Collecting_Name = TextCollectingName.Text;
object1.Collecting_Note = TextBoxNote.Text;
object1.Collecting_Date = Convert.ToDateTime(datepicker.Text);
object1.IsDisable = false;
//object1.BankCashtype_Id = Int32.Parse(DropDownListbankcashtype.SelectedValue);
object1.BankorCash = int.Parse(ddChequeOrCash.SelectedValue);
object1.Invoice_Id = Int32.Parse(ddInvoice.SelectedValue);
object1.Contact_Id = Int32.Parse(ddContact.SelectedValue);
object1.Operation_Type_Id = Int32.Parse(ddOperationType.SelectedValue);
object1.Rectime = DateTime.Now;
object1.User_Id = 0;
DB.Collectings.InsertOnSubmit(object1);
DB.SubmitChanges();
bsclass bs = new bsclass();
if (ddChequeOrCash.SelectedValue == "0")
{
bs.AddBank(object1.Collecting_Id, false, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), object1.Collecting_Note, "+", "", 0, 0, false);
}
else if (ddChequeOrCash.SelectedValue == "1")
{
bs.Addcash(object1.Collecting_Id, false, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), object1.Collecting_Note, "+", "", 0, 0, false);
}
Labelid.Text = object1.Collecting_Id.ToString();
}
protected void insertdata()
{
Labelstatus.Text = "";
bsclass bs = new bsclass();
decimal balance = 0;
if (DropDownListbankcash.SelectedValue == "0")
{
balance = bs.checkblance(true, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
}
else if (DropDownListbankcash.SelectedValue == "1")
{
balance = bs.checkblance(false, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
}
if (balance >= Convert.ToDecimal(Convert.ToDouble(TextBoxunitcost.Text) * Convert.ToDouble(TextBoxquantity.Text)))
{
Expense newobject = new Expense();
newobject.Expenses_No = Convert.ToInt32(TextBoxExpensesNo.Text);
newobject.Expenses_Cost = Convert.ToDouble(TextBoxunitcost.Text);
newobject.Expenses_Date = Convert.ToDateTime(TextBoxdate.Text);
newobject.Expenses_PersonInCharge = Convert.ToString(TextBoxfrom.Text);
newobject.Expenses_Quantity = Convert.ToDouble(TextBoxquantity.Text);
newobject.Expenses_Total = Convert.ToDouble(TextBoxunitcost.Text) * Convert.ToDouble(TextBoxquantity.Text);
newobject.Expenses_Type_Id = Convert.ToInt32(DropDownListExpenseType.SelectedValue);
newobject.Rectime = DateTime.Now;
newobject.Expenses_Rectime = DateTime.Now;
newobject.UserId = Convert.ToInt32(Session["userid"]);
newobject.IsDisable = false;
newobject.Expenses_From = DateTime.Now;
newobject.Note = TextBoxNote.Text;
DB.Expenses.InsertOnSubmit(newobject);
DB.SubmitChanges();
if (DropDownListbankcash.SelectedValue == "0")
{
bs.AddBank(newobject.Expenses_Id, false, newobject.Expenses_Total, newobject.Expenses_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), newobject.Expenses_PersonInCharge, "-", "", 0, 0, false);
}
else if (DropDownListbankcash.SelectedValue == "1")
{
bs.Addcash(newobject.Expenses_Id, false, newobject.Expenses_Total, newobject.Expenses_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), newobject.Expenses_PersonInCharge, "-", "", 0, 0, false);
}
}
else
{
Labelstatus.Text = "The Currenct Balance Doesn't allow this transaction Current Balance is :" + balance;
}
}
protected void Successbtnadd_Click(object sender, EventArgs e)
{
Labelstatus.Text = "";
if (DropDownListcontac.SelectedValue != "0")
{
Invoice object1 = new Invoice();
object1.Invoice_AfterDiscountprice = 0;
object1.Invoice_AfterDiscountprice_ATax = 0;
object1.Invoice_Date = Convert.ToDateTime(datepicker.Text);
//object1.Invoice_IsDone = Convert.ToByte(CheckBoxDone.Checked);
object1.Invoice_No = Convert.ToInt32(Convert.ToString(Convert.ToInt32(DB.Invoice_Serial_Collects.Where(a => a.Invoice_Serial_Collect_Collecting.Equals(DropDownListinvoicetype.SelectedValue)).SingleOrDefault().Invoice) + 1));
object1.Invoice_Price = Convert.ToDouble(0);
object1.Invoice_Rectime = DateTime.Now;
object1.Invoice_TotalCost = Convert.ToDouble(0);
object1.Invoice_Type_Id = Convert.ToInt32(DropDownListinvoicetype.SelectedValue);
object1.Contact_Id = Convert.ToInt32(DropDownListcontac.SelectedValue);
object1.IsDisable = false;
DB.Invoices.InsertOnSubmit(object1);
DB.SubmitChanges();
bsclass bs = new bsclass();
//if (object1.Invoice_Type_Id == 1)
// bs.Addtransaction(2, "Invoice+", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
//else if (object1.Invoice_Type_Id == 2)
// bs.Addtransaction(4, "Invoice-", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
bs.invoicetransaction(Convert.ToString(object1.Invoice_Id));
var serical = DB.Invoice_Serial_Collects.Where(a => a.Invoice_Serial_Collect_Collecting.Equals(DropDownListinvoicetype.SelectedValue)).SingleOrDefault();
serical.Invoice++;
DB.Invoice_Serial_Collects.DefaultIfEmpty(serical);
DB.SubmitChanges();
Response.Redirect("AddInvoice.aspx?ID=" + object1.Invoice_Id);
}
else
{
Labelstatus.Text = "Please Choose A Contact ";
}
}
/// <summary>
/// items
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Successbtnitem_Click(object sender, EventArgs e)
{
bsclass cls = new bsclass();
var invoice = DB.Invoices.Where(a => a.Invoice_Id.Equals(Labelid.Text)).SingleOrDefault();
if (invoice.Invoice_Type_Id == 1)
{
var item = DB.Items.Where(a => a.Items_Id.Equals(DropDownListItem.SelectedValue)).SingleOrDefault();
if (item.HasStock == 1)
{
var newstock = DB.Stocks.Where(a => a.Item_Id.Equals(DropDownListItem.SelectedValue)).SingleOrDefault();
if (newstock.Stock_Quantity >= Convert.ToInt32(TextBoxquentity.Text))
{
add();
cls.invoicesale(Convert.ToInt32(DropDownListItem.SelectedValue), Convert.ToInt32(TextBoxquentity.Text), false, Convert.ToDouble(textboxunticost.Text));
}
else
{
Response.Write("<script language=javascript>alert('Over Stock Quanitity');</script>");
}
}
else
{
add();
}
}
else
{
add();
var item = DB.Items.Where(a => a.Items_Id.Equals(DropDownListItem.SelectedValue)).SingleOrDefault();
if (item.HasStock == 1)
{
cls.invoicesale(Convert.ToInt32(DropDownListItem.SelectedValue), Convert.ToInt32(TextBoxquentity.Text), true, Convert.ToDouble(textboxunticost.Text));
}
}
onrefresh();
}
protected void insertdata()
{
BsolutionWebApp.Collecting object1 = new BsolutionWebApp.Collecting();
object1.Collecting_No = Int32.Parse(TextCollectingNo.Text);
object1.Collecting_Name = TextCollectingName.Text;
object1.Collecting_Note = TextBoxNote.Text;
object1.Collecting_Date = Convert.ToDateTime(datepicker.Text);
object1.IsDisable = false;
object1.Cheque_Id = Int32.Parse(ddCheque.SelectedValue);
object1.Invoice_Id = Int32.Parse(ddInvoice.SelectedValue);
object1.Contact_Id = Int32.Parse(ddContact.SelectedValue);
object1.Operation_Type_Id = Int32.Parse(ddOperationType.SelectedValue);
object1.Rectime = DateTime.Now;
object1.User_Id = 0;
DB.Collectings.InsertOnSubmit(object1);
DB.SubmitChanges();
bsclass bs = new bsclass();
if (object1.Invoice_Type_Id == 1)
{
bs.Addtransaction(2, "Invoice+", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
}
else if (object1.Invoice_Type_Id == 2)
{
bs.Addtransaction(4, "Invoice-", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
}
var serical = DB.Invoice_Serial_Collects.Where(a => a.Invoice_Serial_Collect_Collecting.Equals(DropDownListinvoicetype.SelectedValue)).SingleOrDefault();
serical.Invoice++;
DB.Invoice_Serial_Collects.DefaultIfEmpty(serical);
DB.SubmitChanges();
Labelstatus.Text = "Invoice No=" + object1.Invoice_No + " -Date of Invoice" + object1.Invoice_Date;
}
private void editinvoicemoney(string id)
{
decimal amount = 0;
decimal percentage = 0;
decimal taxamount = 0;
decimal taxpercentage = 0;
var invoice = DB.Invoices.Where(a => a.Invoice_Id.Equals(Labelid.Text)).SingleOrDefault();
var discount = DB.DiscountInvoice2s.Where(a => a.Invoice_Id.Equals(invoice.Invoice_Id) && a.IsDisable.Equals(false));
foreach (var item in discount)
{
amount = amount + Convert.ToDecimal(item.DiscountInvoice_Amount);
percentage = percentage + (Convert.ToDecimal(item.DiscountInvoice_Percentage) * Convert.ToDecimal(invoice.Invoice_Price)) / 100;
}
invoice.Invoice_AfterDiscountprice = Convert.ToDouble(Convert.ToDecimal(invoice.Invoice_Price) - Convert.ToDecimal(amount + percentage));
var taxvalue = DB.InvoiceTaxes.Where(a => a.Invoice_ID.Equals(invoice.Invoice_Id) && a.IsDisable.Equals(false));
foreach (var item in taxvalue)
{
taxamount = taxamount + Convert.ToDecimal(item.InvoiceTax_Amount);
taxpercentage = taxpercentage + (Convert.ToDecimal(item.InvoiceTax_Percentage) * Convert.ToDecimal(invoice.Invoice_AfterDiscountprice)) / 100;
}
invoice.Invoice_AfterDiscountprice_ATax = Convert.ToDouble(Convert.ToDecimal(invoice.Invoice_AfterDiscountprice) + Convert.ToDecimal(taxamount + taxpercentage));
DB.Invoices.DefaultIfEmpty(invoice);
DB.SubmitChanges();
bsclass bs = new bsclass();
bs.invoicetransaction(Labelid.Text);
}
protected void insertdata()
{
if (Labelid.Text == "0")
{
Invoice object1 = new Invoice();
object1.Invoice_AfterDiscountprice = 0;
object1.Invoice_AfterDiscountprice_ATax = 0;
object1.Invoice_Date = Convert.ToDateTime(datepicker.Text);
//object1.Invoice_IsDone = Convert.ToByte(CheckBoxDone.Checked);
object1.Invoice_No = Convert.ToInt32(TextBoxInvoiceno.Text);
object1.Invoice_Note = TextBoxNote.Text;
object1.Invoice_Price = Convert.ToDouble(0);
object1.Invoice_Rectime = DateTime.Now;
object1.Invoice_TotalCost = Convert.ToDouble(0);
object1.Invoice_Type_Id = Convert.ToInt32(DropDownListinvoicetype.SelectedValue);
object1.Contact_Id = Convert.ToInt32(DropDownListcontac.SelectedValue);
object1.IsDisable = false;
DB.Invoices.InsertOnSubmit(object1);
DB.SubmitChanges();
Labelid.Text = Convert.ToString(object1.Invoice_Id);
bsclass bs = new bsclass();
if (object1.Invoice_Type_Id == 1)
{
bs.Addtransaction(2, "Invoice+", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
}
else if (object1.Invoice_Type_Id == 2)
{
bs.Addtransaction(4, "Invoice-", object1.Invoice_Id, object1.Invoice_Date, object1.Invoice_TotalCost, object1.Invoice_Price, object1.Invoice_Price - object1.Invoice_TotalCost, "");
}
var serical = DB.Invoice_Serial_Collects.Where(a => a.Invoice_Serial_Collect_Collecting.Equals(DropDownListinvoicetype.SelectedValue)).SingleOrDefault();
serical.Invoice++;
DB.Invoice_Serial_Collects.DefaultIfEmpty(serical);
DB.SubmitChanges();
Labelstatus.Text = "Invoice No=" + object1.Invoice_No + " -Date of Invoice" + object1.Invoice_Date;
// Response.Write("<script language=javascript>alert('Done');</script>");
}
else
{
Invoice object1 = DB.Invoices.Where(a => a.Invoice_Id.Equals(Labelid.Text)).SingleOrDefault();
//object1.Invoice_AfterDiscountprice = Convert.ToDouble(TextBoxAfterDiscount.Text);
//object1.Invoice_AfterDiscountprice_ATax = Convert.ToDouble(TextBoxTax.Text);
object1.Invoice_Date = Convert.ToDateTime(datepicker.Text);
// object1.Invoice_IsDone = Convert.ToByte(CheckBoxDone.Checked);
//object1.Invoice_No = Convert.ToInt32(TextBoxInvoiceno.Text);
object1.Invoice_Note = TextBoxNote.Text;
//object1.Invoice_Price = Convert.ToDouble(TextBoxtotalprice.Text);
object1.Invoice_Rectime = DateTime.Now;
//object1.Invoice_TotalCost = Convert.ToDouble(TextBoxcost.Text);
object1.Invoice_Type_Id = Convert.ToInt32(DropDownListinvoicetype.SelectedValue);
object1.Contact_Id = Convert.ToInt32(DropDownListcontac.SelectedValue);
DB.Invoices.DefaultIfEmpty(object1);
DB.SubmitChanges();
Labelid.Text = "0";
//bsclass bs = new bsclass();
//bs.invoicetransaction(Labelid.Text);
//Response.Redirect("AddInvoice.aspx");
}
}
protected void inser()
{
BsolutionWebApp.Collecting object1 = null;
if (Labelcollectingid.Text == "0")
{
Labelstatus.Text = "";
if (DropDownListInvoicetype.SelectedValue == "2")
{
bsclass bs = new bsclass();
decimal balance = 0;
if (DropDownList1.SelectedValue == "0")
{
balance = bs.checkblance(true, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
}
else if (DropDownList1.SelectedValue == "1")
{
balance = bs.checkblance(false, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
}
if (balance < Convert.ToDecimal((TextBoxamount.Text)))
{
Labelstatus.Text = "The Currenct Balance Doesn't allow this transaction Current Balance is :" + balance;
return;
}
}
object1 = new BsolutionWebApp.Collecting();
object1.Collecting_No = Int32.Parse(TextBoxCollectingNo.Text);
object1.Collecting_Name = TextBoxcollectingname.Text;
object1.Collecting_Note = TextBoxNote.Text;
object1.Collecting_Date = Convert.ToDateTime(TextBoxdate.Text);
object1.IsDisable = false;
object1.Collecting_Note = Convert.ToString(DropDownListbankcashtype.SelectedValue);
if (RadioButtonBankOrCash.Checked == true)
{
object1.BankorCash = int.Parse(DropDownList1.SelectedValue);
}
object1.Invoice_Id = Int32.Parse(DropDownListInvoice.SelectedValue);
object1.Collecting_Amount = Convert.ToDouble(TextBoxamount.Text);
object1.Collecting_WhatsLeft = Convert.ToDouble(TextBoxleft.Text) - Convert.ToDouble(TextBoxamount.Text);
object1.Operation_Type_Id = Int32.Parse(DropDownListInvoicetype.SelectedValue);
object1.Rectime = DateTime.Now;
object1.User_Id = 0;
object1.Collecting_Rectime = DateTime.Now;
object1.Log_Date = DateTime.Now;
DB.Collectings.InsertOnSubmit(object1);
DB.SubmitChanges();
var serial = DB.Invoice_Serial_Collects.Where(a => a.Invoice_Serial_Collect_Collecting.Equals(DropDownListInvoicetype.SelectedValue)).SingleOrDefault();
serial.Collecting = object1.Collecting_No;
DB.Invoice_Serial_Collects.DefaultIfEmpty(serial);
DB.SubmitChanges();
}
else
{
object1 = DB.Collectings.Where(a => a.Collecting_Id.Equals(Labelcollectingid.Text)).SingleOrDefault();
Labelstatus.Text = "";
if (DropDownListInvoicetype.SelectedValue == "2")
{
bsclass bs = new bsclass();
decimal balance = 0;
if (DropDownList1.SelectedValue == "0")
{
balance = bs.checkblance(true, Convert.ToInt32(DropDownListbankcashtype));
}
else if (DropDownList1.SelectedValue == "1")
{
balance = bs.checkblance(false, Convert.ToInt32(DropDownListbankcashtype));
}
if ((balance + Convert.ToDecimal(object1.Collecting_Amount)) < Convert.ToDecimal((TextBoxamount.Text)))
{
Labelstatus.Text = "The Currenct Balance Doesn't allow this transaction Current Balance is :" + balance;
return;
}
}
object1.Collecting_Name = TextBoxcollectingname.Text;
object1.Collecting_Note = TextBoxNote.Text;
object1.Collecting_Date = Convert.ToDateTime(TextBoxdate.Text);
object1.IsDisable = false;
object1.Collecting_Note = Convert.ToString(DropDownListbankcashtype.SelectedValue);
if (RadioButtonBankOrCash.Checked == true)
{
object1.BankorCash = int.Parse(DropDownList1.SelectedValue);
}
object1.Collecting_Amount = Convert.ToDouble(TextBoxamount.Text);
object1.Collecting_WhatsLeft = Convert.ToDouble(TextBoxleft.Text) - Convert.ToDouble(TextBoxamount.Text);
object1.Operation_Type_Id = Int32.Parse(DropDownListInvoicetype.SelectedValue);
object1.User_Id = 0;
object1.Collecting_Rectime = DateTime.Now;
object1.Log_Date = DateTime.Now;
DB.Collectings.DefaultIfEmpty(object1);
DB.SubmitChanges();
}
if (RadioButtonBankOrCash.Checked == true)
{
bsclass bs = new bsclass();
if (DropDownList1.SelectedValue == "0")
{
if (DB.Banks.Where(a => a.Collecting_Id.Equals(object1.Collecting_Id)).Count() == 0)
{
if (DropDownListInvoicetype.SelectedValue == "1")
{
bs.AddBank(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "+", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
else if (DropDownListInvoicetype.SelectedValue == "2")
{
bs.AddBank(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "-", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
}
else
{
if (DropDownListInvoicetype.SelectedValue == "1")
{
bs.editBank(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "+", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
else if (DropDownListInvoicetype.SelectedValue == "2")
{
bs.editBank(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "-", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
}
}
else if (DropDownList1.SelectedValue == "1")
{
if (DB.Cashes.Where(a => a.Collecting_Id.Equals(object1.Collecting_Id)).Count() == 0)
{
if (DropDownListInvoicetype.SelectedValue == "1")
{
bs.Addcash(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "+", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
else if (DropDownListInvoicetype.SelectedValue == "2")
{
bs.Addcash(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "-", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
}
else
{
if (DropDownListInvoicetype.SelectedValue == "1")
{
bs.editcash(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "+", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
else if (DropDownListInvoicetype.SelectedValue == "2")
{
bs.editcash(object1.Collecting_Id, true, object1.Collecting_Amount, object1.Collecting_Date, Convert.ToInt32(DropDownListbankcashtype.SelectedValue), "", "-", TextBoxNote.Text, object1.Collecting_Amount, 0, false);
}
}
}
}
else if (RadioButtonCheque.Checked == true)
{
var cheque = DB.Cheques.Where(a => a.Collecting_Id.Equals(object1.Collecting_Id));
if (cheque.Count() == 0)
{
BsolutionWebApp.Cheque object2 = new BsolutionWebApp.Cheque();
object2.Cheque_No = Convert.ToString(TextBoxchequeno.Text);
object2.Cheque_Bank_Name = TextBoxchequebankname.Text;
object2.Cheque_Date = Convert.ToDateTime(TextBoxdate.Text);
object2.IsDisable = false;
object2.Cheque_Notes = TextBoxNote.Text;
object2.Collecting_Id = object1.Collecting_Id;
object2.RecTime = DateTime.Now;
object2.PersonInCharge = "";
object2.Cheque_Notes = "";
DB.Cheques.InsertOnSubmit(object2);
DB.SubmitChanges();
}
else
{
var cheque2 = DB.Cheques.Where(a => a.Collecting_Id.Equals(object1.Collecting_Id)).SingleOrDefault();
cheque2.Cheque_No = Convert.ToString(TextBoxchequeno.Text);
cheque2.Cheque_Bank_Name = TextBoxchequebankname.Text;
cheque2.Cheque_Date = Convert.ToDateTime(TextBoxdate.Text);
DB.Cheques.DefaultIfEmpty(cheque2);
DB.SubmitChanges();
}
}
Labelcollectingid.Text = "0";
Response.Redirect("CollectingPageAdd?ID=" + Labelinvoiceid.Text);
}
public void gridbind()
{
if (DropDownListbankcash.SelectedValue == "0")
{
bsclass bs = new bsclass();
Labelstatus.Text = "Current Balance =" + bs.checkblance(true, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
var banks = DB.Banks.Where(a => a.BankName_ID.Equals(DropDownListbankcashtype.SelectedValue));
DataTable dt = new DataTable();
dt.Columns.Add("Type");
dt.Columns.Add("No.");
dt.Columns.Add("+/-");
dt.Columns.Add("DateTime");
dt.Columns.Add("InvoiceNo.");
dt.Columns.Add("DateInvoice");
dt.Columns.Add("Amount");
dt.Columns.Add("Contact");
foreach (var bank in banks)
{
if (bank.Collecting_Id != 0)
{
var collect = DB.Collectings.Where(a => a.Collecting_Id.Equals(bank.Collecting_Id)).SingleOrDefault();
if (collect.Invoice_Id != 0)
{
var invoice = DB.Invoices.Where(a => a.Invoice_Id.Equals(collect.Invoice_Id)).SingleOrDefault();
if (invoice.Invoice_Type_Id == 1)
{
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "تحصيل فاتورة بيع";
_ravi["No."] = collect.Collecting_No;
_ravi["+/-"] = "+";
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = invoice.Invoice_No;
_ravi["DateInvoice"] = invoice.Invoice_Date;
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = DB.Contact2s.Where(a => a.Contact_Id.Equals(invoice.Contact_Id)).SingleOrDefault().Contact_Name;
dt.Rows.Add(_ravi);
}
else if (invoice.Invoice_Type_Id == 2)
{
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "دفع فاتورة شراء";
_ravi["No."] = collect.Collecting_No;
_ravi["+/-"] = "-";
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = invoice.Invoice_No;
_ravi["DateInvoice"] = invoice.Invoice_Date;
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = DB.Contact2s.Where(a => a.Contact_Id.Equals(invoice.Contact_Id)).SingleOrDefault().Contact_Name;
dt.Rows.Add(_ravi);
}
}
else if (collect.Contact_Id != 0)
{
var contact = DB.Contact2s.Where(a => a.Contact_Id.Equals(collect.Contact_Id)).SingleOrDefault();
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "حساب الشركاء";
_ravi["No."] = collect.Collecting_No;
if (collect.Operation_Type_Id == 1)
{
_ravi["+/-"] = "+";
}
else if (collect.Operation_Type_Id == 2)
{
_ravi["+/-"] = "-";
}
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = "";
_ravi["DateInvoice"] = "";
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = contact.Contact_Name;
dt.Rows.Add(_ravi);
}
}
else if (bank.Expenses_Id != 0)
{
var expense = DB.Expenses.Where(a => a.Expenses_Id.Equals(bank.Expenses_Id)).SingleOrDefault();
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "مصروف";
_ravi["No."] = expense.Expenses_No;
_ravi["+/-"] = "-";
_ravi["DateTime"] = expense.Expenses_Date;
_ravi["InvoiceNo."] = "";
_ravi["DateInvoice"] = "";
_ravi["Amount"] = expense.Expenses_Total;
_ravi["Contact"] = expense.Expenses_From;
dt.Rows.Add(_ravi);
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
bsclass bs = new bsclass();
Labelstatus.Text = "Current Balance =" + bs.checkblance(false, Convert.ToInt32(DropDownListbankcashtype.SelectedValue));
var banks = DB.Cashes.Where(a => a.CashID.Equals(DropDownListbankcashtype.SelectedValue));
DataTable dt = new DataTable();
dt.Columns.Add("Type");
dt.Columns.Add("No.");
dt.Columns.Add("+/-");
dt.Columns.Add("DateTime");
dt.Columns.Add("InvoiceNo.");
dt.Columns.Add("DateInvoice");
dt.Columns.Add("Amount");
dt.Columns.Add("Contact");
foreach (var bank in banks)
{
if (bank.Collecting_Id != 0)
{
var collect = DB.Collectings.Where(a => a.Collecting_Id.Equals(bank.Collecting_Id)).SingleOrDefault();
if (collect.Invoice_Id != 0)
{
var invoice = DB.Invoices.Where(a => a.Invoice_Id.Equals(collect.Invoice_Id)).SingleOrDefault();
if (invoice.Invoice_Type_Id == 1)
{
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "تحصيل فاتورة بيع";
_ravi["No."] = collect.Collecting_No;
_ravi["+/-"] = "+";
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = invoice.Invoice_No;
_ravi["DateInvoice"] = invoice.Invoice_Date;
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = DB.Contact2s.Where(a => a.Contact_Id.Equals(invoice.Contact_Id)).SingleOrDefault().Contact_Name;
dt.Rows.Add(_ravi);
}
else if (invoice.Invoice_Type_Id == 2)
{
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "دفع فاتورة شراء";
_ravi["No."] = collect.Collecting_No;
_ravi["+/-"] = "-";
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = invoice.Invoice_No;
_ravi["DateInvoice"] = invoice.Invoice_Date;
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = DB.Contact2s.Where(a => a.Contact_Id.Equals(invoice.Contact_Id)).SingleOrDefault().Contact_Name;
dt.Rows.Add(_ravi);
}
}
else if (collect.Contact_Id != 0)
{
var contact = DB.Contact2s.Where(a => a.Contact_Id.Equals(collect.Contact_Id)).SingleOrDefault();
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "حساب الشركاء";
_ravi["No."] = collect.Collecting_No;
if (collect.Operation_Type_Id == 1)
{
_ravi["+/-"] = "+";
}
else if (collect.Operation_Type_Id == 2)
{
_ravi["+/-"] = "-";
}
_ravi["DateTime"] = collect.Collecting_Date;
_ravi["InvoiceNo."] = "";
_ravi["DateInvoice"] = "";
_ravi["Amount"] = collect.Collecting_Amount;
_ravi["Contact"] = contact.Contact_Name;
dt.Rows.Add(_ravi);
}
}
else if (bank.Expenses_Id != 0)
{
var expense = DB.Expenses.Where(a => a.Expenses_Id.Equals(bank.Expenses_Id)).SingleOrDefault();
DataRow _ravi = dt.NewRow();
_ravi["Type"] = "مصروف";
_ravi["No."] = expense.Expenses_No;
_ravi["+/-"] = "-";
_ravi["DateTime"] = expense.Expenses_Date;
_ravi["InvoiceNo."] = "";
_ravi["DateInvoice"] = "";
_ravi["Amount"] = expense.Expenses_Total;
_ravi["Contact"] = expense.Expenses_From;
dt.Rows.Add(_ravi);
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
