protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select max(work_assign_id)from work_assign"; a_id = db.max_id(cmd); cmd.CommandText = "select work_id,work_name from work"; DropDownList1.DataSource = db.getData(cmd); DropDownList1.DataValueField = "work_id"; DropDownList1.DataTextField = "work_name"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); cmd.CommandText = "select employee_id,employee_name from employee_management where emptype='worker'"; DropDownList2.DataSource = db.getData(cmd); DropDownList2.DataValueField = "employee_id"; DropDownList2.DataTextField = "employee_name"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "select"); } }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT parts_request.reqt_id, parts_request.technician_id, employee_management.employee_name, parts_request.mechine_id, mechine_management.mechine_name, parts_request.parts, parts_request.description, parts_request.date, parts_request.status FROM parts_request INNER JOIN employee_management ON parts_request.technician_id = employee_management.employee_id INNER JOIN mechine_management ON parts_request.mechine_id = mechine_management.mechine_id where parts_request.status='pending'"; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT work_assign.work_id, work_assign.work_assign_id, work.work_name, work_assign.worker_id, work_assign.from_date, work_assign.to_date FROM work_assign INNER JOIN work ON work_assign.work_id = work.work_id where work_assign.worker_id ='" + Session["id"] + "' and work_assign.status='pending'"; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT fault_prediction.mechine_id, fault_prediction.fault_id, mechine_management.mechine_name, fault_prediction.worker_id, fault_prediction.technician_id, employee_management.employee_name, fault_prediction.date, fault_prediction.time, fault_prediction.problem, fault_prediction.status FROM fault_prediction INNER JOIN mechine_management ON fault_prediction.mechine_id = mechine_management.mechine_id INNER JOIN employee_management ON fault_prediction.worker_id = employee_management.employee_id"; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); MultiView1.SetActiveView(View1); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT fault_prediction.fault_id, mechine_management.mechine_name, employee_management.employee_name, fault_prediction.date, fault_prediction.time, fault_prediction.problem, fault_prediction.status, fault_prediction.mechine_id, fault_prediction.worker_id FROM fault_prediction INNER JOIN mechine_management ON fault_prediction.mechine_id = mechine_management.mechine_id INNER JOIN employee_management ON fault_prediction.worker_id = employee_management.employee_id WHERE (fault_prediction.technician_id = '" + Session["id"] + "') AND (fault_prediction.status = 'process')"; DataGrid2.DataSource = obj.getData(cmd); DataGrid2.DataBind(); MultiView1.SetActiveView(View1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from employee_management "; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); MultiView1.SetActiveView(View1); cmd.CommandText = "select max(employee_id)from employee_management"; id = obj.max_id(cmd); } }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT work_assign.worker_id, employee_management.employee_name, work_assign.work_id, work.work_name, work_assign.work_assign_id, work_assign.from_date, work_assign.to_date, work_assign.status FROM work_assign INNER JOIN employee_management ON work_assign.worker_id = employee_management.employee_id INNER JOIN work ON work_assign.work_id = work.work_id"; DataGrid1.DataSource = db.getData(cmd); DataGrid1.DataBind(); }
public string login(string uname, string pswd) { string s = ""; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from login where username='******' and password='******'"; DataTable dt = db.getData(cmd); if (dt.Rows.Count > 0) { s = dt.Rows[0][0].ToString() + "#" + dt.Rows[0][3].ToString(); } else { s = "error"; } return(s); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT complaints.employee_id, employee_management.employee_name, complaints.cmp_id, complaints.type, complaints.complaints, complaints.reply, complaints.date FROM complaints INNER JOIN employee_management ON complaints.employee_id = employee_management.employee_id where complaints.reply='pending'"; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from mechine_management "; DataGrid1.DataSource = obj.getData(cmd); DataGrid1.DataBind(); MultiView1.SetActiveView(View1); cmd.CommandText = "select max(mechine_id)from mechine_management"; mid = obj.max_id(cmd); cmd.CommandText = "select distinct department from employee_management"; DropDownList1.DataSource = obj.getData(cmd); DropDownList1.DataValueField = "department"; DropDownList1.DataTextField = "department"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); cmd.CommandText = "select department from employee_management"; DropDownList2.DataSource = obj.getData(cmd); DropDownList2.DataValueField = "department"; DropDownList2.DataTextField = "department"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "select"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from complaints where type='Technician' and employee_id= '" + Session["id"] + "'"; DataGrid2.DataSource = obj.getData(cmd); DataGrid2.DataBind(); MultiView1.SetActiveView(View2); cmd.CommandText = "select max(cmp_id)from complaints"; id = obj.max_id(cmd); cmd.CommandText = "select employee_name from employee_management where employee_id='" + Session["id"] + "'"; DataTable dt = obj.getData(cmd); if (dt.Rows.Count > 0) { TextBox4.Text = dt.Rows[0][0].ToString(); } TextBox3.Text = DateTime.Now.ToShortDateString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select max(fault_id)from fault_prediction"; id = db.max_id(cmd); cmd.CommandText = "select mechine_id,mechine_name from mechine_management"; DropDownList1.DataSource = db.getData(cmd); DropDownList1.DataValueField = "mechine_id"; DropDownList1.DataTextField = "mechine_name"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); cmd.CommandText = "select employee_id,employee_name from employee_management where emptype='worker'"; DropDownList4.DataSource = db.getData(cmd); DropDownList4.DataValueField = "employee_id"; DropDownList4.DataTextField = "employee_name"; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, "select"); cmd.CommandText = "select employee_id,employee_name from employee_management where emptype='technician'"; DropDownList3.DataSource = db.getData(cmd); DropDownList3.DataValueField = "employee_id"; DropDownList3.DataTextField = "employee_name"; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, "select"); cmd.CommandText = "select * from fault_prediction"; DataGrid1.DataSource = db.getData(cmd); DataGrid1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select max(reqt_id)from parts_request"; id = db.max_id(cmd); cmd.CommandText = "SELECT parts_request.mechine_id, parts_request.reqt_id, parts_request.technician_id, parts_request.parts, parts_request.description, parts_request.date, parts_request.status, mechine_management.mechine_name FROM parts_request INNER JOIN mechine_management ON parts_request.mechine_id = mechine_management.mechine_id where parts_request.status='pending' and parts_request.technician_id='" + Session["id"] + "'"; DataGrid1.DataSource = db.getData(cmd); DataGrid1.DataBind(); cmd.CommandText = "select mechine_id,mechine_name from mechine_management"; DropDownList1.DataSource = db.getData(cmd); DropDownList1.DataValueField = "mechine_id"; DropDownList1.DataTextField = "mechine_name"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); TextBox3.Text = System.DateTime.Now.ToShortDateString(); } }