protected void Page_Load(object sender, EventArgs e)
{
ltlMessage.Text = null;
if (!Page.IsPostBack)
{
DepartmentTableAdapter departmentTableAdapter = new DepartmentTableAdapter();
DataTable dtDepartment = departmentTableAdapter.GetDataByStatus("ACTIVE");
ddlDepartment.DataValueField = "ID";
ddlDepartment.DataTextField = "DepartmentName";
ddlDepartment.DataSource = dtDepartment;
ddlDepartment.DataBind();
ddlDepartment.Items.Insert(0, new ListItem("Select Department"));
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
DataTable dtUserRoleName = userRoleTableAdapter.GetDataByStatus("ACTIVE");
ddlUserRole.DataValueField = "ID";
ddlUserRole.DataTextField = "RoleName";
ddlUserRole.DataSource = dtUserRoleName;
ddlUserRole.DataBind();
ddlUserRole.Items.Insert(0, new ListItem("Select User Role"));
UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter();
UserProfile originalUserProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Request["UserProfileID"]));
ddlDepartment.SelectedValue = originalUserProfile.DepartmentID.ToString();
ddlUserRole.SelectedValue = originalUserProfile.UserRoleID.ToString();
txtName.Text = originalUserProfile.Name;
txtUsername.Text = originalUserProfile.Username;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltlMessage.Text = null;
if (!Page.IsPostBack)
{
DepartmentTableAdapter departmentTableAdapter = new DepartmentTableAdapter();
DataTable dtDepartment = departmentTableAdapter.GetDataByStatus("ACTIVE");
ddlDepartment.DataValueField = "ID";
ddlDepartment.DataTextField = "DepartmentName";
ddlDepartment.DataSource = dtDepartment;
ddlDepartment.DataBind();
ddlDepartment.Items.Insert(0, new ListItem("Select Department"));
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
DataTable dtUserRoleName = userRoleTableAdapter.GetDataByStatus("ACTIVE");
ddlUserRole.DataValueField = "ID";
ddlUserRole.DataTextField = "RoleName";
ddlUserRole.DataSource = dtUserRoleName;
ddlUserRole.DataBind();
ddlUserRole.Items.Insert(0, new ListItem("Select User Role"));
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();
DepartmentTableAdapter daDeps = new DepartmentTableAdapter();
daDeps.Fill(ds.Department);
EmployeeInfoTableAdapter daEmp = new EmployeeInfoTableAdapter();
daEmp.Fill(ds.EmployeeInfo);
dgEmps.ItemsSource = ds.EmployeeInfo.DefaultView;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//cn.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
cn.Open();
SqlCommand cmdSelect = new SqlCommand();
cmdSelect.Connection = cn;
cmdSelect.CommandType = CommandType.Text;
cmdSelect.CommandText = "select * from EmployeeInfo";
da.SelectCommand = cmdSelect;
da.Fill(ds, "Emps");
cmdSelect.CommandType = CommandType.Text;
cmdSelect.CommandText = "Select* from Department";
da.Fill(ds, "Deps");
DepartmentTableAdapter daDeps = new DepartmentTableAdapter();
daDeps.Fill(mds.Department);
EmployeeInfoTableAdapter daEmps = new EmployeeInfoTableAdapter();
daEmps.Fill(mds.EmployeeInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request["q"] != null)
{
if (Session["Login"].ToString() != null)
{
Session["Login"] = null;
Session["Name"] = null;
Response.Redirect(ConfigurationManager.AppSettings.GetValues("mainURL") + "signin.aspx");
}
}
UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter();
UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"]));
DataTable dtUserProfile = userProfileTableAdapter.GetDataByStatus("ACTIVE");
if (userProfile.DepartmentID == 1)
{
if (userProfile.UserRoleID == 1)
{
ltlCustomer.Visible = true;
ltlDepartmentView.Visible = true;
ltlInvoiceReportView.Visible = true;
ltlUserProfileView.Visible = true;
ltlUserRoleView.Visible = true;
ltlRiver.Visible = true;
ltlRiverView.Visible = true;
//chartWaterLevel.Visible = true;
//string[] x = new string[dtWaterLevel.Rows.Count];
//int[] y = new int[dtWaterLevel.Rows.Count];
//for (int i = 0; i < dtWaterLevel.Rows.Count; i++)
//{
// x[i] = dtWaterLevel.Rows[i][2].ToString();
// y[i] = Convert.ToInt32(dtWaterLevel.Rows[i][0]);
//}
//chartWaterLevel.Series[0].Points.DataBindXY(x, y);
//chartWaterLevel.Series[0].ChartType = SeriesChartType.Column;
//chartWaterLevel.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//chartWaterLevel.Legends[0].Enabled = true;
}
}
else if (userProfile.DepartmentID == 2)
{
if (userProfile.UserRoleID == 2)
{
ltlCustomerView.Visible = true;
ltlDepartmentView.Visible = true;
ltlUserProfileView.Visible = true;
ltlUserRoleView.Visible = true;
}
else if (userProfile.UserRoleID == 3)
{
ltlCustomerView.Visible = true;
ltlDepartmentView.Visible = false;
ltlInvoiceReportView.Visible = true;
ltlUserProfileView.Visible = false;
ltlUserRoleView.Visible = false;
}
}
else if (userProfile.DepartmentID == 3)
{
if (userProfile.UserRoleID == 4)
{
ltlCustomerView.Visible = false;
ltlDepartmentView.Visible = false;
ltlUserProfileView.Visible = false;
ltlUserRoleView.Visible = false;
}
}
else if (userProfile.DepartmentID == 4)
{
if (userProfile.UserRoleID == 5 || userProfile.UserRoleID == 6)
{
ltlCustomerView.Visible = false;
ltlDepartmentView.Visible = false;
ltlInvoiceReportView.Visible = false;
ltlUserProfileView.Visible = false;
ltlUserRoleView.Visible = false;
}
}
else if (userProfile.DepartmentID == 5)
{
if (userProfile.UserRoleID == 7)
{
ltlCustomerView.Visible = true;
ltlDepartmentView.Visible = false;
ltlInvoiceReportView.Visible = false;
ltlUserProfileView.Visible = false;
ltlUserRoleView.Visible = false;
}
}
else if (userProfile.DepartmentID == 6)
{
if (userProfile.UserRoleID == 8)
{
ltlCustomerView.Visible = false;
ltlDepartmentView.Visible = false;
ltlInvoiceReportView.Visible = false;
ltlUserProfileView.Visible = false;
ltlUserRoleView.Visible = false;
}
}
DataTable dtUserProfileList = userProfileTableAdapter.GetDataByStatus("ACTIVE");
ltlUser.Text = dtUserProfileList.Rows.Count.ToString();
CustomerTableAdapter customeTableAdapter = new CustomerTableAdapter();
DataTable dtCustomerList = customeTableAdapter.GetDataByStatus("ACTIVE");
ltlCustomer.Text = dtCustomerList.Rows.Count.ToString();
ProjectTableAdapter projectTableAdapter = new ProjectTableAdapter();
DataTable dtProjectList = projectTableAdapter.GetDataByStatus("ACTIVE");
DepartmentTableAdapter departmentTableAdapter = new DepartmentTableAdapter();
DataTable dtDepartmentList = departmentTableAdapter.GetDataByStatus("ACTIVE");
ltlDepartment.Text = dtDepartmentList.Rows.Count.ToString();
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
DataTable dtUserRole = userRoleTableAdapter.GetDataByStatus("ACTIVE");
ltlUserRole.Text = dtUserRole.Rows.Count.ToString();
WaterLevelTableAdapter waterLevelTabeleAdapter = new WaterLevelTableAdapter();
DataTable dtWaterLevel = waterLevelTabeleAdapter.GetDataByStatus("ACTIVE");
ltlWaterLevel.Text = dtWaterLevel.Rows.Count.ToString();
RiverTableAdapter riverTableAdapter = new RiverTableAdapter();
DataTable dtRiver = riverTableAdapter.GetDataByStatus("ACTIVE");
ltlRiver.Text = dtRiver.Rows.Count.ToString();
DamTableAdapter damTableAdapter = new DamTableAdapter();
DataTable dtDam = damTableAdapter.GetDataByStatus("ACTIVE");
ltlDam.Text = dtDam.Rows.Count.ToString();
WaterLevelDamTableAdapter waterLevelDamTabeleAdapter = new WaterLevelDamTableAdapter();
DataTable dtWaterLevelDam = waterLevelDamTabeleAdapter.GetDataByStatus("ACTIVE");
ltlWaterLevelDam.Text = dtWaterLevelDam.Rows.Count.ToString();
}
}
/// <summary>
/// Insert and Select data using Strong Typed DataSet
/// </summary>
private static void InsertSelectUsingStrongTypedDataSet()
{
Console.WriteLine("\r\nInsert and Select data using Strong Typed "
+ "DataSet...");
// 1. Create a Strong Typed DataSet object and fill its corresponding
// data tables
// Create a Strong Typed DataSet object
SQLServer2005DBDataSet dsSQLServer = new SQLServer2005DBDataSet();
// Use the PersonTableAdapter to fill the Person table
PersonTableAdapter taPerson = new PersonTableAdapter();
SQLServer2005DBDataSet.PersonDataTable tblPerson = dsSQLServer.
Person;
taPerson.Fill(tblPerson);
// Use the CourseTableAdapter to fill the Course table
CourseTableAdapter taCourse = new CourseTableAdapter();
SQLServer2005DBDataSet.CourseDataTable tblCourse = dsSQLServer.
Course;
taCourse.Fill(tblCourse);
// Use the DepartmentTableAdapter to fill the Department table
DepartmentTableAdapter taDepartment = new DepartmentTableAdapter();
SQLServer2005DBDataSet.DepartmentDataTable tblDepartment =
dsSQLServer.Department;
taDepartment.Fill(tblDepartment);
// 2. Insert a record into the Person table
//--- (Strong Typed DataSet)
// We don't set the PersonCategory value because we have set the
// default value property of the DataSet PersonCategory column.
SQLServer2005DBDataSet.PersonRow addRowPerson = tblPerson.
NewPersonRow();
addRowPerson.LastName = "Ge";
addRowPerson.FirstName = "Jialiang";
addRowPerson.SetHireDateNull();
addRowPerson.EnrollmentDate = DateTime.Now;
addRowPerson.Picture = ReadImage(@"MSDN.jpg");
tblPerson.AddPersonRow(addRowPerson);
// ---Insert a record into the Person table
// ---(Untyped DataSet)
//DataRow addRowPerson = tblPerson.NewRow();
//addRowPerson["LastName"] = "Ge";
//addRowPerson["FirstName"] = "Jialiang";
//addRowPerson["HireDate"] = DBNull.Value;
//addRowPerson["EnrollmentDate"] = DateTime.Now;
//addRowPerson["Picture"] = ReadImage(@"MSDN.jpg");
//tblPerson.Rows.Add(addRowPerson);
// Update the Person table
taPerson.Update(tblPerson);
// 3. Insert a record into the Person table using PersionTableAdapter
taPerson.Insert("Sun", "Hongye", DateTime.Now, null,
ReadImage(@"MSDN.jpg"), 2);
// 4. Find a certain record in the Person table by primary key
// ---(Strong Typed DataSet)
SQLServer2005DBDataSet.PersonRow findRowPerson = tblPerson.
FindByPersonID(1);
// ---Find a certain record in the Person table by primary key
// ---(Untyped DataSet)
//DataRow findRowPerson = tblPerson.Rows.Find(1);
// Display the result record
if (findRowPerson != null)
{
// Use IsColumnNameNull method to check the DBNull value
Console.WriteLine("{0}\t{1} {2}\t{3}", findRowPerson.PersonID,
findRowPerson.FirstName, findRowPerson.LastName,
findRowPerson.IsEnrollmentDateNull() ? "(DBNull)" :
findRowPerson.EnrollmentDate.ToShortDateString());
}
// 5. Display data in two related data tables
foreach (SQLServer2005DBDataSet.DepartmentRow rowDepartment in
dsSQLServer.Department)
{
Console.WriteLine("\r\nCourses for Department({0})",
rowDepartment.DepartmentID);
foreach (SQLServer2005DBDataSet.CourseRow rowCourse
in rowDepartment.GetCourseRows())
{
Console.WriteLine("{0} - {1}", rowCourse.CourseID,
rowCourse.Title);
}
}
}