public ActionResult SaveOrUpdate(SectionEntities sectionentities)
{
SectionBL sectionBl = new SectionBL();
int rowAffected = sectionBl.SaveOrUpdate(sectionentities);
return(Json(rowAffected, JsonRequestBehavior.AllowGet));
}
public SectionEntities GetSectionByID(int sectionID)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetSectionBySectionID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", sectionID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
SectionEntities section = new SectionEntities();
section.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
section.Section = Convert.ToString(ds.Tables[0].Rows[0]["Section"]);
section.GradeId = Convert.ToInt32(ds.Tables[0].Rows[0]["GradeId"].ToString());
// section.Grade= Convert.ToString(ds.Tables[0].Rows[0]["Grade"].ToString());
return(section);
}
public int SaveOrUpdate(SectionEntities section)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdateSection", con);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(section.ID.ToString()) || (section.ID == 0))
{
cmd.Parameters.AddWithValue("@ID", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ID", section.ID);
}
cmd.Parameters.AddWithValue("@GradeId", section.GradeId);
cmd.Parameters.AddWithValue("Section", section.Section);
int rowAffected = cmd.ExecuteNonQuery();
con.Close();
return(rowAffected);
}
public bool UpdateSection(int SectionId, SectionEntities SectionEntities)
{
throw new NotImplementedException();
}
public int CreateSection(SectionEntities SectionEntities)
{
throw new NotImplementedException();
}
public int SaveOrUpdate(SectionEntities section)
{
SectionDAL sectionDl = new SectionDAL();
return(sectionDl.SaveOrUpdate(section));
}
