public int SaveSubject(SubjectEntities subjectEntities) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpInsertUpdatetblSubject", con); cmd.CommandType = CommandType.StoredProcedure; if (String.IsNullOrEmpty(subjectEntities.ID.ToString()) || (subjectEntities.ID == 0)) { cmd.Parameters.AddWithValue("@Id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Id", subjectEntities.ID); } cmd.Parameters.AddWithValue("@SubjectName", subjectEntities.SubjectName); //cmd.Parameters.AddWithValue("@GradeID", subjectEntities.GradeID); int recordsAffected = cmd.ExecuteNonQuery(); con.Close(); return(recordsAffected); }
public JsonResult Add(SubjectEntities subjectEntities) { //SubjectEntities x = new SubjectEntities(); //x = JsonConvert.DeserializeObject<SubjectEntities>(subjectEntities); Subject2BL subjectBL = new Subject2BL(); return(Json(subjectBL.SaveSubject(subjectEntities), JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { Database.SetInitializer(new DataInitializer()); SubjectEntities context = new SubjectEntities(); foreach (var human in context.Humans) { Console.WriteLine(human.ToString()); } Console.ReadLine(); }
public SubjectEntities GetSubjectByID(int ID) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpGettblSubjectByID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", ID); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); SubjectEntities subjectEntities = new SubjectEntities(); subjectEntities.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString()); subjectEntities.SubjectName = Convert.ToString(ds.Tables[0].Rows[0]["SubjectName"]); //subjectEntities.GradeID = Convert.ToInt32(ds.Tables[0].Rows[0]["GradeID"]); return(subjectEntities); }
public int SaveSubject(SubjectEntities subjectEntities) { Subject2DAL subjectDAL = new Subject2DAL(); return(subjectDAL.SaveSubject(subjectEntities)); }
public JsonResult Add(SubjectEntities subjectEntities) { SubjectBL subjectBL = new SubjectBL(); return(Json(subjectBL.SaveSubject(subjectEntities), JsonRequestBehavior.AllowGet)); }