public bool UpdateRecord(Model.Management.Master.SiteMaster_stm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
SiteMaster_stm stm = new SiteMaster_stm();
try
{
stm = db.SiteMaster_stms.SingleOrDefault(t => t.stm_iRecordID == infoObject.stm_iRecordID);
if (stm != null)
{
stm.stm_cBuildingNumber = infoObject.stm_cBuildingNumber;
stm.stm_cName = infoObject.stm_cName;
stm.stm_cNumber = infoObject.stm_cNumber;
stm.stm_cRemark = infoObject.stm_cRemark;
stm.stm_cLast = infoObject.stm_cLast;
stm.stm_dLastDate = infoObject.stm_dLastDate.Value;
db.SubmitChanges();
}
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
SiteMaster_stm_Info info = null;
try
{
info = KeyObject as SiteMaster_stm_Info;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
SiteMaster_stm stm = db.SiteMaster_stms.Single <SiteMaster_stm>(i => i.stm_iRecordID == info.stm_iRecordID);
db.SiteMaster_stms.DeleteOnSubmit(stm);
db.SubmitChanges();
return(true);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public bool InsertRecord(Model.Management.Master.SiteMaster_stm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
SiteMaster_stm stm = new SiteMaster_stm();
try
{
stm = Common.General.CopyObjectValue <Model.Management.Master.SiteMaster_stm_Info, SiteMaster_stm>(infoObject);
db.SiteMaster_stms.InsertOnSubmit(stm);
db.SubmitChanges();
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
