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