public bool IsExistRecord(object KeyObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { DepartmentMaster_dpm dpm = new DepartmentMaster_dpm(); try { dpm = Common.General.CopyObjectValue <object, DepartmentMaster_dpm>(KeyObject); IQueryable <DepartmentMaster_dpm> taQuery = (from dpms in db.DepartmentMaster_dpms where dpms.dpm_cNumber == dpm.dpm_cNumber select dpms); if (taQuery.Count() > 0) { return(true); } else { return(false); } } catch (Exception Ex) { throw Ex; } } }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Model.SysMaster.DepartmentMaster_dpm_Info info = null; try { info = KeyObject as Model.SysMaster.DepartmentMaster_dpm_Info; using (VPMSDBDataContext db = new VPMSDBDataContext()) { DepartmentMaster_dpm dpm = db.DepartmentMaster_dpms.Single <DepartmentMaster_dpm>(i => i.dpm_iRecordID == info.dpm_iRecordID); db.DepartmentMaster_dpms.DeleteOnSubmit(dpm); db.SubmitChanges(); return(true); } } catch (Exception Ex) { throw Ex; } }
public bool InsertRecord(Model.SysMaster.DepartmentMaster_dpm_Info infoObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { DepartmentMaster_dpm dpm = new DepartmentMaster_dpm(); try { dpm = Common.General.CopyObjectValue <model.DepartmentMaster_dpm_Info, DepartmentMaster_dpm>(infoObject); db.DepartmentMaster_dpms.InsertOnSubmit(dpm); db.SubmitChanges(); return(true); } catch (Exception Ex) { throw Ex; } } }