public OpDamagesCollection GetOpDamagesByNotificationID(string NotificationID)
{
OpDamagesCollection damagess = null;
if (this.TryConnection())
{
DatabaseParameters parameters = new DatabaseParameters();
parameters.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.NotificationID.ActualFieldName, NotificationID));
base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpDamages.ActualTableName);
DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL);
if (table != null)
{
damagess = new OpDamagesCollection();
foreach (DataRow row in table.Rows)
{
OpDamagesObj obj2 = new OpDamagesObj(row[this.DataStructrure.Tables.OpDamages.InternalID.ActualFieldName].ToString())
{
Notification = new OpNotificationObj(row[this.DataStructrure.Tables.OpDamages.NotificationID.ActualFieldName].ToString()),
Damage = new MasterDamageObj(row[this.DataStructrure.Tables.OpDamages.DamageCode.ActualFieldName].ToString(), row[this.DataStructrure.Tables.OpDamages.DamageDescription.ActualFieldName].ToString(), new DamageGroupObj(row[this.DataStructrure.Tables.OpDamages.DamageGroup.ActualFieldName].ToString())),
Order = Convert.ToInt32(row[this.DataStructrure.Tables.OpDamages.DamageOrder.ActualFieldName].ToString()),
OpSys = Convert.ToInt32(row[this.DataStructrure.Tables.OpDamages.OpSys.ActualFieldName].ToString()),
Description = row[this.DataStructrure.Tables.OpDamages.DamageDescription.ActualFieldName].ToString()
};
damagess.Add(obj2);
}
return(damagess);
}
base.error_occured = true;
base.ErrMsg = "[OpDamagesManager] : GetOpDamagesByNotificationID : " + base.CurDBEngine.ErrorMessage;
return(damagess);
}
base.error_occured = true;
base.ErrMsg = "[OpDamagesManager] : GetOpDamagesByNotificationID : " + base.ErrMsg;
return(damagess);
}
public bool UpdateOpDamages(OpDamagesObj CurDamageObj)
{
bool flag = false;
if (this.TryConnection())
{
DatabaseParameters values = new DatabaseParameters();
DatabaseParameters keys = new DatabaseParameters();
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.InternalID.ActualFieldName, CurDamageObj.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageCode.ActualFieldName, CurDamageObj.Damage.InternalID.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageDescription.ActualFieldName, CurDamageObj.Description.Replace("'", "''"), true, true));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageGroup.ActualFieldName, CurDamageObj.Damage.Code.InternalID.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageOrder.ActualFieldName, CurDamageObj.Order.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.NotificationID.ActualFieldName, CurDamageObj.Notification.InternalID.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.OpSys.ActualFieldName, CurDamageObj.OpSys.ToString()));
base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.OpDamages.ActualTableName);
if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL)))
{
base.error_occured = true;
string errMsg = base.ErrMsg;
base.ErrMsg = errMsg + "[OpDamagesManager] : UpdateOpDamages : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage;
}
return(flag);
}
base.error_occured = true;
base.ErrMsg = base.ErrMsg + "[OpDamagesManager] : UpdateOpDamages : " + base.ErrMsg;
return(flag);
}
public string CreateOpDamagesSQL(OpDamagesObj CurDamageObj)
{
if (this.TryConnection())
{
DatabaseParameters keys = new DatabaseParameters();
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.InternalID.ActualFieldName, CurDamageObj.InternalID));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageCode.ActualFieldName, CurDamageObj.Damage.InternalID.ToString()));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageDescription.ActualFieldName, CurDamageObj.Description.Replace("'", "''"), true, true));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageGroup.ActualFieldName, CurDamageObj.Damage.Code.InternalID.ToString()));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.DamageOrder.ActualFieldName, CurDamageObj.Order.ToString()));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.NotificationID.ActualFieldName, CurDamageObj.Notification.InternalID.ToString()));
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpDamages.OpSys.ActualFieldName, CurDamageObj.OpSys.ToString()));
base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpDamages.ActualTableName);
return(base.CurSQLFactory.SQL);
}
base.error_occured = true;
base.ErrMsg = base.ErrMsg + "[OpDamagesManager] : CreateOpDamages : " + base.ErrMsg;
return("");
}
