public Model.Management.Master.BuildingMaster_bdm_Info GetRecord_Last()
{
IQueryable <BuildingMaster_bdm> taQuery = null;
Model.Management.Master.BuildingMaster_bdm_Info tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
taQuery =
(from ta in db.BuildingMaster_bdms
orderby ta.bdm_iRecordID descending
select ta).Take(1);
foreach (BuildingMaster_bdm t in taQuery)
{
tab = Common.General.CopyObjectValue <BuildingMaster_bdm, Model.Management.Master.BuildingMaster_bdm_Info>(t);
break;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(tab);
}
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);
}
private bool InsertRecord(Model.Management.Master.BuildingMaster_bdm_Info infoObject)
{
bool tabB = _buildingMasterDA.IsExistRecord((infoObject as BuildingMaster_bdm_Info).bdm_cNumber);
if (!tabB)
{
return(_buildingMasterDA.InsertRecord(infoObject));
}
return(false);
}
public Model.Management.Master.BuildingMaster_bdm_Info GetRecord_Previous(Model.Base.DataBaseCommandInfo commandInfo)
{
string RecordID = null;
IQueryable <BuildingMaster_bdm> taQuery = null;
Model.Management.Master.BuildingMaster_bdm_Info tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
if (commandInfo.KeyInfoList != null)
{
//foreach (var t in commandInfo.KeyInfoList)
//{
// if (t.Key == "bdm_iRecordID")
// {
// RecordID = t.KeyValue.ToString();
// break;
// }
//}
RecordID = commandInfo.KeyInfoList[0].KeyValue.ToString();
taQuery =
(from ta in db.BuildingMaster_bdms
where ta.bdm_iRecordID < Convert.ToInt32(RecordID)
orderby ta.bdm_iRecordID descending
select ta).Take(1);
if (taQuery.Count() > 0)
{
foreach (BuildingMaster_bdm t in taQuery)
{
tab = Common.General.CopyObjectValue <BuildingMaster_bdm, BuildingMaster_bdm_Info>(t);
break;
}
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(tab);
}
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);
}
private bool UpdateRecord(Model.Management.Master.BuildingMaster_bdm_Info infoObject)
{
return(_buildingMasterDA.UpdateRecord(infoObject));
}
