private JObject addStudyPlan(Command value) { var studyPlanObj = JsonConvert.DeserializeObject <StudyPlan>(value.data.ToString()); var major = new faculty(); major.name = studyPlanObj.major; major.idfaculty = Guid.NewGuid().ToString().Substring(0, 32).Replace("-", ""); _db.insertFaculty(ref major); group group = new group(); group.idgroups = Guid.NewGuid().ToString().Replace("-", ""); group.name = studyPlanObj.major; group.idsemesters = null; group.idsupergroup = null; group.idfaculty = major.idfaculty; studyPlanObj.id = group.idgroups; _db.insertGroup(ref group); foreach (SubGroup it in studyPlanObj.semesters) { semester semester = new semester(); semester.idsemesters = Guid.NewGuid().ToString().Replace("-", ""); semester.name = it.name; _db.insertSemester(ref semester); addGroup(it, semester.idsemesters, group.idgroups, major.idfaculty); } return(JObject.Parse(JsonConvert.SerializeObject(studyPlanObj))); }
public ActionResult Semi(semester SemesterModel) { dbContex.semesters.Add(SemesterModel); dbContex.SaveChanges(); ModelState.Clear(); ViewBag.Success = "Successfully Added"; return(View("Semi", new semester())); }
public static int Add_Semester(semester s) { //string statement = $"insert into semester values('{s.Semester}','{s.SemesterFullName}','{s.SemesterArabicName}',{s.SemesterEnumID},{s.StatusID})"; string statement = $"insert into semester(Semester,SemesterFullName,SemesterArabicName,SemesterEnumID,StatusID) values ('{s.Semester}','{s.SemesterFullName}','{s.SemesterArabicName}',{s.SemesterEnumID},{s.StatusID})"; var affected = DBManager.ExecuteNonQuery(statement); return(affected); }
// POST: SemestersValues public IHttpActionResult Post(InsertSemester value) { using (universityEntities db = new universityEntities()) { semester semester = new semester(); semester.name = value.name; db.semesters.Add(semester); db.SaveChanges(); } return(Ok()); }
public ActionResult Create(semester sem) { ModelState.Remove("ID"); if (ModelState.IsValid) { semesterBL.Add_Semester(sem); return(RedirectToAction("Semester")); } else { return(View()); } }
public static semester GetById(int id) { string statement = $"select * from semester where ID={id}"; var ds = DBManager.ExecuteQuery(statement); var item = ds.Tables[0].Rows[0]; var Obj = new semester { ID = int.Parse(item["ID"].ToString()), Semester = item["Semester"].ToString(), SemesterFullName = (item["SemesterFullName"].ToString()), SemesterArabicName = (item["SemesterArabicName"].ToString()), SemesterEnumID = int.Parse(item["SemesterEnumID"].ToString()), StatusID = int.Parse(item["StatusID"].ToString()) }; return(Obj); }
public ActionResult Semi() { semester si = new semester(); return(View(si)); }