public bool UpdateRecord(Model.Management.Master.BuildingMaster_bdm_Info infoObject)
{
BuildingMaster_bdm tab = new BuildingMaster_bdm();
bool isSuccess = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
tab = db.BuildingMaster_bdms.SingleOrDefault(t => t.bdm_cNumber == infoObject.bdm_cNumber);
if (tab != null)
{
tab.bdm_cName = infoObject.bdm_cName;
tab.bdm_cRemark = infoObject.bdm_cRemark;
tab.bdm_cLast = infoObject.bdm_cLast;
tab.bdm_dLastDate = (infoObject.bdm_dLastDate != null?infoObject.bdm_dLastDate.Value:DateTime.Now);
}
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public bool IsExistRecord(object KeyObject)
{
BuildingMaster_bdm info = null;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
info = db.BuildingMaster_bdms.SingleOrDefault(t => t.bdm_cNumber == KeyObject.ToString().Trim());
if (info != null)
{
return(true);
}
}
return(false);
}
public bool InsertRecord(Model.Management.Master.BuildingMaster_bdm_Info infoObject)
{
BuildingMaster_bdm tab = null;
bool isSuccess = false;
tab = Common.General.CopyObjectValue <BuildingMaster_bdm_Info, BuildingMaster_bdm>(infoObject);
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
db.BuildingMaster_bdms.InsertOnSubmit(tab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public Model.Management.Master.BuildingMaster_bdm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
model.BuildingMaster_bdm_Info info = null;
BuildingMaster_bdm tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
info = new model.BuildingMaster_bdm_Info();
tab = db.BuildingMaster_bdms.SingleOrDefault(t => t.bdm_iRecordID == (KeyObject as BuildingMaster_bdm_Info).bdm_iRecordID);
}
}
catch (Exception Ex)
{
throw Ex;
}
if (tab != null)
{
info = Common.General.CopyObjectValue <BuildingMaster_bdm, BuildingMaster_bdm_Info>(tab);
}
return(info);
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool Btab = false;
BuildingMaster_bdm tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
tab = db.BuildingMaster_bdms.SingleOrDefault(t => t.bdm_iRecordID == KeyObject.RecordID);
if (tab != null)
{
db.BuildingMaster_bdms.DeleteOnSubmit(tab);
db.SubmitChanges();
Btab = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(Btab);
}