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