public bool InsertViolation(RecordViolationDTO recordViolationDTO)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[CheckOut].[InsertViolation]";
cmd.Parameters.AddWithValue("@StudentCode", recordViolationDTO.StudentCode);
cmd.Parameters.AddWithValue("@FirstName", recordViolationDTO.FirstName);
cmd.Parameters.AddWithValue("@LastName", recordViolationDTO.LastName);
cmd.Parameters.AddWithValue("@NationalCode", recordViolationDTO.NationalCode);
cmd.Parameters.AddWithValue("@Description", recordViolationDTO.Description);
cmd.Parameters.AddWithValue("@RegistrationDate", DateTime.Now);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return(true);
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(false);
}
}
public RecordViolationStudentInfo GetStudentInfo(RecordViolationDTO recordViolationDTO)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[CheckOut].[GetStudentInfo]";
cmd.Parameters.AddWithValue("@StudentCode", recordViolationDTO.StudentCode);
DataTable dt = new DataTable();
var res = new RecordViolationStudentInfo();
try
{
conn.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
dt.Load(rdr);
conn.Close();
//var row = dt.Rows[0];
foreach (DataRow row in dt.Rows)
{
res.Status = true;
res.FirstName = row["firstName"].ToString();
res.LastName = row["lastName"].ToString();
res.FatherName = row["fatherName"].ToString();
res.NationalCode = row["nationalCode"].ToString();
res.FieldName = row["fieldName"].ToString();
res.DepartmentName = row["departmentName"].ToString();
}
return(res);
}
catch (Exception)
{
throw;
}
}
public RecordViolationStudentInfo GetStudentInfo(RecordViolationDTO recordViolationDTO)
{
return(_recordViolationDAO.GetStudentInfo(recordViolationDTO));
}
public bool InsertViolation(RecordViolationDTO recordViolationDTO)
{
return(_recordViolationDAO.InsertViolation(recordViolationDTO));
}
public static RecordViolationStudentInfo GetStudentInfo(RecordViolationDTO recordViolationDTO)
{
return(_recordViolationBusiness.GetStudentInfo(recordViolationDTO));
}
public static bool InsertViolation(RecordViolationDTO recordViolationDTO)
{
return(_recordViolationBusiness.InsertViolation(recordViolationDTO));
}
