private void materialButton_saveandprint_Click(object sender, EventArgs e) { if (comboBox_vehicle.SelectedItem == null) { CustomControls.Alert.show("Select", "please Select Vechicle ", 2000); return; } int date; var newbills = new Model.trip() { vechicle_id = (comboBox_vehicle.SelectedItem as Model.vehicle).id, totalamount = valorSum, created_at = DateTime.Now, updated_at = DateTime.Now, admin_id = INFO.admin_id, date = nepaliCalender1.Datestamp }; db.trips.Add(newbills); db.SaveChanges(); foreach (var item in betterListView_orderitem.Items.Cast <Viwer>().ToList()) { item.save(newbills.id, nepaliCalender1.Datestamp); } Senditems.Printing printing = new Printing(); printing.prininte(newbills); foreach (ListViewItem item1 in betterListView_exp.Items) { var title = item1.SubItems[1].Text; var amount = Convert.ToDecimal(item1.SubItems[2].Text); var exp = new Model.expence() { title = title, amount = amount, bill_id = newbills.id, created_at = DateTime.Now, updated_at = DateTime.Now, date = nepaliCalender1.Datestamp, admin_id = INFO.admin_id, vehicle_id = (comboBox_vehicle.SelectedItem as Model.vehicle).id, }; db.expences.Add(exp); db.SaveChanges(); } var deactivate_vechicle = db.vehicles.Find((comboBox_vehicle.SelectedItem as Model.vehicle).id); deactivate_vechicle.active = false; db.Entry(deactivate_vechicle).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); betterListView_exp.Items.Clear(); betterListView_orderitem.Items.Clear(); betterTextBox_total.Clear(); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { var load = db.trips.Find(staffandv_id); var savedelivered = new Model.tripondelivered() { staff_id = load.staff_id, vehicle_id = load.vechicle_id, date = nepaliCalender_date.Datestamp, updated_at = DateTime.Now, created_at = DateTime.Now, admin_id = INFO.admin_id, amount = betterTextBox_expamount.decVal, bill_id = load.id, }; date = nepaliCalender_date.Datestamp; var activatedvehicle = db.vehicles.Find(load.vechicle_id); activatedvehicle.active = true; db.Entry(activatedvehicle).State = System.Data.Entity.EntityState.Modified; db.tripondelivereds.Add(savedelivered); db.SaveChanges(); foreach (var item in betterListView_orderitem.Items.Cast <Viwer>().ToList()) { item.save(savedelivered.id, savedelivered.date); } foreach (ListViewItem item1 in betterListView_exp.Items) { var title = item1.SubItems[1].Text; var amount = Convert.ToDecimal(item1.SubItems[2].Text); var exp = new Model.expence() { title = title, amount = amount, bill_id = load.id, created_at = DateTime.Now, updated_at = DateTime.Now, date = nepaliCalender_date.Datestamp, admin_id = INFO.admin_id, vehicle_id = load.vechicle_id }; db.expences.Add(exp); db.SaveChanges(); } this.Close(); }
private void Save_Click(object sender, EventArgs e) { var save_bill = new Model.bill() { vehicle_number = (comboBox_vechiclenumber.SelectedItem as Model.vehicle).id, date = nepaliCalender_DAte.Datestamp, invoice_number = betterTextBox_invoicenumber.Text, total_amount = betterTextBox_totalamount.decVal, total_Weight = betterTextBox_totalweight.decVal, total_exp = betterTextBox_totalexpenses.decVal, created_at = DateTime.Now, updated_at = DateTime.Now }; db.bills.Add(save_bill); db.SaveChanges(); foreach (var item in betterListView_billitems.Items.Cast <viewer>().ToList()) { item.save(save_bill.id, nepaliCalender_DAte.Datestamp); } foreach (ListViewItem item in betterListView_addexp.Items) { var title = item.SubItems[1].Text; var amount = Convert.ToDecimal(item.SubItems[2].Text); var exp = new Model.delivered_expences() { title = title, amount = amount, bill_id = save_bill.id, vehicle_number = (comboBox_vechiclenumber.SelectedItem as Model.vehicle).id, admin_id = INFO.admin_id, updated_at = DateTime.Now, created_at = DateTime.Now }; db.delivered_expences.Add(exp); db.SaveChanges(); } betterListView_billitems.Items.Clear(); betterTextBox_invoicenumber.Clear(); comboBox_vechiclenumber.SelectedIndex = -1; betterTextBox_Exptitle.Clear(); betterListView_addexp.Items.Clear(); betterTextBox_Expamount.Clear(); betterTextBox_totalamount.Clear(); betterTextBox_totalexpenses.Clear(); betterTextBox_totalweight.Clear(); clear(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_amount.decVal == 0) { CustomControls.Alert.show("Amount ", "enter paid amount", 2000); return; } if (betterTextBox_paidby.Text.Trim() == "") { CustomControls.Alert.show("name ", "enter paid by", 2000); return; } var edit = db.paidsalarys.Find(id); //var loadadv = db.staffs.Find(staff_id); // loadadv.advance = (loadadv.advance + edit.usedadvence) + betterTextBox_advance.decVal; // db.Entry(loadadv).State = System.Data.Entity.EntityState.Modified; edit.staff_id = staff_id; edit.paidby = betterTextBox_paidby.Text; edit.paidamount = betterTextBox_amount.decVal; edit.paid_date = nepaliCalender_paiddate.Datestamp; edit.paid_form = nepaliCalender_paidfrom.Datestamp; edit.paid_to = nepaliCalender_paidto.Datestamp; db.Entry(edit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); editdata?.Invoke(edit); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_amount.decVal == 0) { CustomControls.Alert.show("Amount ", "enter paid amount", 2000); return; } if (betterTextBox_paidby.Text.Trim() == "") { CustomControls.Alert.show("name ", "enter paid by", 2000); return; } var edit = db.paidadvances.Find(id); var loaddata = db.staffs.Find(staff_id); loaddata.advance = (loaddata.advance - edit.paidamount) + betterTextBox_amount.decVal; db.Entry(loaddata).State = System.Data.Entity.EntityState.Modified; edit.paidamount = betterTextBox_amount.decVal; edit.paidby = betterTextBox_paidby.Text; edit.staff_id = staff_id; edit.paid_date = nepaliCalender_paiddate.Datestamp; edit.updated_at = DateTime.Now; edit.created_at = DateTime.Now; db.Entry(edit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); editdata?.Invoke(edit); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_vehiclenumber.Text.Trim() == "") { CustomControls.Alert.show("Number", "Please Enter Vehicle Number", 2000); return; } if (betterTextBox_type.Text.Trim() == "") { CustomControls.Alert.show("Type", "Please Enter Vehicle Type", 2000); return; } if (betterTextBox_modelnumber.Text.Trim() == "") { CustomControls.Alert.show("Model Number", "Please Enter Model Number", 2000); return; } if (betterTextBox_Chassisnumber.Text.Trim() == "") { CustomControls.Alert.show("Chassis Number", "Please Enter Chassis Number", 2000); return; } if (betterTextBox_carringcapacity.Text.Trim() == "") { CustomControls.Alert.show("Carring Capacity", "Please Enter Carring Capacity", 2000); return; } if (betterTextBox_ownername.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please Enter owner Name", 2000); return; } if (comboBox_staffname.SelectedItem == null) { CustomControls.Alert.show("Select Name", "Please Select staff name", 2000); comboBox_staffname.Focus(); return; } var load = db.vehicles.Find(id); load.vehicle_no = betterTextBox_vehiclenumber.Text; load.vehicle_type = betterTextBox_type.Text; load.modelnumber = betterTextBox_modelnumber.Text; load.carringcapacity = betterTextBox_carringcapacity.Text; load.chassisnumber = betterTextBox_Chassisnumber.Text; load.onwername = betterTextBox_ownername.Text; load.date = nepaliCalender_startdate.Datestamp; load.enginenumber = betterTextBox_Enginenumber.Text; load.staff_id = (comboBox_staffname.SelectedItem as Model.staff).id; db.Entry(load).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(load); this.Close(); }
private void btn_delete_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you wnt to delete?", "Delete record", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { CustomControls.Alert.show("Finance", "data deleted", 1500); var i = db.finances.Where(o => o.id == this.id).First(); db.Entry(i).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); this.Parent.Controls.Remove(this); } }
private void btn_add_Click(object sender, EventArgs e) { if (txt_name.Text.Trim() == "") { CustomControls.Alert.show("name", "Enter Name", 1500); return; } if (txt_address.Text.Trim() == "") { CustomControls.Alert.show("address", "Enter Address", 1500); return; } if (txt_phone.Text.Trim() == "") { CustomControls.Alert.show("phone", "Enter phone", 1500); return; } if (txt_salary.Text.Trim() == "") { CustomControls.Alert.show("salary", "Enter Salary", 1500); return; } if (txt_post.Text.Trim() == "") { CustomControls.Alert.show("post", "Enter post", 1500); return; } try { var i = db.staffs.Find(id); i.name = txt_name.Text; i.address = txt_address.Text; i.phone = txt_phone.Text; i.salary = txt_salary.decVal; i.post = txt_post.Text; //i.photo = txt_photo.Text; i.description = txt_description.Text; i.startdate = nepaliCalender1.Datestamp; i.created_at = DateTime.Now; i.updated_at = DateTime.Now; db.Entry(i).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(i); this.Close(); } catch (Exception ex) { CustomControls.Alert.show("Data", "Error Data", 1500); } }
private void materialButton_save_Click(object sender, EventArgs e) { if (comboBox_taxyear.SelectedItem == null) { CustomControls.Alert.show("Select", "Please select tax yearr", 2000); comboBox_taxyear.Focus(); return; } if (comboBox_Textitle.SelectedItem == null) { CustomControls.Alert.show("Title", "Please select tax title", 2000); comboBox_Textitle.Focus(); return; } if (betterTextBox_amout.decVal == 0) { CustomControls.Alert.show("Amount", "Please enter tax amount", 2000); betterTextBox_amout.Focus(); return; } if (betterTextBox_paidbye.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter Name of paidby", 2000); betterTextBox_paidbye.Focus(); return; } if (betterTextBox_dis.Text.Trim() == "") { CustomControls.Alert.show("Discription", "Please enter discription", 2000); betterTextBox_dis.Focus(); return; } var addnew = new Model.taxpaid() { vahicle_id = id, tax_id = ((comboBox_Textitle.SelectedItem as Model.tax).id), taxyear_id = ((comboBox_taxyear.SelectedItem as Model.taxcategory).id), date = nepaliCalender_date.Datestamp, paidby = betterTextBox_paidbye.Text, amount = betterTextBox_amout.decVal, discription = betterTextBox_dis.Text, admin_id = INFO.admin_id, updated_at = DateTime.Now, created_at = DateTime.Now }; db.taxpaids.Add(addnew); db.SaveChanges(); adddata?.Invoke(addnew); this.Close(); }
public void initdelete() { try { var db = new Model.TransportManagementEntities(); var i = db.staffs.Find(Staff.id); db.Entry(i).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); this.ListView.Items.Remove(this); } catch { CustomControls.Alert.show("this record is not delete", "this record is not deleted this record is related in another transaction", 3000); } }
private void materialButton_delete_Click(object sender, EventArgs e) { try { var delete = db.vehicles.Find(id); db.Entry(delete).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); this.Parent.Controls.Remove(this); } catch (Exception ex) { CustomControls.Alert.show("not delete", "this record it's record is used in another transaction", 3000); return; } }
private void materialButton_Delete_Click(object sender, EventArgs e) { try { if (saveondatabase) { db.Entry(taxcategory).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } this.Parent.Controls.Remove(this); } catch { CustomControls.Alert.show("not delete", "this is not delete", 2000); } }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_amount.decVal == 0) { CustomControls.Alert.show("Amount ", "enter paid amount", 2000); return; } if (betterTextBox_paidby.Text.Trim() == "") { CustomControls.Alert.show("name ", "enter paid by", 2000); return; } var add = new Model.paidsalary() { staff_id = staff_id, paidamount = betterTextBox_amount.decVal, paid_form = nepaliCalender_paidfrom.Datestamp, paid_to = nepaliCalender_paidto.Datestamp, paid_date = nepaliCalender_paiddate.Datestamp, paidby = betterTextBox_paidby.Text, created_at = DateTime.Now, updated_at = DateTime.Now, usedadvence = betterTextBox_useadvanceamount.decVal }; if (checkBox_usedadvance.Checked) { var advance = db.staffs.Find(staff_id); if (betterTextBox_useadvanceamount.decVal <= advance.advance) { advance.advance -= betterTextBox_useadvanceamount.decVal; } else { CustomControls.Alert.show("Advance amount", "your used advance amount is greter then paid advance amount please check", 4000); return; } db.Entry(advance).State = System.Data.Entity.EntityState.Modified; } db.paidsalarys.Add(add); db.SaveChanges(); adddata.Invoke(add); this.Close(); this.Close(); }
private void button_save_Click(object sender, EventArgs e) { if (textBox_Key.Text.Trim() == "" || textBox_password.Text.Trim() == "" || textBox_repassword.Text.Trim() == "" || textBox_username.Text.Trim() == "") { CustomControls.Alert.show("Admin Setup", "Please Fill All Fields", 3000); return; } db.admins.Add(new Model.admin() { updated_at = DateTime.Now, created_at = DateTime.Now, username = "******", password = CustomControls.Encrypt.EncryptString(textBox_password.Text, "need12345") }); db.SaveChanges(); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (comboBox_taxyear.SelectedItem == null) { CustomControls.Alert.show("Select", "Please select tax yearr", 2000); return; } if (comboBox_Textitle.SelectedItem == null) { CustomControls.Alert.show("Title", "Please select tax title", 2000); return; } if (betterTextBox_amout.decVal == 0) { CustomControls.Alert.show("Amount", "Please enter tax amount", 2000); return; } if (betterTextBox_paidbye.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter Name of paidby", 2000); return; } if (betterTextBox_dis.Text.Trim() == "") { CustomControls.Alert.show("Discription", "Please enter discription", 2000); return; } var editdata = db.taxpaids.Find(id); editdata.taxyear_id = ((comboBox_taxyear.SelectedItem as Model.taxcategory).id); editdata.tax_id = ((comboBox_Textitle.SelectedItem as Model.tax).id); editdata.paidby = betterTextBox_paidbye.Text; editdata.amount = betterTextBox_amout.decVal; editdata.discription = betterTextBox_dis.Text; editdata.date = nepaliCalender_date.Datestamp; db.Entry(editdata).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); edit?.Invoke(editdata); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { foreach (ListViewItem lstItem in betterListView_orderitem.Items) // listView has ListViewItem objects { orderitem_id = Convert.ToInt32(lstItem.SubItems[15].Text); // Columns 4 var orderitemactive = db.orderitemlists.Where(o => o.id == orderitem_id).First(); orderitemactive.active = true; db.Entry(orderitemactive).State = System.Data.Entity.EntityState.Modified; var load = db.trips.Find(billid); load.vehicle.active = true; var activatedvehicle = db.vehicles.Find(load.vechicle_id); db.Entry(activatedvehicle).State = System.Data.Entity.EntityState.Modified; foreach (var item in db.tripitems.Where(o => o.item_id == orderitem_id).ToList()) { item.active = false; db.Entry(item).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); this.Close(); } }
private void materialButton_save_Click_1(object sender, EventArgs e) { if (betterTextBox_sendername.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter sender name", 2000); return; } if (betterTextBox_receiverphone.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter receiver phone", 2000); return; } if (betterTextBox_receivername.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter receiver name", 2000); return; } if (betterTextBox_senderphonenumber.Text.Trim() == "") { CustomControls.Alert.show("Address", "Please enter sender phone", 2000); return; } if (betterTextBox_itemname.Text.Trim() == "") { CustomControls.Alert.show("Name", " please enter item name", 2000); return; } if (comboBox_itemtype.SelectedItem == null) { CustomControls.Alert.show("Item Type", " please select item type", 2000); return; } if (comboBox_locationfrom.SelectedItem == null) { CustomControls.Alert.show("From", " please select location ", 2000); return; } if (comboBox_locationto.SelectedItem == null) { CustomControls.Alert.show("To", "select location", 2000); return; } if (betterTextBox_itemweight.Text.Trim() == "") { CustomControls.Alert.show("To", "enter weight of item", 2000); return; } if (betterTextBox_itemqty.Text.Trim() == "") { CustomControls.Alert.show("To", "enter quantity of item", 2000); return; } if (betterTextBox_amount.Text.Trim() == "") { CustomControls.Alert.show("To", "enter charge amount", 2000); return; } if (betterTextBox_unit.Text.Trim() == "") { CustomControls.Alert.show("To", "enter unit", 2000); return; } if (betterTextBox_deliverplace.Text.Trim() == "") { CustomControls.Alert.show("To", "enter deliver place", 2000); return; } var edit = db.orderitemlists.Find(item_id); edit.sender_name = betterTextBox_sendername.Text; edit.receiverphone = betterTextBox_receiverphone.Text; edit.receivername = betterTextBox_receivername.Text; edit.sender_phone = betterTextBox_senderphonenumber.Text; edit.itemname = betterTextBox_itemname.Text; edit.location_from = (comboBox_locationfrom.SelectedItem as Model.location).id; edit.location_too = (comboBox_locationto.SelectedItem as Model.location).id; edit.date = nepaliCalender_DAte.Datestamp; edit.unit = betterTextBox_unit.Text; edit.weight = betterTextBox_itemweight.decVal; edit.quantity = betterTextBox_itemqty.decVal; edit.orderitemtype_id = (comboBox_itemtype.SelectedItem as Model.orderitemtype).id; edit.deliveryplace = betterTextBox_deliverplace.Text; edit.amount = betterTextBox_amount.decVal; db.Entry(edit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); editdata?.Invoke(edit); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_vehiclenumber.Text.Trim() == "") { CustomControls.Alert.show("Number", "Please Enter Vehicle Number", 2000); return; } if (betterTextBox_type.Text.Trim() == "") { CustomControls.Alert.show("Type", "Please Enter Vehicle Type", 2000); return; } if (betterTextBox_modelnumber.Text.Trim() == "") { CustomControls.Alert.show("Model Number", "Please Enter Model Number", 2000); return; } if (betterTextBox_Chassisnumber.Text.Trim() == "") { CustomControls.Alert.show("Chassis Number", "Please Enter Chassis Number", 2000); return; } if (betterTextBox_carringcapacity.Text.Trim() == "") { CustomControls.Alert.show("Carring Capacity", "Please Enter Carring Capacity", 2000); return; } if (betterTextBox_ownername.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please Enter owner Name", 2000); return; } if (comboBox_staffname.SelectedItem == null) { CustomControls.Alert.show("Select Name", "Please Select staff name", 2000); comboBox_staffname.Focus(); return; } var addnew = new Model.vehicle() { vehicle_type = betterTextBox_type.Text, vehicle_no = betterTextBox_vehiclenumber.Text, modelnumber = betterTextBox_modelnumber.Text, chassisnumber = betterTextBox_Chassisnumber.Text, carringcapacity = betterTextBox_carringcapacity.Text, enginenumber = betterTextBox_Enginenumber.Text, date = nepaliCalender_startdate.Datestamp, onwername = betterTextBox_ownername.Text, staff_id = (comboBox_staffname.SelectedItem as Model.staff).id, created_at = DateTime.Now, updated_at = DateTime.Now, admin_id = INFO.admin_id, active = true }; db.vehicles.Add(addnew); db.SaveChanges(); add?.Invoke(addnew); this.Close(); }
private void materialButton_save_Click(object sender, EventArgs e) { if (betterTextBox_sendername.Text.Trim() == "") { CustomControls.Alert.show("Name", "Please enter sender name", 2000); return; } if (betterTextBox_receivername.Text.Trim() == "") { CustomControls.Alert.show("Address", "Please enter sender address", 2000); return; } if (betterTextBox_senderphonenumber.Text.Trim() == "") { CustomControls.Alert.show("Address", "Please enter sender phone", 2000); return; } if (betterTextBox_itemname.Text.Trim() == "") { CustomControls.Alert.show("Name", " please enter item name", 2000); return; } if (comboBox_itemtype.SelectedItem == null) { CustomControls.Alert.show("Item Type", " please select item type", 2000); return; } if (comboBox_locationfrom.SelectedItem == null) { CustomControls.Alert.show("From", " please select location ", 2000); return; } if (comboBox_locationto.SelectedItem == null) { CustomControls.Alert.show("To", "select location", 2000); return; } if (betterTextBox_itemweight.Text.Trim() == "") { CustomControls.Alert.show("To", "enter weight of item", 2000); return; } if (betterTextBox_itemqty.Text.Trim() == "") { CustomControls.Alert.show("To", "enter quantity of item", 2000); return; } if (betterTextBox_amount.Text.Trim() == "") { CustomControls.Alert.show("To", "enter charge amount", 2000); return; } if (betterTextBox_unit.Text.Trim() == "") { CustomControls.Alert.show("To", "enter unit", 2000); return; } if (betterTextBox_deliverplace.Text.Trim() == "") { CustomControls.Alert.show("To", "enter deliver place", 2000); return; } var additem = new Model.orderitemlist() { sender_name = betterTextBox_sendername.Text, sender_phone = betterTextBox_senderphonenumber.Text, receivername = betterTextBox_receivername.Text, receiverphone = betterTextBox_receiverphone.Text, itemname = betterTextBox_itemname.Text, orderitemtype_id = ((comboBox_itemtype.SelectedItem as Model.orderitemtype).id), location_from = ((comboBox_locationfrom.SelectedItem as Model.location).id), location_too = ((comboBox_locationto.SelectedItem as Model.location).id), weight = betterTextBox_itemweight.decVal, active = true, deliveryplace = betterTextBox_deliverplace.Text, unit = betterTextBox_unit.Text, date = nepaliCalender_DAte.Datestamp, quantity = betterTextBox_itemqty.decVal, amount = betterTextBox_amount.decVal, created_at = DateTime.Now, updated_at = DateTime.Now }; db.orderitemlists.Add(additem); db.SaveChanges(); adddata?.Invoke(additem); this.Close(); }