public void Update(int Id, string FirstName, string MiddleName, string FamilyName, string EGN, int SubjectId , string PhoneNumber, string Adress, int PositionId, string Photo, out string Message, out System.Drawing.Color Color) { if (Id == 1 && PositionId != 1) { message.Update(-3, out Message, out Color); } else { Object.TeacherInfo teacher = new Object.TeacherInfo(); teacher.Id = Id; teacher.FirstName = FirstName; teacher.MiddleName = MiddleName; teacher.FamilyName = FamilyName; teacher.EGN = EGN; teacher.SubjectId = SubjectId; teacher.PhoneNumber = PhoneNumber; teacher.Adress = Adress; teacher.PositionId = PositionId; if (Photo != null) { teacher.Photo = BusinessLayer.SharedMethods.getImageBase64(Photo); } int resultNum = crud.Update(teacher); message.Update(resultNum, out Message, out Color); } }
public void Create(string firstName, string middleName, string familyName, int subjectId, string EGN, string phoneNumber, string adress, int positionId, System.Web.UI.WebControls.FileUpload fileUploadPhoto, out string Message, out System.Drawing.Color Color) { Object.TeacherInfo teacher = new Object.TeacherInfo(); teacher.FirstName = firstName; teacher.MiddleName = middleName; teacher.FamilyName = familyName; teacher.SubjectId = subjectId; teacher.EGN = EGN; teacher.PhoneNumber = phoneNumber; teacher.Adress = adress; teacher.PositionId = positionId; teacher.Photo = SharedMethods.getImage(fileUploadPhoto); //If image has not been chosen, mark photo as null instead of 0 or "" if (teacher.Photo.Length == 0) { teacher.Photo = null; } int resultNumber = crud.Create(teacher); message.Create(resultNumber, out Message, out Color); }
public int Update(Object.TeacherInfo teacher) { using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString())) { SqlCommand cmd = new SqlCommand("spUpdateTeacherInfo_tblTeacherInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", teacher.Id); cmd.Parameters.AddWithValue("@FirstName", teacher.FirstName); cmd.Parameters.AddWithValue("@MiddleName", teacher.MiddleName); cmd.Parameters.AddWithValue("@FamilyName", teacher.FamilyName); cmd.Parameters.AddWithValue("@SubjectId", teacher.SubjectId); cmd.Parameters.AddWithValue("@EGN", teacher.EGN); cmd.Parameters.AddWithValue("@PhoneNumber", teacher.PhoneNumber); cmd.Parameters.AddWithValue("@Adress", teacher.Adress); cmd.Parameters.AddWithValue("@PositionId", teacher.PositionId); cmd.Parameters.AddWithValue("@Photo", teacher.Photo); SqlParameter Result = new SqlParameter("@ResultNumber", SqlDbType.Int); Result.Direction = ParameterDirection.Output; cmd.Parameters.Add(Result); con.Open(); cmd.ExecuteScalar(); con.Close(); return((int)Result.Value); } }
public int Delete(Object.TeacherInfo teacher) { using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString())) { SqlCommand cmd = new SqlCommand("Delete From tblTeacherInfo Where Id = @Id", con); cmd.Parameters.AddWithValue("@Id", teacher.Id); con.Open(); return((int)cmd.ExecuteNonQuery()); } }
public void Delete(int Id, out string Message, out System.Drawing.Color Color) { Object.TeacherInfo teacher = new Object.TeacherInfo(); teacher.Id = Id; if (Id == 1) { message.Delete(-1, out Message, out Color); } else { int resultNum = crud.Delete(teacher); message.Delete(resultNum, out Message, out Color); } }
public int GetTeacherClassId() { string EGN = System.Web.HttpContext.Current.Session["EGN"].ToString(); Object.TeacherInfo teacher = new Object.TeacherInfo(); teacher.EGN = EGN; int classId = crud.GetTeacherClassId(teacher); if (classId == 0) { return(0); } else { return(classId); } }
public int GetTeacherClassId(Object.TeacherInfo teacher) { using (SqlConnection con = new SqlConnection(DataAccessLayer.SharedMethods.getConnectionString())) { SqlCommand cmd = new SqlCommand("spGetTeacherClassByCheckingEGN_tblTeacherInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("EGN", teacher.EGN); SqlParameter Result = new SqlParameter("@ClassId", DbType.Int32); Result.Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); con.Close(); return((int)Result.Value); } }