private void materialButton_save_Click(object sender, EventArgs e)
{
if (loaded)
{
this.Fiscalyear.name = betterTextBox_name.Text;
this.Fiscalyear.startdate = nepaliCalender_startdate.Datestamp;
this.Fiscalyear.enddate = nepaliCalender_endate.Datestamp;
this.Fiscalyear.updated_at = DateTime.Now;
db.Entry(this.Fiscalyear).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
this.Fiscalyear = new Model.fiscalyear()
{
name = betterTextBox_name.Text,
startdate = nepaliCalender_startdate.Datestamp,
enddate = nepaliCalender_endate.Datestamp,
created_at = DateTime.Now,
updated_at = DateTime.Now,
admin_id = INFO.admin_id
};
db.fiscalyears.Add(this.Fiscalyear);
db.SaveChanges();
loaded = true;
}
}
private void materialButton1_update_Click(object sender, EventArgs e)
{
try
{
var editdata = db.menuitems.Find(id);
editdata.name = betterTextBox1_name.Text;
editdata.price = (betterTextBox1_price.decVal);
editdata.unit = betterTextBox_units.Text;
editdata.category_id = ((comboBox1_category.SelectedItem as Model.category).id);
editdata.admin_id = INFO.admin_id;
editdata.qty = betterTextBox1_qty.decVal;
editdata.estimated_by = betterTextBox_Estimateby.Text;
editdata.updated_at = DateTime.Now;
db.Entry(editdata).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
edit?.Invoke(editdata);
this.Close();
}
catch (Exception ex)
{
CustomControls.Alert.show("delete your estimated items", "please delete first your all estimate items and and add your new estimated items", 5000);
return;
}
}
private void materialButton_addnew_Click(object sender, EventArgs e)
{
if (betterTextBox_counterno.Text.Trim() == "")
{
INFO.ShowAlert(Text, "Please Enter Counter Name", 3000);
betterTextBox_counterno.Focus();
return;
}
//try
//{
this.Counter.name = betterTextBox_counterno.Text;
this.Counter.updated_at = DateTime.Now;
this.Counter.created_at = DateTime.Now;
db.Entry(this.Counter).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
edit?.Invoke(Counter);
this.Close();
//}
////catch (Exception)
//{
// CustomControls.Alert.show("Error", "data is not edited", 1500);
//}
}
private void materialButton1_Click(object sender, EventArgs e)
{
try
{
if (saveondatabase)
{
db.Entry(Category).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
this.Parent.Controls.Remove(this);
}
catch (Exception ex)
{
MessageBox.Show("not deleted");
}
}
private void materialButton_save_Click(object sender, EventArgs e)
{
var edit = db.purchaseitems.Find(id);
edit.name = betterTextBox_name.Text;
edit.qty = betterTextBox_currentstock.decVal;
edit.unit = betterTextBox_unit.Text;
edit.purchasecategory = ((comboBox_cate.SelectedItem as Model.purchasecategory));
db.Entry(edit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
editdata?.Invoke(edit);
this.Close();
}
private void checkBox_enabled_CheckedChanged(object sender, EventArgs e)
{
if (init)
{
if (this.user.name == "Admin")
{
CustomControls.Alert.show("Manage Users", "This is primary Account You Cannot Edit This Account", 4000);
return;
}
this.user.enabled = checkBox_enabled.Checked;
db.Entry(this.user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
checkColor();
}
}
private void materialButton_changeStatus_Click_1(object sender, EventArgs e)
{
int opencountercount = db.counters.Count(o => o.counterstatus == 2);
if (opencountercount > 0)
{
CustomControls.Comformation.show("Day Management", "Please Ensure That all Counter Have been Closed");
return;
}
if (this.Systemsetting == null)
{
this.Systemsetting = new Model.systemsetting();
this.Systemsetting.currentdate = nepaliCalender.Datestamp;
this.Systemsetting.dateopened = true;
db.systemsettings.Add(this.Systemsetting);
}
else
{
if (this.Systemsetting.dateopened)
{
if (CustomControls.Comformation.show("Day Management", "Are You Sure, you want To Close Day") == DialogResult.Yes)
{
this.Systemsetting.dateopened = false;
}
else
{
return;
}
}
else
{
if (CustomControls.Comformation.show("Day Management", "Check Following things-\n1.Date is Correct\nPress yes to Open Day ") == DialogResult.Yes)
{
this.Systemsetting.currentdate = nepaliCalender.Datestamp;
this.Systemsetting.dateopened = true;
}
else
{
return;
}
}
db.Entry(this.Systemsetting).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
refreshUI();
}
private void materialButton_delete_Click(object sender, EventArgs e)
{
try
{
using (var db = new Model.ResturantManagementEntities())
{
var i = db.menuitems.Where(o => o.id == this.id).Single();
db.Entry(i).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
this.Parent.Controls.Remove(this);
}
catch (Exception ex)
{
MessageBox.Show("not deleted");
}
}
private void materialButton_addnew_Click(object sender, EventArgs e)
{
if (betterTextBox_username.Text.Trim() == "")
{
CustomControls.Alert.show("Add User", "Please Enter Username", 3000);
return;
}
if (betterTextBox_password.Text.Trim() == "" || betterTextBox_retypepassword.Text.Trim() == "")
{
CustomControls.Alert.show("Add User", "Password Cannot be blank", 3000);
return;
}
if (betterTextBox_password.Text.Trim() != betterTextBox_retypepassword.Text.Trim())
{
CustomControls.Alert.show("Add User", "Please Rematch the password", 3000);
return;
}
if (comboBox_roles.SelectedIndex < 0)
{
CustomControls.Alert.show("Add User", "Please Select The Role", 3000);
return;
}
var password = CustomControls.Encrypt.EncryptString(betterTextBox_password.Text.Trim(), "need12345");
var user = new Model.admin()
{
name = betterTextBox_username.Text.Trim(),
password = password,
role = comboBox_roles.SelectedIndex,
updated_at = DateTime.Now,
created_at = DateTime.Now,
enabled = true
};
db.admins.Add(user);
db.SaveChanges();
add?.Invoke(user.id);
betterTextBox_username.Clear();
betterTextBox_password.Clear();
betterTextBox_retypepassword.Clear();
comboBox_roles.SelectedIndex = -1;
flowLayoutPanel.Controls.Add(new Viwer(user.id));
}
public void save()
{
var billitem = new Model.wastagefood()
{
menuitem_id = id,
qty = qty,
date = date,
unit = unit,
created_at = DateTime.Now,
upadated_at = DateTime.Now,
admins_id = INFO.admin_id,
fiscalyear_id = INFO.currentFiscalYear.id
};
db.wastagefoods.Add(billitem);
db.SaveChanges();
}
private void materialButton1_Click(object sender, EventArgs e)
{
var editcustomer = db.customers.Find(id);
editcustomer.name = betterTextBox_name.Text;
editcustomer.address = betterTextBox_address.Text;
// editcustomer.panno=betterTextBox_panno.Text;
editcustomer.phone = betterTextBox_phone.Text;
editcustomer.email = betterTextBox_email.Text;
// editcustomer.currentdue=betterTextBox_currentDue.decVal;
//editcustomer.currentadvance=betterTextBox_currentAdvance.decVal;
editcustomer.nationality = betterTextBox_nationality.Text;
editcustomer.creadted_at = DateTime.Now;
editcustomer.updated_at = DateTime.Now;
editcustomer.admin_id = INFO.admin_id;
db.Entry(editcustomer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
edit?.Invoke(editcustomer);
this.Close();
}
public void save()
{
var load = db.purchaseitems.Find(id);
load.qty -= qty;
db.Entry(load).State = System.Data.Entity.EntityState.Modified;
var billitem = new Model.wastagepurchaseitem()
{
purchaseitem_id = id,
qty = qty,
date = date,
unit = unit,
created_at = DateTime.Now,
upadated_at = DateTime.Now,
admins_id = INFO.admin_id,
fiscalyear_id = INFO.currentFiscalYear.id
};
db.wastagepurchaseitems.Add(billitem);
db.SaveChanges();
}
private void materialButton_save_Click(object sender, EventArgs e)
{
if (betterTextBox_password.Text.Trim() == "" || betterTextBox_retypepassword.Text.Trim() == "")
{
CustomControls.Alert.show("Password Change", "Password Cannot be blank", 3000);
return;
}
if (betterTextBox_password.Text.Trim() != betterTextBox_retypepassword.Text.Trim())
{
CustomControls.Alert.show("Password Change", "Please Rematch the password", 3000);
return;
}
var user = db.admins.Find(this.admin_id);
user.password = CustomControls.Encrypt.EncryptString(betterTextBox_password.Text.Trim(), "need12345");
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
this.Close();
}
private void materialButton_save_Click(object sender, EventArgs e)
{
if (savedatabase)
{
purchasecategory.name = betterTextBox_name.Text;
purchasecategory.updated_at = DateTime.Now;
purchasecategory.created_at = DateTime.Now;
purchasecategory.admin_id = INFO.admin_id;
db.SaveChanges();
}
else
{
var db = Model.DatabaseConfigure.getConfigure();
var newpcate = new Model.purchasecategory()
{
name = betterTextBox_name.Text,
updated_at = DateTime.Now,
created_at = DateTime.Now,
admin_id = INFO.admin_id
};
db.purchasecategories.Add(newpcate);
db.SaveChanges();
}
}
private void materialButton1_Click(object sender, EventArgs e)
{
if (betterTextBox_name.Text.Trim() == "")
{
CustomControls.Alert.show("name", "enter item name", 1500);
return;
}
if (betterTextBox_address.Text.Trim() == "")
{
CustomControls.Alert.show("address", "enter address", 1200);
return;
}
if (betterTextBox_phone.Text.Trim() == "")
{
CustomControls.Alert.show("phone", "enter phone", 1500);
return;
}
if (betterTextBox_email.Text.Trim() == "")
{
CustomControls.Alert.show("email", "enter email", 1500);
return;
}
if (betterTextBox_nationality.Text.Trim() == "")
{
CustomControls.Alert.show("nationality", "enter nationality", 1500);
return;
}
var customer = new customer();
customer.name = betterTextBox_name.Text;
customer.address = betterTextBox_address.Text;
customer.email = betterTextBox_email.Text;
customer.phone = betterTextBox_phone.Text;
//customer.currentadvance = (betterTextBox_currentAdvance.decVal);
//customer.currentdue = (betterTextBox_currentdue.decVal);
customer.nationality = betterTextBox_nationality.Text;
customer.admin_id = INFO.admin_id;
customer.creadted_at = DateTime.Now;
customer.updated_at = DateTime.Now;
db.customers.Add(customer);
db.SaveChanges();
add?.Invoke(customer);
if (betterTextBox_currentdue.decVal > 0)
{
var cuspayment = new customer_ledgers()
{
customer_id = customer.id,
date = INFO.currentdate,
amount = betterTextBox_currentdue.decVal,
billnumber = "unknown",
returnamount = 0,
updated_at = DateTime.Now,
created_at = DateTime.Now,
type = "DR",
};
db.customer_ledgers.Add(cuspayment);
db.SaveChanges();
}
else if (betterTextBox_currentAdvance.decVal > 0)
{
var cuspayment = new customer_ledgers()
{
customer_id = customer.id,
date = INFO.currentdate,
amount = betterTextBox_currentAdvance.decVal,
billnumber = "unknown",
returnamount = 0,
updated_at = DateTime.Now,
created_at = DateTime.Now,
type = "CR",
};
db.customer_ledgers.Add(cuspayment);
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");
};
}
private void materialButton_accecptAmount_Click(object sender, EventArgs e)
{
if (betterTextBox_accecpted.decVal == 0)
{
CustomControls.Alert.show("Counter Management", "Accecpted Value Cannot Be Zero", 5000);
return;
}
if (CustomControls.Comformation.show("Counter Management", "Please Check Following Detail are Correct:\n" +
"1. Counter Number is " + label_counterno.Text + "\n" +
"2. Requested Amount is " + label_amount.Text + "\n" +
"3. Accecpted Amount is " + betterTextBox_accecpted.Text) == DialogResult.Yes)
{
this.Counterstatus.approved = true;
this.Counterstatus.status = 1;
this.Counterstatus.approvedamount = betterTextBox_accecpted.decVal;
this.Counterstatus.currentstock = betterTextBox_accecpted.decVal;
this.Counterstatus.updated_at = DateTime.Now;
db.Entry(this.Counterstatus).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
this.Parent.Controls.Remove(this);
}
//if (betterTextBox_accecpted.decVal == 0)
//{
// CustomControls.Alert.show("Counter Management", "Accecpted Value Cannot Be Zero", 5000);
// return;
//}
//if(CustomControls.Comformation.show("Counter Management", "Please Check Following Detail are Correct:\n" +
// "1. Counter Number is " + label_counterno.Text + "\n" +
// "2. Requested Amount is " + label_amount.Text+"\n" +
// "3. Accecpted Amount is"+betterTextBox_accecpted.Text)== DialogResult.Yes)
//{
// this.Counterstatus.approved = true;
// this.Counterstatus.status = 1;
// db.Entry(this.Counterstatus).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
// var dayopen = new Model.counteropening()
// {
// date = this.Counterstatus.date,
// admin_id = INFO.admin_id,
// state = 1,
// updated_at=DateTime.Now,
// created_at=DateTime.Now,
// amount = betterTextBox_accecpted.decVal,
// counter_id=this.Counterstatus.counter_id
// };
// var counterstock = new Model.counterstock()
// {
// date = this.Counterstatus.date,
// admin_id = INFO.admin_id,
// state = 1,
// updated_at = DateTime.Now,
// created_at = DateTime.Now,
// amount = betterTextBox_accecpted.decVal,
// counter_id = this.Counterstatus.counter_id,
// };
// db.counteropenings.Add(dayopen);
// db.counterstocks.Add(counterstock);
// db.SaveChanges();
// this.Parent.Controls.Remove(this);
//}
}
