//for Catagory drp public void GetStudentForDrp() { StudentParticularsBL studentParticularsBL = new StudentParticularsBL(); List<StudentParticularsEntities> pocoList = new List<StudentParticularsEntities>(); pocoList = studentParticularsBL.GetStudentForDrp(); List<StudentParticularsEntities> itmasterList = new List<StudentParticularsEntities>(); foreach (StudentParticularsEntities up in pocoList) { StudentParticularsEntities unt = new StudentParticularsEntities(); unt.StudentID = up.StudentID; unt.StudentName = up.StudentName; itmasterList.Add(unt); } ViewBag.StudentParticulars = itmasterList.Select(x => new SelectListItem() { Text = x.StudentName, Value = x.StudentID.ToString() }); }
public StudentParticularsEntities GetStudentParticularsByID(int ID) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpGetStudentParticularsByID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", ID); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); StudentParticularsEntities studentParticularsEntities = new StudentParticularsEntities(); studentParticularsEntities.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString()); studentParticularsEntities.FirstName = Convert.ToString(ds.Tables[0].Rows[0]["FirstName"]); studentParticularsEntities.LastName = Convert.ToString(ds.Tables[0].Rows[0]["LastName"]); studentParticularsEntities.DOB = Convert.ToString(ds.Tables[0].Rows[0]["DOB"]); studentParticularsEntities.GradeID = Convert.ToInt32(ds.Tables[0].Rows[0]["GradeID"]); studentParticularsEntities.StartDate = Convert.ToString(ds.Tables[0].Rows[0]["StartDate"]); studentParticularsEntities.EndDate = Convert.ToString(ds.Tables[0].Rows[0]["EndDate"]); studentParticularsEntities.LeavingReason = Convert.ToString(ds.Tables[0].Rows[0]["LeavingReason"]); studentParticularsEntities.Gender = Convert.ToString(ds.Tables[0].Rows[0]["Gender"]); //studentParticularsEntities.GradeId = Convert.ToInt32(ds.Tables[0].Rows[0]["GradeId"].ToString()); return(studentParticularsEntities); }
public int SaveStudentParticulars(StudentParticularsEntities studentParticularsEntities) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpInsertUpdateStudentParticulars", con); cmd.CommandType = CommandType.StoredProcedure; if (String.IsNullOrEmpty(studentParticularsEntities.ID.ToString()) || (studentParticularsEntities.ID == 0)) { cmd.Parameters.AddWithValue("@ID", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ID", studentParticularsEntities.ID); } cmd.Parameters.AddWithValue("@FirstName", studentParticularsEntities.FirstName); if (!String.IsNullOrEmpty(studentParticularsEntities.LastName)) { cmd.Parameters.AddWithValue("@LastName", studentParticularsEntities.LastName); } else { cmd.Parameters.AddWithValue("@LastName", DBNull.Value); } if (!String.IsNullOrEmpty(studentParticularsEntities.DOB)) { cmd.Parameters.AddWithValue("@DOB", studentParticularsEntities.DOB); } else { cmd.Parameters.AddWithValue("@DOB", DBNull.Value); } cmd.Parameters.AddWithValue("@GradeID", studentParticularsEntities.GradeID); if (!String.IsNullOrEmpty(studentParticularsEntities.StartDate)) { cmd.Parameters.AddWithValue("@StartDate", studentParticularsEntities.StartDate); } else { cmd.Parameters.AddWithValue("@StartDate", DBNull.Value); } if (!String.IsNullOrEmpty(studentParticularsEntities.EndDate)) { cmd.Parameters.AddWithValue("@EndDate", studentParticularsEntities.EndDate); } else { cmd.Parameters.AddWithValue("@EndDate", DBNull.Value); } if (!String.IsNullOrEmpty(studentParticularsEntities.LeavingReason)) { cmd.Parameters.AddWithValue("@LeavingReason", studentParticularsEntities.LeavingReason); } else { cmd.Parameters.AddWithValue("@LeavingReason", DBNull.Value); } if (!String.IsNullOrEmpty(studentParticularsEntities.Gender)) { cmd.Parameters.AddWithValue("@Gender", studentParticularsEntities.Gender); } else { cmd.Parameters.AddWithValue("@Gender", DBNull.Value); } //if (studentParticularsEntities.ID > 0) //{ // cmd.Parameters.AddWithValue("@ID", studentParticularsEntities.ID); //} //else //{ // cmd.Parameters.AddWithValue("@ID", DBNull.Value); //} int recordsAffected = cmd.ExecuteNonQuery(); con.Close(); return(recordsAffected); }
public JsonResult Add(StudentParticularsEntities studentParticularsEntities) { StudentParticularsBL studentParticularsBL = new StudentParticularsBL(); return(Json(studentParticularsBL.SaveStudentParticulars(studentParticularsEntities), JsonRequestBehavior.AllowGet)); }
public int SaveStudentParticulars(StudentParticularsEntities studentParticularsEntities) { StudentParticularsDAL studentParticularsDAL = new StudentParticularsDAL(); return(studentParticularsDAL.SaveStudentParticulars(studentParticularsEntities)); }