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