public List<DepartmentModel> GetAllDepartmentName(List<DepartmentModel> departmentModelsParameter) { List<DepartmentModel> departmentModels = new List<DepartmentModel>(); string query = String.Format(@"select id,name from tblDepartment where id=@deptId"); foreach (DepartmentModel department in departmentModelsParameter) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@deptId",department.DeptID); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { DepartmentModel departmentModel = new DepartmentModel(); departmentModel.DeptID = Convert.ToInt32(rdr[0]); departmentModel.DepartmentName = rdr[1].ToString(); departmentModels.Add(departmentModel); } connection.Close(); } } } return departmentModels; }
public int SaveDepartmentName(DepartmentModel departmentModel) { string query = String.Format("Insert into tblDepartment values(@name,@facultyID)"); sqlCommand.CommandText = query; SqlParameter nameParameter = new SqlParameter("@name",departmentModel.DepartmentName); sqlCommand.Parameters.Add(nameParameter); SqlParameter facultyIdParameter = new SqlParameter("@facultyID",departmentModel.FacultyID); sqlCommand.Parameters.Add(facultyIdParameter); sqlConnection.Open(); int rowsAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); return rowsAffected; }
public bool IsDepartNameExist(DepartmentModel departmentModel) { bool isDepartmentNameExist = false; string query = String.Format("Select * from tblDepartment where name=@deptName"); SqlParameter nameParameter = new SqlParameter("@deptName",departmentModel.DepartmentName); sqlCommand.Parameters.Add(nameParameter); sqlCommand.CommandText = query; sqlConnection.Open(); SqlDataReader rdr = sqlCommand.ExecuteReader(); while (rdr.Read()) { isDepartmentNameExist = true; } sqlConnection.Close(); return isDepartmentNameExist; }
public void saveDepartmentButton_Click(object sender, EventArgs e) { DepartmentModel departmentModel = new DepartmentModel(); departmentModel.DepartmentName = departmentNameTextBox.Text; departmentModel.FacultyID = Convert.ToInt32(facultyDropDownList.SelectedItem.Value); if (departmentNameTextBox.Text=="") { successStatusLabel.InnerText = "Please enter the department name"; } else { if (facultyDropDownList.SelectedValue=="-1") { successStatusLabel.InnerText = "Please select the faculty."; } else { if (addDepartmentBll.IsDepartNameExist(departmentModel)) { failStatusLabel.InnerText = "Department name already exist"; successStatusLabel.InnerText = ""; } else { if (addDepartmentBll.SaveDepartmentName(departmentModel) > 0) { failStatusLabel.InnerText = ""; successStatusLabel.InnerText = "Department name saved"; ShowDepartmentInformationInGridView(); GetAllFacultyInDropDownList(); ListItem listItem = new ListItem("Select faculty", "-1"); facultyDropDownList.Items.Insert(0, listItem); } else { failStatusLabel.InnerText = ""; failStatusLabel.InnerText = "Department name not saved"; } } } } }
public List<DepartmentModel> GetAllDepartmentId() { List<DepartmentModel> departmentModels = new List<DepartmentModel>(); string query = String.Format(@"select deptId from tblStudentSemisterRegistration"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query,connection)) { connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { DepartmentModel departmentModel = new DepartmentModel(); departmentModel.DeptID = Convert.ToInt32(rdr[0]); departmentModels.Add(departmentModel); } connection.Close(); } } return departmentModels; }
public int SaveDepartmentName(DepartmentModel departmentModel) { return addDepartmentDal.SaveDepartmentName(departmentModel); }
public bool IsDepartNameExist(DepartmentModel departmentModel) { return addDepartmentDal.IsDepartNameExist(departmentModel); }