public void Create(int grade, char letter, int specializationId
, string teacherEGN, out string Message, out System.Drawing.Color Color)
{
Object.Class Class = new Object.Class();
Class.Grade = grade;
Class.Letter = letter;
Class.SpecializationId = specializationId;
DataTable table = new DataTable();
table.Columns.Add("Grade");
table.Columns.Add("Letter");
table.Columns.Add("SpecializationId");
table.Columns.Add("ClassTeacherEGN");
if (teacherEGN.Length == 10)
{
Class.ClassTeacherEGN = teacherEGN;
int resultNum = crud.Create(Class);
message.Create(resultNum, out Message, out Color);
}
else if (grade < 1 || grade > 12)
{
message.Create(-5, out Message, out Color);
}
else
{
message.Create(-3, out Message, out Color);
}
}
public void Delete(int Id, out string Message, out System.Drawing.Color Color)
{
Object.Class Class = new Object.Class();
Class.Id = Id;
int ResultNumber = crud.Delete(Class);
message.Delete(ResultNumber, out Message, out Color);
}
public int Delete(Object.Class Class)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("Delete From tblClass Where Id = @Id",con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Id", Class.Id);
con.Open();
return (int)cmd.ExecuteNonQuery();
}
}
public int Create(Object.Class Class)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("spAddClass_tblClass", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ClassGrade", Class.Grade);
cmd.Parameters.AddWithValue("@ClassLetter", Class.Letter);
cmd.Parameters.AddWithValue("@SpecializationId", Class.SpecializationId);
cmd.Parameters.AddWithValue("@ClassTeacherEGN", Class.ClassTeacherEGN);
SqlParameter Result = new SqlParameter("@ResultNumber", DbType.Int32);
Result.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Result);
con.Open();
cmd.ExecuteScalar();
con.Close();
return (int)Result.Value;
}
}
public void Update(int Id, int Grade, char Letter, int SpecializationId, string ClassTeacherEGN,
out string Message, out System.Drawing.Color Color)
{
if (Grade < 1 || Grade > 12)
{
message.Update(-3, out Message, out Color);
}
else if (Letter < 'А' || Letter > 'Я'){
message.Update(-4, out Message, out Color);
}
else
{
Object.Class Class = new Object.Class();
Class.Id = Id;
Class.Grade = Grade;
Class.Letter = Letter;
Class.SpecializationId = SpecializationId;
Class.ClassTeacherEGN = ClassTeacherEGN;
int resultNumber = crud.Update(Class);
message.Update(resultNumber, out Message, out Color);
}
}