public bool CreateOpSignature(OpSignatureObj CurOpSignature) { bool flag = false; if (this.TryConnection()) { DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.NotificationID.ActualFieldName, CurOpSignature.Notification.InternalID.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Signature.ActualFieldName, CurOpSignature.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Name.ActualFieldName, CurOpSignature.Name.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Contact.ActualFieldName, CurOpSignature.Contact.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Department.ActualFieldName, CurOpSignature.Department.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Designation.ActualFieldName, CurOpSignature.Designation.Replace("'", "''"), true, true)); base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpSignature.ActualTableName); if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL))) { base.error_occured = true; string errMsg = base.ErrMsg; base.ErrMsg = errMsg + "[OpSignatureManager] : CreateOpSignature : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage; } return(flag); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpSignatureManager] : CreateOpSignature : " + base.ErrMsg; return(flag); }
public OpSignatureCollection GetOpSignature() { OpSignatureCollection signatures = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpSignature.ActualTableName); DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table != null) { signatures = new OpSignatureCollection(); foreach (DataRow row in table.Rows) { OpSignatureObj obj2 = new OpSignatureObj(row[this.DataStructrure.Tables.OpSignature.Signature.ActualFieldName].ToString()) { Notification = new OpNotificationObj(row[this.DataStructrure.Tables.OpSignature.NotificationID.ActualFieldName].ToString()), Name = row[this.DataStructrure.Tables.OpSignature.Name.ActualFieldName].ToString(), Department = row[this.DataStructrure.Tables.OpSignature.Department.ActualFieldName].ToString(), Contact = row[this.DataStructrure.Tables.OpSignature.Contact.ActualFieldName].ToString(), Designation = row[this.DataStructrure.Tables.OpSignature.Designation.ActualFieldName].ToString() }; signatures.Add(obj2); } return(signatures); } base.error_occured = true; base.ErrMsg = "[OpSignatureManager] : GetOpSignature : " + base.CurDBEngine.ErrorMessage; return(signatures); } base.error_occured = true; base.ErrMsg = "[OpSignatureManager] : GetOpSignature : " + base.ErrMsg; return(signatures); }
public string CreateOpSignatureSQL(OpSignatureObj CurOpSignature) { if (this.TryConnection()) { DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.NotificationID.ActualFieldName, CurOpSignature.Notification.InternalID.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Signature.ActualFieldName, CurOpSignature.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Name.ActualFieldName, CurOpSignature.Name.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Contact.ActualFieldName, CurOpSignature.Contact.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Department.ActualFieldName, CurOpSignature.Department.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpSignature.Designation.ActualFieldName, CurOpSignature.Designation.Replace("'", "''"), true, true)); base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpSignature.ActualTableName); return(base.CurSQLFactory.SQL); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpSignatureManager] : CreateOpSignature : " + base.ErrMsg; return(""); }