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;
}
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");
}
}