public bool Compare(T_Course value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Courses.Where(x => x.Active == value.Active && x.Course.ToLower() == value.Course.ToLower() && x.CourseCode.ToLower() == value.CourseCode.ToLower() && x.YearMinimum == value.YearMinimum && x.YearMaximum == value.YearMaximum && x.YearLevelFromTo == value.YearLevelFromTo).FirstOrDefault() == null ? true : false);
}
}
public async Task <ActionResult> Add(CourseViewModel model)
{
if (ModelState.IsValid)
{
var newModel = new T_Course
{
CourseID = Guid.NewGuid(),
Name = model.Name,
Code = model.Code,
CreateDate = DateTime.Now,
ModificationDate = DateTime.Now,
LogicalErasure = false
};
var courseDal = new Course_DAL();
var response = courseDal.Add(newModel);
if (response != null)
{
return(RedirectToAction("List"));
}
ModelState.AddModelError("", "Error al Crear El Curso");
}
return(View(model));
}
public void Delete(T_Course value, ref string msg)
{
T_Course valuedelete = new T_Course();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Courses.Where(x => x.ID == value.ID).FirstOrDefault();
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + "{2}" + Environment.NewLine + "{3}" + Environment.NewLine + "{4}" + Environment.NewLine + "{5}", SystemProperties.MessageNotification.Deleted, value.CourseCode, value.CourseCode, value.YearMinimum, value.YearMaximum, value.Active);
dc.T_Courses.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
private T_Course SetCourse()
{
T_Course valueRet = new T_Course();
valueRet.ID = isAdd ? 0 : Convert.ToInt64(dgCourseProgram.SelectedRows[0].Cells[0].Value.ToString());
valueRet.YearMinimum = Convert.ToInt32(cmbMin.Text);
valueRet.YearMaximum = Convert.ToInt32(cmbMax.Text);
valueRet.Course = txtCourse.Text;
valueRet.CourseCode = txtCode.Text;
valueRet.YearLevelFromTo = txtFromTo.Text;
valueRet.Description = txtDescription.Text;
valueRet.Active = cbActive.Checked;
return(valueRet);
}
public List <T_Course> ExecuteT_Course(int curIndex, int dataLength, string courseName, string className, string teachName)
{
string t_sql = "SelectT_ClassCourse";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@curIndex", SqlDbType.Int)
{
Value = curIndex
},
new SqlParameter("@dataLength", SqlDbType.Int)
{
Value = dataLength
},
new SqlParameter("@courseName", SqlDbType.VarChar)
{
Value = "%" + courseName + "%"
},
new SqlParameter("@className", SqlDbType.VarChar)
{
Value = "%" + className + "%"
},
new SqlParameter("@teachName", SqlDbType.VarChar)
{
Value = "%" + teachName + "%"
}
};
SqlHelper helper = new SqlHelper();
List <T_Course> res = null;
using (SqlDataReader reader = helper.ExecuteReader(t_sql, CommandType.StoredProcedure, pars)) {
if (reader.HasRows)
{
res = new List <T_Course>();
while (reader.Read())
{
//select s3.CourseID,s3.ClassID,s3.ClassName,s3.CourseName,s3.TeacherName
T_Course course = new T_Course();
course.CourseID = reader.GetInt32(0);
course.classID = reader.GetInt32(1);
course.ClassName = reader.GetString(2);
course.CourseName = reader.GetString(3);
course.teachID = reader.GetInt32(4);
course.TeachName = reader.GetString(5);
res.Add(course);
}
}
}
return(res);
}
public T_Course Add(T_Course course)
{
try
{
using (dataContext = new ApplicationDbContext())
{
dataContext.Set <T_Course>().Add(course);
dataContext.SaveChanges();
return(course);
}
}
catch (Exception ex)
{
//TODO: guardar en api log
}
return(null);
}
public void Save(T_Course value, ref string msg)
{
T_Course valueupdate = new T_Course();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//check data is already exist
if (Compare(value))
{
//is Save New
if (value.ID == 0)
{
dc.T_Courses.InsertOnSubmit(value);
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + "{2}" + Environment.NewLine + "{3}" + Environment.NewLine + "{4}" + Environment.NewLine + "{5}", SystemProperties.MessageNotification.Saved, value.CourseCode, value.CourseCode, value.YearMinimum, value.YearMaximum, value.Active);
}
// Is Update
else
{
valueupdate = dc.T_Courses.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.Course = value.Course;
valueupdate.CourseCode = value.CourseCode;
valueupdate.Description = value.Description;
valueupdate.YearMinimum = value.YearMinimum;
valueupdate.YearMaximum = value.YearMaximum;
valueupdate.YearLevelFromTo = value.YearLevelFromTo;
valueupdate.Active = value.Active;
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + "{2}" + Environment.NewLine + "{3}" + Environment.NewLine + "{4}" + Environment.NewLine + "{5}", SystemProperties.MessageNotification.Updated, valueupdate.CourseCode, valueupdate.CourseCode, valueupdate.YearMinimum, valueupdate.YearMaximum, valueupdate.Active);
}
dc.SubmitChanges();
}
else
{
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + "{2}" + Environment.NewLine + "{3}" + Environment.NewLine + "{4}" + Environment.NewLine + "{5}", SystemProperties.MessageNotification.Exist, value.CourseCode, value.CourseCode, value.YearMinimum, value.YearMaximum, value.Active);
}
}
}
public FrmUpdateClassSetUpCourse(T_Course course) : this()
{
this.course = course;
}
