public bool UpdateRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject) { SchoolMaster_scm tab = new SchoolMaster_scm(); bool isSuccess = false; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { tab = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_cNumber == infoObject.scm_cNumber); if (tab != null) { tab.scm_cName = infoObject.scm_cName; tab.scm_cRemark = infoObject.scm_cRemark; tab.scm_cLast = infoObject.scm_cLast; tab.scm_dLastDate = infoObject.scm_dLastDate; //tab=Common.General.SetDataToLingQEntity(tab, infoObject); } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return(isSuccess); }
public bool IsExistRecord(object KeyObject) { SchoolMaster_scm info = null; using (VPMSDBDataContext db = new VPMSDBDataContext()) { info = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_cNumber == KeyObject.ToString().Trim()); if (info != null) { return(true); } } return(false); }
public bool InsertRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject) { SchoolMaster_scm tab = null; bool isSuccess = false; tab = Common.General.CopyObjectValue <SchoolMaster_scm_Info, SchoolMaster_scm>(infoObject); try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { db.SchoolMaster_scm.InsertOnSubmit(tab); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return(isSuccess); }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; SchoolMaster_scm tab = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { tab = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_iRecordID == KeyObject.RecordID); if (tab != null) { db.SchoolMaster_scm.DeleteOnSubmit(tab); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return(isSuccess); }
public Model.Management.Master.SchoolMaster_scm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { model.SchoolMaster_scm_Info info = null; SchoolMaster_scm tab = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { info = new model.SchoolMaster_scm_Info(); tab = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_iRecordID == (KeyObject as SchoolMaster_scm_Info).RecordID); } } catch (Exception Ex) { throw Ex; } if (tab != null) { info = Common.General.CopyObjectValue <SchoolMaster_scm, SchoolMaster_scm_Info>(tab); } return(info); }