public OpCausesCollection GetOpCausesByNotificationID(string NotificationID) { OpCausesCollection causess = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); parameters.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.NotificationID.ActualFieldName, NotificationID)); base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpCauses.ActualTableName); DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table != null) { causess = new OpCausesCollection(); foreach (DataRow row in table.Rows) { OpCausesObj obj2 = new OpCausesObj(row[this.DataStructrure.Tables.OpCauses.InternalID.ActualFieldName].ToString()) { Notification = new OpNotificationObj(row[this.DataStructrure.Tables.OpCauses.NotificationID.ActualFieldName].ToString()), Cause = new MasterCauseObj(row[this.DataStructrure.Tables.OpCauses.CauseCode.ActualFieldName].ToString(), row[this.DataStructrure.Tables.OpCauses.CauseDescription.ActualFieldName].ToString(), new CauseGroupObj(row[this.DataStructrure.Tables.OpCauses.CauseGroup.ActualFieldName].ToString())), Order = Convert.ToInt32(row[this.DataStructrure.Tables.OpCauses.CauseOrder.ActualFieldName].ToString()), OpSys = Convert.ToInt32(row[this.DataStructrure.Tables.OpCauses.OpSys.ActualFieldName].ToString()), Description = row[this.DataStructrure.Tables.OpCauses.CauseDescription.ActualFieldName].ToString() }; causess.Add(obj2); } return(causess); } base.error_occured = true; base.ErrMsg = "[OpCausesManager] : GetOpCauses : " + base.CurDBEngine.ErrorMessage; return(causess); } base.error_occured = true; base.ErrMsg = "[OpCausesManager] : GetOpCauses : " + base.ErrMsg; return(causess); }
public bool UpdateOpCauses(OpCausesObj CurCausesObj) { bool flag = false; if (this.TryConnection()) { DatabaseParameters values = new DatabaseParameters(); DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.InternalID.ActualFieldName, CurCausesObj.InternalID)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseCode.ActualFieldName, CurCausesObj.Cause.InternalID.ToString())); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseDescription.ActualFieldName, CurCausesObj.Description.Replace("'", "''"), true, true)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseGroup.ActualFieldName, CurCausesObj.Cause.Code.InternalID.ToString())); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseOrder.ActualFieldName, CurCausesObj.Order.ToString())); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.NotificationID.ActualFieldName, CurCausesObj.Notification.InternalID.ToString())); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.OpSys.ActualFieldName, CurCausesObj.OpSys.ToString())); base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.OpCauses.ActualTableName); if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL))) { base.error_occured = true; string errMsg = base.ErrMsg; base.ErrMsg = errMsg + "[OpCausesManager] : UpdateOpCauses : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage; } return(flag); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpCausesManager] : UpdateOpCauses : " + base.ErrMsg; return(flag); }
public string CreateOpCausesSQL(OpCausesObj CurCausesObj) { if (this.TryConnection()) { DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.InternalID.ActualFieldName, CurCausesObj.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseCode.ActualFieldName, CurCausesObj.Cause.InternalID.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseDescription.ActualFieldName, CurCausesObj.Description.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseGroup.ActualFieldName, CurCausesObj.Cause.Code.InternalID.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.CauseOrder.ActualFieldName, CurCausesObj.Order.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.NotificationID.ActualFieldName, CurCausesObj.Notification.InternalID.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCauses.OpSys.ActualFieldName, CurCausesObj.OpSys.ToString())); base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpCauses.ActualTableName); return(base.CurSQLFactory.SQL); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpCausesManager] : CreateOpCauses : " + base.ErrMsg; return(""); }