internal bool AddFaculty(MembersAddition.Faculty fac, Users user) { bool isAdded = false; try { conn1.Open(); SqlCommand insertCommand = new SqlCommand("uspAddFaculty", conn1); insertCommand.CommandType = CommandType.StoredProcedure; insertCommand.Parameters.AddWithValue("@ipvUserId", user.Userid); insertCommand.Parameters.AddWithValue("@ipvLoginUserName", user.UserName); insertCommand.Parameters.AddWithValue("@ipvPass", Encrypt(user.Password)); insertCommand.Parameters.AddWithValue("@ipvRoleOfperson", user.Role); insertCommand.Parameters.AddWithValue("@ipvFullName", user.FullName); insertCommand.Parameters.AddWithValue("@ipvFacultyId", fac.FacultyId); insertCommand.Parameters.AddWithValue("@ipvFacFirstName", fac.FacultyFName); insertCommand.Parameters.AddWithValue("@ipvFacLastName", fac.FacultyLName); insertCommand.Parameters.AddWithValue("@ipvUhclEmail", fac.FeMail); insertCommand.Parameters.AddWithValue("@ipvUserName", fac.facultyUserName); int count = insertCommand.ExecuteNonQuery(); if (count == 2) { isAdded = true; } } catch (Exception ex) { throw ex; } finally { if (conn1.State == ConnectionState.Open) { conn1.Close(); } } return(isAdded); }
internal bool AddFaculty(MembersAddition.Faculty fac, Users user) { bool isAdded = dal.AddFaculty(fac, user); return(isAdded); }