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