private void materialButton_add_Click(object sender, EventArgs e)
{
using (var db = Model.DatabaseConfigure.getConfigure())
{
party_ledgers ledger = new party_ledgers()
{
date = INFO.currentdate,
amount = betterTextBox_amount.decVal,
type = "DR",
party_id = id,
created_at = DateTime.Now,
updated_at = DateTime.Now,
};
db.party_ledgers.Add(ledger);
db.SaveChanges();
this.Close();
}
}
private void materialButton_save_Click(object sender, EventArgs e)
{
if (betterListView1.Items == null)
{
CustomControls.Alert.show("Empty Items", "Please selcet item and enter price and quantity", 3000);
return;
}
if (comboBox_party.SelectedIndex == -1)
{
CustomControls.Alert.show("Empty Items", "Please selcet Party in parties list", 3000);
return;
}
Model.purchaseinvoice addnew = new Model.purchaseinvoice()
{
grosstotal = betterTextBox_grosstotal.decVal,
discount = betterTextBox_discount.decVal,
tax = betterTextBox_Tax.decVal,
nettotal = betterTextBox_nettotal.decVal,
due = betterTextBox_Due.decVal,
paid = betterTextBox_paid.decVal,
fiscalyear_id = INFO.currentFiscalYear.id,
admin_id = INFO.admin_id,
created_at = DateTime.Now,
updated_at = DateTime.Now,
date = INFO.currentdate,
parties_id = (comboBox_party.SelectedItem as Model.party).id
};
Model.party_ledgers party_Ledger = new party_ledgers()
{
date = INFO.currentdate,
amount = betterTextBox_Due.decVal,
due = 0,
returnamount = 0,
type = "CR",
party_id = (comboBox_party.SelectedItem as Model.party).id,
created_at = DateTime.Now,
updated_at = DateTime.Now,
};
db.party_ledgers.Add(party_Ledger);
//if (checkBox_party.Checked)
//{
// if (comboBox_party.SelectedIndex< 0)
// {
// CustomControls.Alert.show("", "select party", 2000);
// return;
// }
//var venderdata = (party)comboBox_party.SelectedItem;
//addnew.parties_id = venderdata.id;
//var vender = db.parties.Where(o => o.id == venderdata.id).First();
//if (checkBox_advance.Checked)
//{
// if (betterTextBox_advance.decVal > vender.advance)
// {
// vender.advance = 0;
// }
// else
// {
// vender.advance -= betterTextBox_advance.decVal;
// }
//}
//if (betterTextBox_Due.decVal > 0)
//{
// if (checkBox_advance.Checked)
// {
// if (betterTextBox_advance.decVal >= betterTextBox_Due.decVal)
// {
// betterTextBox_Due.decVal = 0;
// }
// else
// {
// betterTextBox_Due.decVal -= betterTextBox_advance.decVal;
// }
// }
// vender.due += betterTextBox_Due.decVal;
// db.Entry(vender).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
db.purchaseinvoices.Add(addnew);
db.SaveChanges();
purchase_id = addnew.id;
foreach (ListViewItem item in betterListView1.Items)
{
var quantity = Convert.ToDecimal(item.SubItems[3].Text);
var unit = item.SubItems[4].Text;
var rate = Convert.ToDecimal(item.SubItems[5].Text);
var total = Convert.ToInt32(item.SubItems[6].Text);
var item_id = Convert.ToInt32(item.SubItems[7].Text);
var purchase_item = db.purchaseitems.Find(item_id);
purchase_item.qty += quantity;
db.Entry(purchase_item).State = System.Data.Entity.EntityState.Modified;
purchaseinvoiceitem newstock = new purchaseinvoiceitem()
{
purchaseitems_id = item_id,
price = rate,
qty = quantity,
unit = unit,
purchaseinvoice_id = purchase_id,
admin_id = INFO.admin_id,
updated_at = DateTime.Now,
created_at = DateTime.Now,
};
db.purchaseinvoiceitems.Add(newstock);
db.SaveChanges();
}
foreach (ListViewItem item in betterListView_Exp.Items)
{
var item_name = item.SubItems[0].Text;
var amount = Convert.ToDecimal(item.SubItems[1].Text);
purchseexpens exp = new Model.purchseexpens()
{
purchaseinvoice_id = purchase_id,
name = item_name,
amount = amount,
date = INFO.currentdate,
admin_id = INFO.admin_id,
updated_at = DateTime.Now,
created_at = DateTime.Now,
fiscalyear_id = INFO.currentFiscalYear.id
};
db.purchseexpenses.Add(exp);
db.SaveChanges();
}
betterListView1.Items.Clear();
betterListView_Exp.Items.Clear();
//if (checkBox_party.Checked)
//{
// comboBox_party.SelectedIndex = -1;
//}
betterTextBox_rate.Clear();
betterTextBox_quantity.Clear();
betterTextBox_grosstotal.Clear();
betterTextBox_discount.Clear();
betterTextBox_Tax.Clear();
betterTextBox_Due.Clear();
betterTextBox_paid.Clear();
betterTextBox_Return.Clear();
}
private void materialButton1_save_Click(object sender, EventArgs e)
{
if (betterTextBox1_name.Text.Trim() == "")
{
CustomControls.Alert.show(" Name", "Enter Party Name ", 1500);
return;
}
if (betterTextBox1_address.Text.Trim() == "")
{
CustomControls.Alert.show("Address", "Enter Party Address", 1500);
return;
}
if (betterTextBox2_phone.Text.Trim() == "")
{
CustomControls.Alert.show("Phone", "Enter Party Phone", 1500);
return;
}
if (betterTextBox11_panNumber.Text.Trim() == "")
{
CustomControls.Alert.show("Pan Number", "Enter Pan Number", 1500);
return;
}
try
{
party i = new party()
{
name = betterTextBox1_name.Text,
address = betterTextBox1_address.Text,
phone = betterTextBox2_phone.Text,
email = betterTextBox3_email.Text,
postalcode = betterTextBox10_postalcode.Text,
pannumber = betterTextBox11_panNumber.Text,
//advance = betterTextBox13_advance.decVal,
//due = betterTextBox12_deu.decVal,
created_at = DateTime.Now,
updated_at = DateTime.Now
};
db.parties.Add(i);
db.SaveChanges();
adddata?.Invoke(i);
if (betterTextBox12_deu.decVal > 0)
{
var party_payment = new party_ledgers()
{
party_id = i.id,
date = INFO.currentdate,
amount = betterTextBox12_deu.decVal,
billnumber = "unknown",
returnamount = 0,
updated_at = DateTime.Now,
created_at = DateTime.Now,
type = "CR",
};
db.party_ledgers.Add(party_payment);
db.SaveChanges();
}
else if (betterTextBox13_advance.decVal > 0)
{
var P_payment = new party_ledgers()
{
party_id = i.id,
date = INFO.currentdate,
amount = betterTextBox13_advance.decVal,
billnumber = "unknown",
returnamount = 0,
updated_at = DateTime.Now,
created_at = DateTime.Now,
type = "DR",
};
db.party_ledgers.Add(P_payment);
db.SaveChanges();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("error");
};
}
