public List <GradeEntities> GetAllGrade()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetGradeAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
List <GradeEntities> gradeList = new List <GradeEntities>();
GradeEntities garde = new GradeEntities();
foreach (DataRow dr in ds.Tables[0].Rows)
{
gradeList.Add(new GradeEntities
{
ID = Convert.ToInt32(dr["ID"].ToString()),
Grade = Convert.ToString(dr["Grade"].ToString()),
GradeGroupID = Convert.ToInt32(dr["GradeGroupID"].ToString()),
GradeGroup = Convert.ToString(dr["GradeGroup"]),
});
}
con.Close();
return(gradeList);
}
public ActionResult SaveOrUpdate(GradeEntities gradeentities)
{
GradeBL gradebl = new GradeBL();
int recordAffected = gradebl.SaveOrUpdateGrade(gradeentities);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
public GradeEntities GetGradeByID(int GradeID)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetGradeByGradeID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", GradeID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
GradeEntities grade = new GradeEntities();
grade.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
grade.Grade = Convert.ToString(ds.Tables[0].Rows[0]["Grade"]);
grade.GradeGroupID = Convert.ToInt32(ds.Tables[0].Rows[0]["GradeGroupID"].ToString());
return(grade);
}
public int SaveOrUpdateGrade(GradeEntities grade)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdateGrade", con);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(grade.ID.ToString()) || (grade.ID == 0))
{
cmd.Parameters.AddWithValue("@ID", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ID", grade.ID);
}
cmd.Parameters.AddWithValue("@Grade", grade.Grade);
cmd.Parameters.AddWithValue("@GradeGroupID", grade.GradeGroupID);
int recordAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordAffected);
}
//for ItemMaster drp
public void GetAllGradeForDrp()
{
StudentAttendentBL studentAttendentBL = new StudentAttendentBL();
List <GradeEntities> pocoList = new List <GradeEntities>();
pocoList = studentAttendentBL.GetAllGradeForDrp();
List <GradeEntities> itmasterList = new List <GradeEntities>();
foreach (GradeEntities up in pocoList)
{
GradeEntities unt = new GradeEntities();
unt.ID = up.ID;
unt.Grade = up.Grade;
itmasterList.Add(unt);
}
ViewBag.StudentAttendentMaster = itmasterList.Select(x =>
new SelectListItem()
{
Text = x.Grade,
Value = x.ID.ToString()
});
}
public int SaveOrUpdateGrade(GradeEntities grade)
{
GradeDAL gradeDl = new GradeDAL();
return(gradeDl.SaveOrUpdateGrade(grade));
}
