public Program()
{
m_service = new MockCrmService();
contact contact = new contact();
contact.address1_name = "Dan";
contact.address1_city = "Bethesda";
Guid id = m_service.Create(contact);
// data for testing links
subject subject1 = new subject();
subject1.title = "parent";
Guid subject1ID = m_service.Create(subject1);
subject subject2 = new subject();
subject2.title = "child";
subject2.parentsubject = new Lookup("subject", subject1ID);
m_service.Create(subject2);
DynamicEntity de = new DynamicEntity();
de.Name = "mydynamic";
de.Properties.Add(new StringProperty("prop1", "foo"));
Guid deID = m_service.Create(de);
}
public ActionResult CreateSubject([Bind(Exclude = "id")] subject subject)
{
bool status = false;
string message = "";
if ((string)Session["user"] != null)
{
if (ModelState.IsValid)
{
var subjectExistsAdmin = SubjectExistsAdmin(subject.subjectname, subject.classid);
if (subjectExistsAdmin)
{
//Debug.WriteLine(subjectExistsAdmin);
ModelState.AddModelError("subjectExistsAdmin", "One subject cannot be assigned multiple times");
//return View();
//message = "invalid";
return(RedirectToAction("ListSubject", "Admin"));
}
//Debug.WriteLine(subject);
data.subject.Add(subject);
data.SaveChanges();
return(RedirectToAction("ListSubject"));
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(subject));
}
return(RedirectToAction("Login", "User"));
}
private void checkNewSubject()
{
// check on a unique
List <subject> all = new List <subject>();
all.AddRange(db.subjects);
all = all.FindAll
(
delegate(subject s)
{ return(s.subject1.Equals(cbSubject.Text)); }
);
if (all.Count == 0)
{
// create a new address
subject s = new subject();
s.subject1 = cbSubject.Text;
subject saved = subjectCrud.create(s);
participantDTO.subject = saved.subjectId;
}
}
private void button2_Click(object sender, EventArgs e)
{
subject s = (subject)cbSubject.SelectedItem;
SubjectEditor editor = new SubjectEditor(db, s);
editor.Show();
}
public IHttpActionResult Putsubject(int id, subject subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != subject.Id)
{
return(BadRequest());
}
db.Entry(subject).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!subjectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private Expression <Func <member, bool> > GetDoctorIdExpBuilder(subject ent)
{
var exp = PredicateBuilder.True <member>();
if (ent.subject_titles != null && ent.subject_titles.Count > 0)
{
var titleIds = ent.subject_titles.Select(t => t.title_id).ToList();
exp = exp.And(m => titleIds.Contains(m.member_doctor_admintitle.title));
}
if (ent.subject_hospitals != null && ent.subject_hospitals.Count > 0)
{
var hospitalIds = ent.subject_hospitals.Select(h => h.hospital_id).ToList();
exp = exp.And(m => m.member_doctor_hospital.Any(dh => hospitalIds.Contains(dh.hospital_id)));
}
if (ent.subject_sections != null && ent.subject_sections.Count > 0)
{
var sectionIds = ent.subject_sections.Select(m => m.section_id).ToList();
exp = exp.And(m => m.member_doctor_hospital_section.Any(dhs => sectionIds.Contains(dhs.hospital_section_id)));
}
if (ent.subject_doctors != null && ent.subject_doctors.Count > 0)
{
var doctorIds = ent.subject_doctors.Select(d => d.doctor_id).ToList();
exp = exp.And(m => doctorIds.Contains(m.member_doctor_profile.doctor_id));
}
return(exp);
}
public async Task <IActionResult> Edit(int id, [Bind("id,name,date,time,price,place")] subject subject)
{
if (id != subject.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(subject);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!subjectExists(subject.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(subject));
}
public subjectDetail subjectsdetail(int studentcode)
{
List <subject> subjectlist = new List <subject>();
subjectDetail Details = new subjectDetail();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_api_selectValidSubjectList", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@studentcode", SqlDbType.Int).Value = studentcode;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var slist = new subject();
slist.subjectcode = Convert.ToInt32(rdr["code"]);
slist.subjectname = Convert.ToString(rdr["name"]);
subjectlist.Add(slist);
}
con.Close();
Details.subjectdetails = subjectlist;
}
}
return(Details);
}
public ActionResult CreatePost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int profesor_id = Int32.Parse(Request.Form["profesor_id"]);
quota q = new quota();
subject s = new subject();
s.id_subject = 1;
s.nombre_subject = Request.Form["nombre_subject"];
s.codigo_subject = Request.Form["codigo_subject"];
s.max_alumnos = Int32.Parse(Request.Form["max_alumnos"]);
s.descripcion = Request.Form["descripcion"];
s.hora_entrada = TimeSpan.Parse(Request.Form["hora_entrada"]);
s.hora_salida = TimeSpan.Parse(Request.Form["hora_salida"]);
db.subject.Add(s);
db.SaveChanges();
s = db.subject.Where(m => m.codigo_subject == s.codigo_subject).First();
q.profesor_id = profesor_id;
q.subject_id = s.id_subject;
q.periodo = DateTime.Now.Year.ToString();
db.quota.Add(q);
db.SaveChanges();
TempData["Message"] = "Create sucess!";
}
return(RedirectToAction("Index"));
}
public ActionResult EditPost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int id_subject = Int32.Parse(Request.Form["id_subject"]);
int id_quota = Int32.Parse(Request.Form["id_quota"]);
subject s = db.subject.Find(id_subject);
//var su = db.subject.Find(id);
int profesor_id = Int32.Parse(Request.Form["profesor_id"]);
quota q = db.quota.Where(m => m.id_quota == id_quota).First();
s.nombre_subject = Request.Form["nombre_subject"];
s.codigo_subject = Request.Form["codigo_subject"];
s.max_alumnos = Int32.Parse(Request.Form["max_alumnos"]);
s.descripcion = Request.Form["descripcion"];
s.hora_entrada = TimeSpan.Parse(Request.Form["hora_entrada"]);
s.hora_salida = TimeSpan.Parse(Request.Form["hora_salida"]);
q.profesor_id = profesor_id;
q.subject_id = s.id_subject;
q.periodo = DateTime.Now.Year.ToString();
db.Entry(s).State = System.Data.EntityState.Modified;
db.Entry(q).State = System.Data.EntityState.Modified;
db.SaveChanges();
TempData["Message"] = "Edit sucess!";
}
return(RedirectToAction("Index"));
}
public ActionResult addSubject(string nameSubject, int idTutor)
{
string nameSub = nameSubject.Trim();
try
{
if (nameSub != null)
{
var subnew = new subject();
subnew.subject_name = nameSubject;
subnew.tutor_id = idTutor;
db.subjects.Add(subnew);
db.SaveChanges();
setAlert("Thêm môn học thành công", "success");
return(RedirectToAction("InfoOfTutor"));
}
else
{
setAlert("Môn học không được để trống", "error");
return(RedirectToAction("InfoOfTutor"));
}
}
catch
{
setAlert("Môn học mới thêm đã bị trùng !", "error");
return(View("InfoOfTutor"));
}
}
public ActionResult Save(int?id, int school, string name)
{
var subject = new subject();
if (id.HasValue)
{
subject = repository.GetSchoolSubject(id.Value);
}
subject.name = name;
subject.schoolid = school;
if (!id.HasValue)
{
repository.AddSchoolSubject(subject);
}
try
{
repository.Save();
//HttpResponse.RemoveOutputCacheItem(Url.Action("list", new { id = school }));
}
catch (Exception ex)
{
Syslog.Write(ex);
}
return(Json("Entry saved successfully".ToJsonOKMessage()));
}
protected void btnadd_Click(object sender, EventArgs e)
{
using (DepartmentPortalDataContext db = new DepartmentPortalDataContext())
{
try
{
var q = from i in db.subjects
where i.subject_name == txtname.Text && i.course == branch
select i;
if (q.Any())
{
lbladderror.Text = "Subject already exists.";
return;
}
subject s = new subject()
{
subject_name = txtnewname.Text,
subject_description = txtnewdesc.Text,
subject_credit = Convert.ToDecimal(txtnewcredit.Text),
allotted_sem = Convert.ToInt32(txtnewsem.Text),
course = branch
};
db.subjects.InsertOnSubmit(s);
db.SubmitChanges();
lbladderror.Text = "Subject Added Successfully.";
Page_Load(sender, e);
}
catch (Exception ex) { }
}
}
/// <summary>
/// Converts to subject model.
/// </summary>
/// <param name="item">The item.</param>
/// <returns></returns>
internal static SubjectModel ConvertToSubjectModel(subject item)
{
return(new SubjectModel()
{
Id = item.Id,
Name = item.SubjectName
});
}
private void btnSubjects_Click(object sender, EventArgs e)
{
ActivateButton(sender);
subject su = new subject();
su.Show();
}
public SubjectEditor(DbAppContext db, subject subject)
{
this.db = db;
this.subject = subject;
this.crud = new SubjectCrud(db);
InitializeComponent();
}
public ActionResult Delete(int id)
{
subject sbjectToDelete = _db.subjects.Find(id);
_db.subjects.Remove(sbjectToDelete);
_db.SaveChanges();
return(RedirectToAction("SubjectView"));
}
public ActionResult DeleteConfirmed(int id)
{
subject subject = db.subject.Find(id);
db.subject.Remove(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteSubject(int id)
{
if ((string)Session["user"] != null)
{
subject s = data.subject.Where(a => a.subjectid == id).FirstOrDefault();
return(View(s));
}
return(RedirectToAction("Login", "User"));
}
public async Task <ActionResult> Details(int id = 0)
{
subject subject = await DB.subjects.FindAsync(id);
if (subject == null)
{
return(HttpNotFound());
}
return(PartialView(subject));
}
public async Task <ActionResult> Delete(int id)
{
subject subject = await DB.subjects.FindAsync(id);
DB.subjects.Remove(subject);
await DB.SaveChangesAsync();
TempData["Msg"] = "تمت عملية الحذف بنجاح";
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,SubjectName")] subject subject)
{
if (ModelState.IsValid)
{
db.Entry(subject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public IHttpActionResult Getsubject(int id)
{
subject subject = db.subjects.Find(id);
if (subject == null)
{
return(NotFound());
}
return(Ok(subject));
}
public async Task <IActionResult> Create([Bind("id,name,date,time,price,place")] subject subject)
{
if (ModelState.IsValid)
{
_context.Add(subject);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(subject));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
subject sb = (subject)Session["sb"];
string subjectnames = sb.Subject_name;
Session["classid"] = sb.Class_id;
Session["subjectid"] = sb.subjectid;
addsubject.Text = subjectnames;
}
}
public ActionResult Create([Bind(Include = "Id,SubjectName")] subject subject)
{
if (ModelState.IsValid)
{
db.subject.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public Subject(subject subject)
{
if (subject != null)
{
this.Id = subject.Id;
this.Name = subject.Name;
this.IsActive = subject.IsActive;
this.SubjectTypeId = subject.SubjectTypeId;
this.Code = subject.Code;
}
}
public ActionResult EditSubject(int id)
{
if ((string)Session["user"] != null)
{
subject s = data.subject.Where(a => a.subjectid == id).FirstOrDefault();
s.subjectid = id;
var classList = new SelectList([email protected](), "classid", "classname");
ViewData["ClassList"] = classList;
return(View(s));
}
return(RedirectToAction("Login", "User"));
}
public IHttpActionResult Postsubject(subject subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.subjects.Add(subject);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = subject.Id }, subject));
}
public ActionResult ConfirmDeleteSubject(int id)
{
if ((string)Session["user"] != null)
{
subject s = data.subject.Where(a => a.subjectid == id).FirstOrDefault();
data.subject.Remove(s);
data.SaveChanges();
return(RedirectToAction("ListSubject"));
}
return(RedirectToAction("Login", "User"));
}
public bool commitInsert(int _id, string _menu_name)
{
subjectDataContext objSubjectDC = new subjectDataContext();
//to ensure all data will be disposed when finished
using (objSubjectDC)
{
//create an instance of the table
subject objNewSubject = new subject();
//set table column to new values being passed from *.aspx subject
objNewSubject.id = _id;
objNewSubject.menu_name = _menu_name;
objSubjectDC.subjects.InsertOnSubmit(objNewSubject);
//commit insert against db
objSubjectDC.SubmitChanges();
return true;
}
}
public Program()
{
m_service = new MockCrmService();
contact contact = new contact();
contact.address1_name = "Dan";
contact.address1_city = "Bethesda";
Guid id = m_service.Create( contact );
// data for testing links
subject subject1 = new subject();
subject1.title = "parent";
Guid subject1ID = m_service.Create( subject1 );
subject subject2 = new subject();
subject2.title = "child";
subject2.parentsubject = new Lookup( "subject", subject1ID );
m_service.Create( subject2 );
DynamicEntity de = new DynamicEntity();
de.Name = "mydynamic";
de.Properties.Add( new StringProperty( "prop1", "foo" ) );
Guid deID = m_service.Create( de );
}
partial void Deletesubject(subject instance);
partial void Updatesubject(subject instance);
partial void Insertsubject(subject instance);
public bool isSubjectAdded( string name, string description )
{
if (!subjectExists( name )) {
try {
subject newSubject = new subject() {
name = name,
description = description
};
MOE_DB.subjects.InsertOnSubmit( newSubject );
MOE_DB.SubmitChanges();
return true;
}
catch (Exception ex) {
return false;
}//try catch
}
else
return false;
}
