private void GetParent()
{
string sql = "SELECT DISTINCT WS_ID,WS_NAME FROM TBWS_WAREHOUSE WHERE WS_FATHERID<>'ROOT' ORDER BY WS_ID";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
DropDownListParent.DataSource = dt;
DropDownListParent.DataTextField = "WS_NAME";
DropDownListParent.DataValueField = "WS_ID";
DropDownListParent.DataBind();
}
private void GetParent()
{
string sql = "SELECT DISTINCT WS_NAME,WS_ID FROM TBWS_WAREHOUSE WHERE WS_FATHERID='ROOT' ORDER BY WS_ID";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
DataRow row = dt.NewRow();
row["WS_NAME"] = "ROOT";
row["WS_ID"] = "ROOT";
dt.Rows.InsertAt(row, 0);
DropDownListParent.DataTextField = "WS_NAME";
DropDownListParent.DataValueField = "WS_ID";
DropDownListParent.DataSource = dt;
DropDownListParent.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
userID = Int32.Parse(Session["UserID"].ToString());
eRegisterData.DAL DAL = new eRegisterData.DAL();
SqlConnection conn = DAL.getSubject();
SqlCommand comm = new SqlCommand();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = @" SELECT ActorID
FROM Actors
WHERE UserID='" + userID + "'";
studentID = Int32.Parse(comm.ExecuteScalar().ToString());
conn.Close();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
if (!IsPostBack)
{
System.Data.DataTable teacherName = new System.Data.DataTable();
eRegisterData.DAL oDal = new eRegisterData.DAL();
teacherName = oDal.GetActors(2);
DropDownListTeacher.DataSource = teacherName.DefaultView;
DropDownListTeacher.DataTextField = teacherName.Columns["Name"].ColumnName.ToString();
DropDownListTeacher.DataValueField = teacherName.Columns["ActorID"].ColumnName.ToString();
DropDownListTeacher.DataBind();
DropDownListTeacher.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListTeacher.SelectedIndex = DropDownListTeacher.Items.Count - 1;
System.Data.DataTable parentName = new System.Data.DataTable();
eRegisterData.DAL oDal1 = new eRegisterData.DAL();
parentName = oDal1.GetActors(3);
DropDownListParent.DataSource = parentName.DefaultView;
DropDownListParent.DataTextField = parentName.Columns["Name"].ColumnName.ToString();
DropDownListParent.DataValueField = parentName.Columns["ActorID"].ColumnName.ToString();
DropDownListParent.DataBind();
DropDownListParent.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListParent.SelectedIndex = DropDownListParent.Items.Count - 1;
System.Data.DataTable studentName = new System.Data.DataTable();
eRegisterData.DAL oDal2 = new eRegisterData.DAL();
studentName = oDal2.GetActors(4);
DropDownListStudent.DataSource = studentName.DefaultView;
DropDownListStudent.DataTextField = studentName.Columns["Name"].ColumnName.ToString();
DropDownListStudent.DataValueField = studentName.Columns["ActorID"].ColumnName.ToString();
DropDownListStudent.DataBind();
DropDownListStudent.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListStudent.SelectedIndex = DropDownListStudent.Items.Count - 1;
System.Data.DataTable messageTypeInfo = new System.Data.DataTable();
eRegisterData.DAL oDal3 = new eRegisterData.DAL();
messageTypeInfo = oDal3.getMessageType();
DropDownListMessageType.DataSource = messageTypeInfo.DefaultView;
DropDownListMessageType.DataTextField = messageTypeInfo.Columns["Type"].ColumnName.ToString();
DropDownListMessageType.DataValueField = messageTypeInfo.Columns["MessageTypeID"].ColumnName.ToString();
DropDownListMessageType.DataBind();
DropDownListMessageType.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListMessageType.SelectedIndex = DropDownListMessageType.Items.Count - 1;
}
}
else
{
Response.Redirect("~/eRegister.aspx");
}
}
