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