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);
}
