protected void ButtonLogin_Click(object sender, EventArgs e) { List <proc_CheckLogin_Result> user = null; releasedbEntities1 releasedbEntities = new releasedbEntities1(); int Empid = int.Parse(UsrTxtbox.Text); string password = Usrpwd.Text; user = releasedbEntities.proc_CheckLogin(Empid, password).ToList(); string EmpRole = user[0].EmployeeRole; if (EmpRole == "manager") { Session.Add("Empid", UsrTxtbox.Text); Response.Redirect("ManagerRole.aspx"); } if (EmpRole == "developer") { Session.Add("Empid", UsrTxtbox.Text); Response.Redirect("DeveloperRole.aspx"); } if (EmpRole == "tester") { Session.Add("Empid", UsrTxtbox.Text); Response.Redirect("TesterRole.aspx"); } }
protected void ButtonAddModule_Click(object sender, EventArgs e) { int mid; while (!Int32.TryParse(TextBoxModuleID.Text, out mid)) { Message.Text = "Module ID is a number"; } DateTime expected_start_date; while (!(DateTime.TryParse(TextBoxExpectedStartDate.Text, out expected_start_date))) { Message.Text = "Enter the Correct date"; } DateTime expected_end_date; while (!(DateTime.TryParse(TextBoxExpectedEndDate.Text, out expected_end_date))) { Message.Text = "Enter the Correct date"; } DateTime actual_start_date; while (!(DateTime.TryParse(TextBoxActualStartDate.Text, out actual_start_date))) { Message.Text = "Enter the Correct date"; } DateTime actual_end_date; while (!(DateTime.TryParse(TextBoxActualEndDate.Text, out actual_end_date))) { Message.Text = "Enter the Correct date"; } int pid = Convert.ToInt32(DropDownListPid.SelectedValue); LabelDeveloper.Text = "Select a developer to assign the project:"; string SelectDeveloper = DropDownList1.SelectedValue; LabelTester.Text = "Select a tester to assign the project:"; string SelectTester = DropDownList1.SelectedValue; using (releasedbEntities1 db = new releasedbEntities1()) { db.S_InsertIntoModule_P(mid, expected_start_date, expected_end_date, actual_start_date, actual_end_date, pid); db.I_AssignModuleToDeveloper_P(SelectDeveloper, mid); db.I_AssignModuleToTester_P(SelectTester, mid); db.SaveChanges(); Message.Text = "Project Added"; } }
protected void AddButton_Click(object sender, EventArgs e) { int EmpId = Convert.ToInt32(EmpIDBox.Text); string EmpName = EmpNameBox.Text; string Erole = DropDownList1.SelectedValue; using (releasedbEntities1 db = new releasedbEntities1()) { db.S_AddEmployee_p(EmpId, EmpName, Erole); db.SaveChanges(); MessageLabel.Text = "Employee is added"; } }
protected void AssignButton_Click(object sender, EventArgs e) { int ProjectId = Convert.ToInt32(DropDownList3.SelectedValue); string ProjName = DropDownList1.SelectedValue; int Tid = Convert.ToInt32(DropDownList2.SelectedValue); using (releasedbEntities1 db = new releasedbEntities1()) { db.S_AddTeamLeadtoProject_p(ProjectId, ProjName, Tid); db.SaveChanges(); Label1.Text = "Team Lead ID is added"; } }
protected void AddButton_Click1(object sender, EventArgs e) { int projid; while (!(Int32.TryParse(ProIDBox.Text, out projid))) { MessageLabel.Text = "Enter the Project ID"; } string projname = ProjNameBox.Text; DateTime expected_start_date; while (!(DateTime.TryParse(TextBoxExpectedStartDate.Text, out expected_start_date))) { MessageLabel.Text = "Enter the Correct date"; } DateTime expected_end_date; while (!(DateTime.TryParse(TextBoxExpectedEndDate.Text, out expected_end_date))) { MessageLabel.Text = "Enter the Correct date"; } DateTime actual_start_date; while (!(DateTime.TryParse(TextBoxActualStartDate.Text, out actual_start_date))) { MessageLabel.Text = "Enter the Correct date"; } DateTime actual_end_date; while (!(DateTime.TryParse(TextBoxActualEndDate.Text, out actual_end_date))) { MessageLabel.Text = "Enter the Correct date"; } using (releasedbEntities1 db = new releasedbEntities1()) { db.S_InsertIntoProject_p(projid, projname, expected_start_date, expected_end_date, actual_start_date, actual_end_date); db.SaveChanges(); ProjNameBox.Text = ""; ProIDBox.Text = ""; MessageLabel.Text = "Project Added"; } }
protected void AddButton_Click1(object sender, EventArgs e) { int projid; while (!(Int32.TryParse(ProIDBox.Text, out projid))) { MessageLabel.Text = "Enter the Project ID"; } string projname = ProjNameBox.Text; using (releasedbEntities1 db = new releasedbEntities1()) { db.S_InsertIntoProject_p(projid, projname); db.SaveChanges(); ProjNameBox.Text = ""; ProIDBox.Text = ""; MessageLabel.Text = "Project Added"; } }