internal bool SaveTeacherDetails(TeacherDetails Teacher, out TeacherRegDetails objDetails)
{
return obj.SaveTeacherDetails(Teacher, out objDetails);
}
internal bool SaveTeacherDetails(TeacherDetails Teacher, out TeacherRegDetails objDetails)
{
var p_firstName = new SqlParameter();
p_firstName.ParameterName = "p_firstName";
p_firstName.Direction = ParameterDirection.Input;
p_firstName.SqlDbType = SqlDbType.VarChar;
p_firstName.Value = (string.IsNullOrEmpty(Teacher.FirstName)) ? (object)DBNull.Value : Teacher.FirstName;
p_firstName.IsNullable = true;
var p_middleName = new SqlParameter();
p_middleName.ParameterName = "p_middleName";
p_middleName.Direction = ParameterDirection.Input;
p_middleName.SqlDbType = SqlDbType.VarChar;
p_middleName.Value = (string.IsNullOrEmpty(Teacher.MiddleName)) ? (object)DBNull.Value : Teacher.MiddleName;
p_middleName.IsNullable = true;
var p_lastName = new SqlParameter();
p_lastName.ParameterName = "p_lastName";
p_lastName.Direction = ParameterDirection.Input;
p_lastName.SqlDbType = SqlDbType.VarChar;
p_lastName.Value = (string.IsNullOrEmpty(Teacher.LastName)) ? (object)DBNull.Value : Teacher.LastName;
p_lastName.IsNullable = true;
var p_email = new SqlParameter();
p_email.ParameterName = "p_email";
p_email.Direction = ParameterDirection.Input;
p_email.SqlDbType = SqlDbType.VarChar;
p_email.Value = (string.IsNullOrEmpty(Teacher.Email)) ? (object)DBNull.Value : Teacher.Email;
p_email.IsNullable = true;
var p_selectedGenderId = new SqlParameter();
p_selectedGenderId.ParameterName = "p_selectedGenderId";
p_selectedGenderId.Direction = ParameterDirection.Input;
p_selectedGenderId.SqlDbType = SqlDbType.VarChar;
p_selectedGenderId.Value = (string.IsNullOrEmpty(Teacher.SelectedGenderId)) ? (object)DBNull.Value : Teacher.SelectedGenderId;
p_selectedGenderId.IsNullable = true;
var p_contactno = new SqlParameter();
p_contactno.ParameterName = "p_contactno";
p_contactno.Direction = ParameterDirection.Input;
p_contactno.SqlDbType = SqlDbType.VarChar;
p_contactno.Value = (string.IsNullOrEmpty(Teacher.Contactno)) ? (object)DBNull.Value : Teacher.Contactno;
p_contactno.IsNullable = true;
var p_schoolName = new SqlParameter();
p_schoolName.ParameterName = "p_schoolName";
p_schoolName.Direction = ParameterDirection.Input;
p_schoolName.SqlDbType = SqlDbType.VarChar;
p_schoolName.Value = (string.IsNullOrEmpty(Teacher.SchoolName)) ? (object)DBNull.Value : Teacher.SchoolName;
p_schoolName.IsNullable = true;
var p_schoolAdd = new SqlParameter();
p_schoolAdd.ParameterName = "p_schoolAdd";
p_schoolAdd.Direction = ParameterDirection.Input;
p_schoolAdd.SqlDbType = SqlDbType.VarChar;
p_schoolAdd.Value = (string.IsNullOrEmpty(Teacher.SchoolAdd)) ? (object)DBNull.Value : Teacher.SchoolAdd;
p_schoolAdd.IsNullable = true;
var p_schoolDistrictId = new SqlParameter();
p_schoolDistrictId.ParameterName = "p_schoolDistrictId";
p_schoolDistrictId.Direction = ParameterDirection.Input;
p_schoolDistrictId.SqlDbType = SqlDbType.VarChar;
p_schoolDistrictId.Value = (string.IsNullOrEmpty(Teacher.SchoolDistrictId)) ? (object)DBNull.Value : Teacher.SchoolDistrictId;
p_schoolDistrictId.IsNullable = true;
var p_ScholZoneId = new SqlParameter();
p_ScholZoneId.ParameterName = "p_ScholZoneId";
p_ScholZoneId.Direction = ParameterDirection.Input;
p_ScholZoneId.SqlDbType = SqlDbType.VarChar;
p_ScholZoneId.Value = (string.IsNullOrEmpty(Teacher.ScholZoneId)) ? (object)DBNull.Value : Teacher.ScholZoneId;
p_ScholZoneId.IsNullable = true;
var p_schoolMandalid = new SqlParameter();
p_schoolMandalid.ParameterName = "p_schoolMandalid";
p_schoolMandalid.Direction = ParameterDirection.Input;
p_schoolMandalid.SqlDbType = SqlDbType.VarChar;
p_schoolMandalid.Value = (string.IsNullOrEmpty(Teacher.SchoolMandalid)) ? (object)DBNull.Value : Teacher.SchoolMandalid;
p_schoolMandalid.IsNullable = true;
var p_schoolVillage = new SqlParameter();
p_schoolVillage.ParameterName = "p_schoolVillage";
p_schoolVillage.Direction = ParameterDirection.Input;
p_schoolVillage.SqlDbType = SqlDbType.VarChar;
p_schoolVillage.Value = (string.IsNullOrEmpty(Teacher.SchoolVillage)) ? (object)DBNull.Value : Teacher.SchoolVillage;
p_schoolVillage.IsNullable = true;
var result = lobj1.Database.SqlQuery<TeacherRegDetails>(@"proc_TeacherReg @p_firstName, @p_middleName,@p_lastName,
@p_email,@p_selectedGenderId,@p_contactno,@p_schoolName,@p_schoolAdd,@p_schoolDistrictId,
@p_ScholZoneId,@p_schoolMandalid,@p_schoolVillage", p_firstName, p_middleName, p_lastName,
p_email, p_selectedGenderId, p_contactno, p_schoolName, p_schoolAdd, p_schoolDistrictId,
p_ScholZoneId, p_schoolMandalid, p_schoolVillage).ToList();
objDetails = result.SingleOrDefault();
return result.Count() > 0;
}
