protected void Page_Load(object sender, EventArgs e)
{
Datagridfunctions ds = new Datagridfunctions();
string type = (string)HttpContext.Current.Session["user_type"];
if (type == "ENG")
{
DataGridPre.DataSource = ds.searchpreengineer();
}
else
{
DataGridPre.DataSource = ds.searchpre();
}
DataGridPre.DataBind();
if (type != "MGR")
{
if (type != "TL" && CheckBox1.Checked == true)
{
hide(Convert.ToInt32(DropDownList1.SelectedValue));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Datagridfunctions ds = new Datagridfunctions();
DataGridOpenEmployee.DataSource = ds.getbookedactivities();
DataGridOpenEmployee.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Datagridfunctions ds = new Datagridfunctions();
DataGridCloseEmployee.DataSource = ds.getactivitydataopen();
DataGridCloseEmployee.DataBind();
}
}
private void databinding()
{
Datagridfunctions ds = new Datagridfunctions();
SqlDataReader rdr = ds.getactivitydata();
DataGridEmployee.DataSource = ds.getactivitydata();
DataGridEmployee.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Datagridfunctions ds = new Datagridfunctions();
string ty = (string)HttpContext.Current.Session["user_type"];
int tyi;
if (ty == "MGR")
{
tyi = 1;
CheckBox2.Visible = false;
CheckBox2.Checked = false;
}
else
{
tyi = 0;
}
if (!IsPostBack)
{
CheckBox1.Checked = false;
CheckBox2.Checked = false;
DropDownList1.DataSource = ds.getemployeecode();
DropDownList1.DataTextField = "Employee_Code";
DropDownList1.DataValueField = "Employee_Code";
DropDownList1.DataBind();
DataGridEmpCode.DataSource = ds.getactivityemp(DropDownList1.SelectedValue);
DataGridEmpCode.DataBind();
}
if (CheckBox2.Checked == true && tyi == 0)
{
Label1.Visible = false;
DropDownList1.Visible = false;
CheckBox1.Visible = false;
DataGridEmpCode.DataSource = null;
DataGridEmpCode.DataSource = ds.getactivityown();
DataGridEmpCode.DataBind();
}
else
{
Label1.Visible = true;
DropDownList1.Visible = true;
CheckBox1.Visible = true;
DataGridEmpCode.DataSource = ds.getactivityemp(DropDownList1.SelectedValue);
DataGridEmpCode.DataBind();
if (CheckBox1.Checked == true)
{
hide(Convert.ToInt32(DropDownList2.SelectedValue));
}
else
{
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Datagridfunctions ds = new Datagridfunctions();
string selectedemp = DropDownList1.SelectedValue;
DataGridEmpCode.DataSource = null;
DataGridEmpCode.DataSource = ds.getactivityemp(DropDownList1.SelectedValue);
DataGridEmpCode.DataBind();
if (CheckBox1.Checked == true)
{
hide(Convert.ToInt32(DropDownList2.SelectedValue));
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label2.Visible = false;
if (!IsPostBack)
{
Datagridfunctions ds = new Datagridfunctions();
DataGrid1.DataSource = ds.getactivitybooktl();
DataGrid1.DataBind();
TextBox1.Visible = true;
TextBox2.Visible = false;
Button1.Visible = false;
// Button2.Visible = false;
Single_Engineer.Checked = true;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int count = 0;
while (count < DataGridOpenEmployee.Items.Count)
{
CheckBox checkbooking = (CheckBox)DataGridOpenEmployee.Items[count].FindControl("CloseBooking_Checkbox");
Label activitycode = (Label)DataGridOpenEmployee.Items[count].FindControl("Activity_Code_Close");
Label employeecode = (Label)DataGridOpenEmployee.Items[count].FindControl("Employee_Code_Close");
if (checkbooking.Checked == true)
{
Datagridfunctions ds = new Datagridfunctions();
ds.startbookedactivity(activitycode.Text);
}
count++;
}
Response.Redirect("Home_Screen.aspx?");
}
protected void Update_Click(object sender, EventArgs e)
{
int count = 0;
while (count < DataGridEmployee.Items.Count)
{
DataGridEmployee.Items[count].FindControl("Book_Checkbox");
int x = DataGridEmployee.CurrentPageIndex;
CheckBox checkbooking = (CheckBox)DataGridEmployee.Items[count].FindControl("Book_Checkbox");
Label activitycode = (Label)DataGridEmployee.Items[count].FindControl("Activity_Code");
if (checkbooking.Checked == true)
{
Datagridfunctions ds = new Datagridfunctions();
ds.openbooking(activitycode.Text);
ds.changestatus(activitycode.Text, 'O');
}
count++;
}
Response.Redirect("Home_Screen.aspx?");
}
protected void Button3_Click(object sender, EventArgs e)
{
int x = 1;
if (Single_Engineer.Checked == true)
{
if (TextBox1.Text != "")
{
Datagridfunctions ds = new Datagridfunctions();
if (ds.checkemployid(TextBox1.Text))
{
int count = 0;
while (count < DataGrid1.Items.Count)
{
CheckBox checkbooking = (CheckBox)DataGrid1.Items[count].FindControl("Book_Checkbox_Book_TL");
Label activitycode = (Label)DataGrid1.Items[count].FindControl("Activity_Code_Book_TL");
if (checkbooking.Checked == true)
{
ds.openbookingtl(TextBox1.Text, activitycode.Text);
}
count++;
}
}
else
{
Label2.Visible = true;
Label2.Text += Convert.ToString(TextBox1.Text) + " " + "not a valid Employee Code";
x = 0;
}
}
}
else
{
Datagridfunctions ds = new Datagridfunctions();
string[] checkid = gangid.Split('+');
for (int i = 1; i < checkid.Length; i++)
{
if (ds.checkemployid(checkid[i]))
{
}
else
{
x = 0;
Label2.Visible = true;
Label2.Text += checkid[i] + " " + "not a valid Employee Code. ";
}
}
if (gangid != "" & x == 1)
{
int count = 0;
while (count < DataGrid1.Items.Count)
{
CheckBox checkbooking = (CheckBox)DataGrid1.Items[count].FindControl("Book_Checkbox_Book_TL");
Label activitycode = (Label)DataGrid1.Items[count].FindControl("Activity_Code_Book_TL");
if (checkbooking.Checked == true)
{
ds.opengangbooking(gangid, activitycode.Text);
}
count++;
}
}
}
if (x == 1)
{
Response.Redirect("Home_Screen.aspx?");
gangid = "";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Datagridfunctions ds = new Datagridfunctions();
}
