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