protected void ShortListSuppliers_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(SearchCompanyName.Text))
{
errormsgs.Add("Enter a company name.");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
else
{
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> info = sysmgr.Suppliers_GetByPartialCompanyName(SearchCompanyName.Text);
info.Sort((x, y) => x.CompanyName.CompareTo(y.CompanyName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Supplier.CompanyName);
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select ...");
if (info.Count == 0)
{
errormsgs.Add("No suppliers found with supplied company name");
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
catch (Exception ex)
{
errormsgs.Add("File Error: " + GetInnerException(ex).Message);
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
}
protected void BindSupplierList()
{
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> datainfo = sysmgr.Supplier_List();
datainfo.Sort((x, y) => x.CompanyName.CompareTo(y.CompanyName));
SupplierList.DataSource = datainfo;
SupplierList.DataTextField = nameof(Supplier.CompanyName);
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "..select");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).Message);
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
public void BindSupplierList()
{
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> info = sysmgr.Supplier_List();
info.Sort((x, y) => x.CompanyName.CompareTo(y.CompanyName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Supplier.CompanyName); // look in .data xxxx.cs entity to find out what to put in these
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select...");
}
catch (Exception ex)
{
errormsgs.Add("File Error: " + GetInnerException(ex).Message);
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
protected void BindSupplierList()
{
try
{
Controller03 sysmgr = new Controller03();
List <Entity03> info = null;
info = sysmgr.List();
info.Sort((x, y) => x.ContactName.CompareTo(y.ContactName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Entity03.ContactName);
SupplierList.DataValueField = nameof(Entity03.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select...");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
public void BindSupplierList()
{
//TODO: code the method to load the SupplierList control
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> info = sysmgr.Suppliers_List();
info.Sort((x, y) => x.CompanyName.CompareTo(y.CompanyName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Supplier.CompanyName);
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select ...");
}
catch (Exception ex)
{
errormsgs.Add("File Error: " + GetInnerException(ex).Message);
LoadMessageDisplay(errormsgs, "alert alert-warning");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("~/Login.aspx");
}
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
con.Open();
string query = "select privilege from EMPLOYEE where employeeID = " + Session["user"];
SqlCommand cmd = new SqlCommand(query, con);
if (Convert.ToInt32(cmd.ExecuteScalar()) == 0)
{
Response.Redirect("~/Login.aspx");
}
con.Close();
if (!IsPostBack)
{
con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
con.Open();
query = "select Dept_number, Dept_name from DEPARTMENT";
cmd = new SqlCommand(query, con);
DepartmentList.DataSource = cmd.ExecuteReader();
DepartmentList.DataBind();
ListItem defaultDept = new ListItem("Select department", "-1");
DepartmentList.Items.Insert(0, defaultDept);
con.Close();
con.Open();
query = "select companyID, company_name from SUPPLIER ORDER BY company_name";
cmd = new SqlCommand(query, con);
SupplierList.DataSource = cmd.ExecuteReader();
SupplierList.DataBind();
ListItem defaultSupp = new ListItem("Select supplier", "-1");
SupplierList.Items.Insert(0, defaultSupp);
con.Close();
}
}
protected void BindSupplierList()
{
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> info = null;
info = sysmgr.Supplier_List();
info.Sort((x, y) => x.ContactName.CompareTo(y.ContactName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Supplier.ContactName);
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select...");
}
catch (Exception ex)
{
//using the specialized error handling DataList control
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
protected void SelectButton_Click(object sender, EventArgs e)
{
string Key = StrKey.Text.ToString();
if (Key == null || Key.Equals(""))
{
Jscript.AjaxAlert(this, "请输入关键字！");
return;
}
List <Supplier> list = new List <Supplier>();
list = Leyp.SQLServerDAL.Factory.getSupplierDAL().getSearchListByKey(Key);
if (list.Count == 0)
{
Label1.Visible = true;
}
else
{
SupplierList.DataSource = list;
SupplierList.DataBind();
}
}
protected void BindCategoryList()
{
try
{
CategoryController sysmger = new CategoryController();
List <Category> datainfo = sysmger.Category_List();
datainfo.Sort((x, y) => x.CategoryName.CompareTo(y.CategoryName));
SupplierList.DataSource = datainfo;
SupplierList.DataTextField = nameof(Category.CategoryName);
SupplierList.DataValueField = nameof(Category.CategoryID);
SupplierList.DataBind();
SupplierList.DataBind();
SupplierList.Items.Insert(0, "select...");
}
catch (Exception ex)
{
errormsgs.Add(GetInnerException(ex).ToString());
LoadMessageDisplay(errormsgs, "alert alert-danger");
}
}
protected void BindSupplierList()
{
try
{
SupplierController sysmgr = new SupplierController();
List <Supplier> info = null;
info = sysmgr.List();
info.Sort((x, y) => x.ContactName.CompareTo(y.ContactName));
SupplierList.DataSource = info;
SupplierList.DataTextField = nameof(Supplier.ContactName);
SupplierList.DataValueField = nameof(Supplier.SupplierID);
SupplierList.DataBind();
ListItem myitem = new ListItem();
myitem.Value = "0";
myitem.Text = "select...";
SupplierList.Items.Insert(0, myitem);
//SupplierList.Items.Insert(0, "select...");
}
catch (Exception ex)
{
ShowMessage(GetInnerException(ex).ToString(), "alert alert-danger");
}
}
