public Viwer(int id, int sn)
{
var db = new Model.TransportManagementEntities();
var orderitemlist = db.orderitemlists.Find(id);
for (int i = 0; i <= 11; i++)
{
SubItems.Add(new ListViewSubItem());
}
id = orderitemlist.id;
sendername = orderitemlist.sender_name;
senderphone = orderitemlist.sender_phone;
itemname = orderitemlist.itemname;
itemtype_id = (int)orderitemlist.orderitemtype_id;
from_id = (int)orderitemlist.location_from;
to_id = (int)orderitemlist.location_too;
quantity = (decimal)orderitemlist.quantity;
weight = (decimal)orderitemlist.weight;
date = (int)orderitemlist.date;
unit = orderitemlist.unit;
deliver_place = orderitemlist.deliveryplace;
chargeamount = (decimal)orderitemlist.amount;
this.SubItems[0].Text = sn.ToString();
}
public EditItem(int item_id)
{
InitializeComponent();
foreach (var item in DB.Instance.orderitemtypes.ToList())
{
comboBox_itemtype.Items.Add(item);
}
foreach (var item in DB.Instance.locations.ToList())
{
comboBox_locationfrom.Items.Add(item);
comboBox_locationto.Items.Add(item);
}
db = DB.Instance;
var load = db.orderitemlists.Find(item_id);
betterTextBox_sendername.Text = load.sender_name;
betterTextBox_senderphonenumber.Text = load.sender_phone;
betterTextBox_receivername.Text = load.receivername;
betterTextBox_receiverphone.Text = load.receiverphone;
betterTextBox_amount.decVal = load.amount.Value;
betterTextBox_deliverplace.Text = load.deliveryplace;
comboBox_itemtype.Text = (load.orderitemtype as Model.orderitemtype).name;
comboBox_locationto.Text = (load.location1 as Model.location).name;
comboBox_locationfrom.Text = (load.location as Model.location).name;
betterTextBox_itemname.Text = (load.itemname);
betterTextBox_unit.Text = load.unit;
betterTextBox_itemqty.decVal = load.quantity.Value;
betterTextBox_itemweight.decVal = load.weight.Value;
betterTextBox_amount.decVal = load.amount.Value;
this.item_id = item_id;
}
public Viwer(int id, int sn)
{
var db = new Model.TransportManagementEntities();
var billitem = db.tripitems.Find(id);
for (int i = 0; i <= 11; i++)
{
SubItems.Add(new ListViewSubItem());
}
id = billitem.id;
sendername = billitem.sender_name;
senderphone = billitem.sender_phone;
receivername = billitem.receivername;
receiverphone = billitem.receiverphone;
itemname = (billitem.orderitemlist as Model.orderitemlist).itemname;
itemtype_id = (int)billitem.orderitemtype_id;
from_id = (billitem.location as Model.location).id;
to_id = (int)billitem.location_too;
quantity = (decimal)billitem.quantity;
weight = (decimal)billitem.weight;
date = (int)billitem.date;
unit = billitem.unit;
deliver_place = billitem.deliver_place;
chargeamount = (decimal)billitem.amount;
this.SubItems[0].Text = sn.ToString();
}
public AdminSetup()
{
InitializeComponent();
db = DB.Instance;
panel_main.Top = (this.Height - panel_main.Height) / 2;
panel_main.Left = (this.Width - panel_main.Width) / 2;
}
public List()
{
InitializeComponent();
db = DB.Instance;
foreach (var id in db.taxcategories.Select(o => o.id))
{
flowLayoutPanel1.Controls.Add(new Viwer(id));
}
}
public WayItemList()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.vehicles.Where(o => o.active == false).ToList())
{
comboBox_vehiclelist.Items.Add(item);
}
}
public Add()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.staffs.ToList())
{
comboBox_staffname.Items.Add(item);
}
}
public bill()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.vehicles.Where(o => o.active == true).ToList())
{
comboBox_vechiclenumber.Items.Add(item);
}
}
public Add()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in DB.Instance.vehicles.ToList())
{
comboBox_vehiclelist.Items.Add(item);
comboBox_vehiclesave.Items.Add(item);
}
}
public List()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.vehicles.ToList())
{
add(item);
}
}
public ListBillItems(int id, string invoice_no, string vehicle_no)
{
InitializeComponent();
db = DB.Instance;
label_invoicenumber.Text = invoice_no;
label_Vehiclenumber.Text = vehicle_no;
foreach (var item in db.billitems.Where(o => o.bill_id == id).ToList())
{
Bill.billviewer viewer = new Bill.billviewer(item, betterListView_billitems.Items.Count + 1);
betterListView_billitems.Items.Add(viewer);
}
}
public EditAdvance(int id,int staff_id)
{
InitializeComponent();
db = DB.Instance;
var load = db.staffs.Find(staff_id);
label_staffname.Text = load.name;
label_phonenumber.Text = load.phone;
this.staff_id = staff_id;
this.id = id;
var loaddata = db.paidadvances.Find(id);
betterTextBox_amount.decVal = loaddata.paidamount;
betterTextBox_paidby.Text = loaddata.paidby;
}
public ListExpItems(int id, string vehicle_no, int date)
{
InitializeComponent();
db = DB.Instance;
label_id.Text = id.ToString();
label_vehicleno.Text = vehicle_no;
label_date.Text = date.ToString();
foreach (var item in db.otherexpitems.Where(o => o.otherexp_id == id).ToList())
{
listviewer viewer = new listviewer(item, betterListView_list.Items.Count + 1);
betterListView_list.Items.Add(viewer);
}
}
public PaidSalary(int id)
{
InitializeComponent();
db = DB.Instance;
var load = db.staffs.Find(id);
label_staffname.Text = load.name;
label_phonenumber.Text = load.phone;
var advance = db.staffs.Find(id);
betterTextBox_advance.decVal = advance.advance;
betterTextBox_advance.Enabled = false;
this.staff_id = id;
}
public Add()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in DB.Instance.orderitemtypes.ToList())
{
comboBox_itemtype.Items.Add(item);
}
foreach (var item in DB.Instance.locations.ToList())
{
comboBox_locationfrom.Items.Add(item);
comboBox_locationto.Items.Add(item);
}
}
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);
}
}
public StaffEdit(int _id)
{
InitializeComponent();
db = DB.Instance;
id = _id;
var selected = db.staffs.Where(o => o.id == id).First();
txt_name.Text = selected.name;
txt_address.Text = selected.address;
txt_phone.Text = selected.phone;
txt_salary.decVal = selected.salary.Value;
txt_post.Text = selected.post;
//txt_photo.Text = selected.photo;
txt_description.Text = selected.description;
nepaliCalender1.Datestamp = selected.startdate.Value;
}
public Details(int id)
{
InitializeComponent();
db = DB.Instance;
var load = db.vehicles.Find(id);
betterTextBox_type.Text = load.vehicle_type;
betterTextBox_vehiclenumber.Text = load.vehicle_no;
betterTextBox_Enginenumber.Text = load.enginenumber;
betterTextBox_Chassisnumber.Text = load.chassisnumber;
betterTextBox_carringcapacity.Text = load.carringcapacity;
betterTextBox_modelnumber.Text = load.modelnumber;
betterTextBox_ownername.Text = load.onwername;
comboBox_staffname.Text = load.staff.name;
label_Startdate.Text
= load.date.ToString();
}
public Viwer(staff _staff, int sn)
{
for (int i = 0; i < 8; i++)
{
this.SubItems.Add(new ListViewSubItem());
}
var db = new Model.TransportManagementEntities();
Staff = _staff;
SubItems[0].Text = sn.ToString();
SubItems[1].Text = Staff.name;
SubItems[2].Text = Staff.address;
SubItems[3].Text = Staff.phone;
SubItems[4].Text = Staff.salary.ToString();
SubItems[5].Text = Staff.post;
SubItems[6].Text = Staff.startdate.ToString();
SubItems[7].Text = Staff.description;
}
public PaidTax(int id)
{
InitializeComponent();
db = DB.Instance;
var loaddata = db.vehicles.Find(id);
label_vehiclenumber.Text = loaddata.vehicle_no;
this.id = id;
foreach (var year in db.taxcategories.ToList())
{
comboBox_taxyear.Items.Add(year);
}
foreach (var title in db.taxes.ToList())
{
comboBox_Textitle.Items.Add(title);
}
}
public PaidList(int id)
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.paidfinances.Where(o => o.vehicle_id == id).ToList())
{
Viwer viwer = new Viwer(item, betterListView1.Items.Count + 1);
betterListView1.Items.Add(viwer);
}
var load = DB.Instance.vehicles.Find(id);
label_vehiclenumber.Text = load.vehicle_no;
this.id = id;
foreach (ListViewItem item in betterListView1.Items)
{
totalamount += Convert.ToDecimal(item.SubItems[4].Text);
}
betterTextBox_totalamount.decVal = totalamount;
}
public SaveDeliveredItems(List <int> ID, int bill_id)
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.tripitems.Where(o => ID.Contains(o.id)).ToList())
{
FinalDelivered.Delivered.Viwer viwer = new FinalDelivered.Delivered.Viwer(item, betterListView_orderitem.Items.Count + 1);
betterListView_orderitem.Items.Add(viwer);
var load = db.trips.Find(bill_id);
label_vehiclenumber.Text = load.vehicle.vehicle_no;
label_staffname.Text = load.vehicle.staff.name;
}
this.staffandv_id = bill_id;
foreach (ListViewItem lstItem in betterListView_orderitem.Items) // listView has ListViewItem objects
{
valorSum += Convert.ToDecimal(lstItem.SubItems[14].Text); // Columns 4
}
betterTextBox_totalamount.decVal = valorSum;
}
public Edit(int id)
{
InitializeComponent();
db = DB.Instance;
foreach (var taxyear in db.taxcategories.ToList())
{
comboBox_taxyear.Items.Add(taxyear);
}
foreach (var title in db.taxes.ToList())
{
comboBox_Textitle.Items.Add(title);
}
var loaddata = db.taxpaids.Find(id);
comboBox_taxyear.Text = ((loaddata.taxcategory as Model.taxcategory).name);
comboBox_Textitle.Text = (loaddata.tax as Model.tax).title;
betterTextBox_paidbye.Text = loaddata.paidby;
betterTextBox_amout.decVal = loaddata.amount.Value;
betterTextBox_dis.Text = loaddata.discription;
this.id = id;
}
public ListSalaryDetails(int staff_id)
{
InitializeComponent();
db = DB.Instance;
var load = db.staffs.Find(staff_id);
label_staffname.Text = load.name;
label_staffphone.Text = load.phone;
label_staffaddress.Text = load.address;
label_staffphone.Text = load.phone;
label_salaryamount.Text = load.salary.Value.ToString();
this.staff_id = staff_id;
foreach (var item in db.paidsalarys.Where(o => o.staff_id == staff_id).ToList())
{
betterListView_salary.Items.Add(new paidsalaryviwer(item, betterListView_salary.Items.Count + 1));
}
foreach (var item in db.paidadvances.Where(o => o.staff_id == staff_id).ToList())
{
betterListView_Advance.Items.Add(new PaidAdvanceViwer(item, betterListView_Advance.Items.Count + 1));
}
}
public Dashboard()
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.vehicles.ToList())
{
comboBox_vehiclenumber.Items.Add(item);
}
var counts = db.staffs.ToList().Count;
label_totalstaff.Text = counts.ToString();
var activeitem = db.orderitemlists.Where(o => o.active == true).ToList().Count;
var activevehicle = db.vehicles.Where(o => o.active == true).ToList().Count;
//lbl_remainingvehicle.Text = activevehicle.ToString();
var onwayvehicle = db.vehicles.Where(o => o.active == false).ToList().Count;
//lbl_onwayvehicle.Text = onwayvehicle.ToString();
var totalvehicle = db.vehicles.ToList().Count;
lbl_totalvehicle.Text = totalvehicle.ToString();
var onwayitem = db.tripitems.Where(o => o.active == true).ToList().Count;
var deliverditem = db.tripondelivereditems.ToList().Count;
var sum = db.delivered_expences.Sum(o => o.amount);
lbl_deliveredexp.Text = sum.ToString();
var expectedincome = db.bills.Sum(o => o.total_amount);
lbl_totalexpectedcome.Text = expectedincome.ToString();
var other_exp = db.otherexps.Sum(o => o.totalamount);
lbl_otherexp.Text = other_exp.ToString();
var totalcompay = db.finances.ToList().Count;
label_finance.Text = totalcompay.ToString();
var taxtype = db.taxes.ToList().Count;
label_tax.Text = taxtype.ToString();
}
public List(List <int> IDS)
{
InitializeComponent();
db = DB.Instance;
foreach (var item in db.orderitemlists.Where(o => IDS.Contains(o.id)).ToList())
{
Senditems.Viwer viwer = new Senditems.Viwer(item, betterListView_orderitem.Items.Count + 1);
betterListView_orderitem.Items.Add(viwer);
}
foreach (var vechicles in db.vehicles.Where(o => o.active == true))
{
comboBox_vehicle.Items.Add(vechicles);
}
foreach (ListViewItem lstItem in betterListView_orderitem.Items) // listView has ListViewItem objects
{
valorSum += Convert.ToDecimal(lstItem.SubItems[14].Text); // Columns 4
}
betterTextBox_total.decVal = valorSum;
}
public Final()
{
InitializeComponent();
db = DB.Instance;
}
public Viwer()
{
InitializeComponent();
db = DB.Instance;
}