private void load_dropdown()
 {
     SaleInvoice repository = new SaleInvoice();
     var result = repository.GetAll().Where(r => r.Deleted == false).Select(r => new { id = r.InvoiceId, name = r.InvoiceNo }).ToList();
     result.Insert(0, new { id = 0, name = "--SELECT ID--" });
     DropDownList1.DataSource = result;
     DropDownList1.DataBind();
 }