public object CreateClass([FromBody] ClassParameter obj)
{
if (obj.UserId == null && obj.Password == null)
{
return(new Result {
IsSucess = false, ResultData = "UserId Requird"
});
}
GRContext db = new GRContext();
tbl_class objcls = new tbl_class();
var result = db.tbl_class.FirstOrDefault(r => r.class_name == obj.ClassName && r.course_name == obj.CourseName);
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowd"
});
}
objcls.class_name = obj.ClassName.ToString();
objcls.course_name = obj.CourseName.ToString();
objcls.Display = 1;
objcls.created_date = DateTime.Now;
db.tbl_class.Add(objcls);
db.SaveChanges();
return(new Result
{
IsSucess = true,
ResultData = "Class Created!"
});
}
static void class_test()
{
#region get all calss
//List<tbl_class> c = obj_Class.get_all();
//foreach (tbl_class single in c)
//{
// Console.WriteLine(single.cl_Name);
//}
#endregion
#region add class
//tbl_class cc = new tbl_class();
//cc.cl_Name = "6班";
//cc.cl_ID = "0006";
//obj_Class.add(cc);
//Console.WriteLine("add success");
#endregion
#region delete class
tbl_class cc = new tbl_class();
cc.cl_Name = "6班";
cc.cl_ID = "0006";
obj_Class.delete(cc);
Console.WriteLine("delete success");
#endregion
#region update class data
//List<tbl_class> ccc = obj_Class.get_all();
//ccc[2].cl_Name = "班级修改";
//obj_Class.update(ccc[2]);
#endregion
}
public ActionResult DeleteConfirmed(int id)
{
tbl_class tbl_class = db.tbl_class.Find(id);
db.tbl_class.Remove(tbl_class);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "class_id,class_name")] tbl_class tbl_class)
{
if (ModelState.IsValid)
{
db.Entry(tbl_class).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_class));
}
public ActionResult Create([Bind(Include = "class_id,class_name")] tbl_class tbl_class)
{
if (ModelState.IsValid)
{
db.tbl_class.Add(tbl_class);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_class));
}
// GET: class/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_class tbl_class = db.tbl_class.Find(id);
if (tbl_class == null)
{
return(HttpNotFound());
}
return(View(tbl_class));
}
private void btn_submit_Click_1(object sender, RoutedEventArgs e)
{
tbl_class cc = new tbl_class();
cc.cl_ID = tb_id.Text;
cc.cl_Name = tb_class_name.Text;
Err ee = obj_Class.add(cc);
if (ee.res == false)
{
ModernDialog.ShowMessage(ee.info, "Input Error", MessageBoxButton.OK);
}
else
{
ModernDialog.ShowMessage(ee.info, "op success", MessageBoxButton.OK);
}
}
/// <summary>
/// add a class object to database
/// </summary>
/// <param name="objclass">input class object</param>
/// <returns>error information</returns>
public static Err add(tbl_class objclass)
{
Err e = new Err();
try
{
var db = new DataBase();
db.tbl_class.AddObject(objclass);
db.SaveChanges();
return(e);
}
catch (Exception ex)
{
e.res = false;
e.info = ex.Message;
return(e);
}
}
/// <summary>
/// delete a class
/// </summary>
/// <param name="objclass">insert a class</param>
/// <returns>error information</returns>
public static Err delete(tbl_class objclass)
{
Err e = new Err();
try
{
var db = new DataBase();
tbl_class before = (from d in db.tbl_class
where d.cl_ID == objclass.cl_ID
select d).Single();
db.DeleteObject(before);
db.SaveChanges();
}
catch (Exception ex)
{
e.res = false;
e.info = ex.Message;
}
return(e);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
ObservableCollection <ui_Class> custdata;
custdata = (ObservableCollection <ui_Class>)dg_class.DataContext;
int i = 0;
foreach (ui_Class uu in custdata)
{
if (uu.Update == true)
{
tbl_class cccc = obj_Class.get_single_class(tablebefore[i].ID);
cccc.cl_ID = uu.ID;
cccc.cl_Name = uu.Name;
Err eeee = obj_Class.update(cccc);
}
if (uu.Delete == true)
{
obj_Class.delete(obj_Class.get_single_class(uu.ID));
}
i++;
}
loadtable();
}