public virtual int UpdateObject(BusinessObject obj) { VinaDbUtil vinaDbUtil = new VinaDbUtil(); DateTime currentServerDate = vinaDbUtil.GetCurrentServerDate(); vinaDbUtil.SetPropertyValue(obj, "AAUpdatedDate", (object)currentServerDate); return(this.dal.UpdateObject((object)obj)); }
public virtual int CreateObject(BusinessObject obj) { VinaDbUtil vinaDbUtil = new VinaDbUtil(); DateTime currentServerDate = vinaDbUtil.GetCurrentServerDate(); vinaDbUtil.SetPropertyValue(obj, "AACreatedDate", (object)currentServerDate); int iObjectID = this.dal.CreateObject((object)obj); this.dal.SetValueToPrimaryColumn((object)obj, iObjectID); return(iObjectID); }
public virtual DataSet GetObjectsByIDForDataLookup(string[] arrColumns, int iObjectID) { string str = "Select "; string tablePrimaryColumn = new VinaDbUtil().GetTablePrimaryColumn(this.dal.TableName); foreach (string arrColumn in arrColumns) { str += string.Format("[{0}],", (object)arrColumn); } return(SqlDatabaseHelper.RunQuery(SqlDatabaseHelper.GetQuery(str.Remove(str.Length - 1, 1) + string.Format(" FROM [{0}] WHERE [{1}]={2} AND [AAStatus]='Alive'", (object)this.dal.TableName, (object)tablePrimaryColumn, (object)iObjectID)))); }
public static void CopyObject(BusinessObject objFromObjectsInfo, BusinessObject objToObjectsInfo) { VinaDbUtil dbUtil = new VinaDbUtil(); String strToObjectTableName = VinaUtil.GetTableNameFromBusinessObject(objToObjectsInfo); String strFromObjectTableName = VinaUtil.GetTableNameFromBusinessObject(objFromObjectsInfo); if (objFromObjectsInfo.GetType().Name.Contains("ForView")) { strFromObjectTableName = objFromObjectsInfo.GetType().Name.Replace("ForView", ""); } PropertyInfo[] properties = objToObjectsInfo.GetType().GetProperties(); string toObjectTablePrimaryKey = dbUtil.GetTablePrimaryColumn(strToObjectTableName); foreach (PropertyInfo prop in properties) { if (prop.Name != toObjectTablePrimaryKey && prop.Name != "IsTransferred" && !prop.Name.Contains("TransferredDate")) { String strFromObjectPropertyName = string.Empty; if (prop.Name.StartsWith(strToObjectTableName.Substring(0, strToObjectTableName.Length - 1))) { strFromObjectPropertyName = strFromObjectTableName.Substring(0, strFromObjectTableName.Length - 1) + prop.Name.Substring(strToObjectTableName.Length - 1); } PropertyInfo propFromObjectProperty = objFromObjectsInfo.GetType().GetProperty(strFromObjectPropertyName); if (propFromObjectProperty != null) { object objValue = propFromObjectProperty.GetValue(objFromObjectsInfo, null); prop.SetValue(objToObjectsInfo, objValue, null); } else { strFromObjectPropertyName = strFromObjectTableName.Substring(0, 2) + prop.Name.Substring(2); propFromObjectProperty = objFromObjectsInfo.GetType().GetProperty(strFromObjectPropertyName); if (propFromObjectProperty != null) { object objValue = propFromObjectProperty.GetValue(objFromObjectsInfo, null); prop.SetValue(objToObjectsInfo, objValue, null); } else { propFromObjectProperty = objFromObjectsInfo.GetType().GetProperty(prop.Name); if (propFromObjectProperty != null) { object objValue = propFromObjectProperty.GetValue(objFromObjectsInfo, null); prop.SetValue(objToObjectsInfo, objValue, null); } } } } } }