//for Grade drp
//public void GetGradeForDrp()
//{
// StudentParticularsBL studentParticularsBL = new StudentParticularsBL();
// List<StudentParticularsEntities> pocoList = new List<StudentParticularsEntities>();
// pocoList = studentParticularsBL.GetGradeForDrp();
// List<StudentParticularsEntities> itmasterList = new List<StudentParticularsEntities>();
// foreach (StudentParticularsEntities up in pocoList)
// {
// StudentParticularsEntities unt = new StudentParticularsEntities();
// unt.GradeID = up.GradeID;
// unt.Grade = up.Grade;
// itmasterList.Add(unt);
// }
// ViewBag.GradeForDrp = itmasterList.Select(x =>
// new SelectListItem()
// {
// Text = x.Grade,
// Value = x.GradeID.ToString()
// });
//}
public ActionResult DeleteSubject(int ID)
{
SubjectBL subjectBl = new SubjectBL();
int recordAffected = subjectBl.DeleteSubject(ID);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
private void BindSubjects()
{
//grdSubjects.DataSource = new DataTable();
grdSubjects.AutoGenerateColumns = false;
if (grdSubjects.Columns.Count == 0)
{
grdSubjects.ColumnCount = 9;
}
grdSubjects.Columns[0].HeaderText = "Id";
grdSubjects.Columns[0].DataPropertyName = "Id";
grdSubjects.Columns[0].Name = "Id";
grdSubjects.Columns[0].Visible = false;
grdSubjects.Columns[1].HeaderText = "Nombre";
grdSubjects.Columns[1].DataPropertyName = "Name";
grdSubjects.Columns[1].Name = "Name";
grdSubjects.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
grdSubjects.Columns[2].HeaderText = "Código";
grdSubjects.Columns[2].DataPropertyName = "Code";
grdSubjects.Columns[2].Name = "Code";
grdSubjects.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grdSubjects.Columns[3].HeaderText = "Creditos";
grdSubjects.Columns[3].DataPropertyName = "Credits";
grdSubjects.Columns[3].Name = "Credits";
grdSubjects.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grdSubjects.Columns[4].HeaderText = "Horas";
grdSubjects.Columns[4].DataPropertyName = "Hours";
grdSubjects.Columns[4].Name = "Hours";
grdSubjects.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grdSubjects.Columns[5].HeaderText = "Periodo";
grdSubjects.Columns[5].DataPropertyName = "PeriodValue";
grdSubjects.Columns[5].Name = "PeriodValue";
grdSubjects.Columns[5].Visible = false;
grdSubjects.Columns[6].HeaderText = "Periodo";
grdSubjects.Columns[6].DataPropertyName = "PeriodName";
grdSubjects.Columns[6].Name = "PeriodName";
grdSubjects.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
grdSubjects.Columns[7].HeaderText = "Estado";
grdSubjects.Columns[7].DataPropertyName = "StatusValue";
grdSubjects.Columns[7].Name = "StatusValue";
grdSubjects.Columns[7].Visible = false;
grdSubjects.Columns[8].HeaderText = "Estado";
grdSubjects.Columns[8].DataPropertyName = "StatusName";
grdSubjects.Columns[8].Name = "StatusName";
grdSubjects.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
grdSubjects.DataSource = SubjectBL.SubjectGetByStore(string.Empty, string.Empty, null, null, null, null);
}
private void btnSubjectSave_Click(object sender, EventArgs e)
{
if (!ValidateFields())
{
return;
}
Subject obj = new Subject();
obj.Code = txtSubjectCode.Text;
obj.Name = txtSubjectName.Text;
SubjectBL.InsertSubject(obj);
MessageBox.Show("Guardado exitoso", "", MessageBoxButtons.OK, MessageBoxIcon.None);
ClearFields();
}
private void btnSubjectSave_Click(object sender, EventArgs e)
{
if (!ValidateFields())
{
return;
}
Subject obj = new Subject();
obj.Id = objId;
obj.Code = txtSubjectCode.Text;
obj.Name = txtSubjectName.Text;
obj.Credits = Convert.ToInt32(txtSubjectCredits.Text);
obj.Hours = Convert.ToInt32(txtSubjectHours.Text);
obj.Period = (SubjectPeriod)((ComboItem)(cmbSubjectPeriod.SelectedItem)).Id;
obj.Status = (SubjectStatus)((ComboItem)(cmbSubjectStatus.SelectedItem)).Id;
SubjectBL.SaveSubject(obj);
MessageBox.Show("Guardado exitoso", "", MessageBoxButtons.OK, MessageBoxIcon.None);
ClearFields();
BindSubjects();
}
private void btnDeleteSubject_Click(object sender, EventArgs e)
{
if (grdSubjects.SelectedRows.Count == 1)
{
string subject = grdSubjects.CurrentRow.Cells["Name"].Value.ToString();
if (MessageBox.Show("¿Desea eliminar la materia \"" + subject + "\"?", "Eliminar", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int id = Convert.ToInt32(grdSubjects.CurrentRow.Cells["Id"].Value.ToString());
SubjectBL.DeleteSubject(id);
BindSubjects();
}
else
{
return;
}
}
else
{
MessageBox.Show("Seleccione un registro", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public JsonResult LoadData()
{
int draw, start, length;
int pageIndex = 0;
if (null != Request.Form.GetValues("draw"))
{
draw = int.Parse(Request.Form.GetValues("draw").FirstOrDefault().ToString());
start = int.Parse(Request.Form.GetValues("start").FirstOrDefault().ToString());
length = int.Parse(Request.Form.GetValues("length").FirstOrDefault().ToString());
}
else
{
draw = 1;
start = 0;
length = 50;
}
if (start == 0)
{
pageIndex = 1;
}
else
{
pageIndex = (start / length) + 1;
}
SubjectBL subjectBL = new SubjectBL();
int totalrecords = 0;
List <SubjectEntities> subjectEntities = new List <SubjectEntities>();
subjectEntities = subjectBL.GetSubjectPageWise(pageIndex, ref totalrecords, length);
var data = subjectEntities;
return(Json(new { draw = draw, recordsFiltered = totalrecords, recordsTotal = totalrecords, data = data }, JsonRequestBehavior.AllowGet));
}
public SubjectsViewModelsController(SubjectBL subjectbl)
{
this.subjectbl = subjectbl;
}
public ActionResult GetSubjectByID(int ID)
{
SubjectBL subjectBL = new SubjectBL();
return(Json(subjectBL.GetSubjectByID(ID), JsonRequestBehavior.AllowGet));
}
public JsonResult Add(SubjectEntities subjectEntities)
{
SubjectBL subjectBL = new SubjectBL();
return(Json(subjectBL.SaveSubject(subjectEntities), JsonRequestBehavior.AllowGet));
}
