protected void insertdata(int Collecting_Id)
{
BsolutionWebApp.Cheque object_Cheque = new BsolutionWebApp.Cheque();
object_Cheque.Collecting_Id = Collecting_Id;
object_Cheque.Cheque_No = (TextChequeNo.Text);
object_Cheque.Cheque_Bank_Name = ddBankName.SelectedItem.ToString();
object_Cheque.Cheque_Notes = TextBoxNote.Text;
object_Cheque.Cheque_Date = Convert.ToDateTime(datepicker.Text);
object_Cheque.IsDisable = false;
object_Cheque.PersonInCharge = TextPersonInCharge.Text;
object_Cheque.RecTime = DateTime.Now;
object_Cheque.UserId = Convert.ToInt32(Session["userid"]);
DB.Cheques.InsertOnSubmit(object_Cheque);
DB.SubmitChanges();
}
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);
}
