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