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