IList <ALRD_SecurityFormEntity> IALRD_SecurityFormDao.GetAll(ALRD_SecurityFormEntity entity) { try { const string SP = "alrd_securityform_GetAll"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddSortExpressionParameter(cmd, entity.SortExpression); FillParameters(entity, cmd, Database); IList <ALRD_SecurityFormEntity> itemList = new List <ALRD_SecurityFormEntity>(); using (IDataReader reader = Database.ExecuteReader(cmd)) { while (reader.Read()) { itemList.Add(new ALRD_SecurityFormEntity(reader)); } } return(itemList); } } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("GetAll")); } }
long IALRD_SecurityFormDao.Update(ALRD_SecurityFormEntity entity, bool isPertial = false) { long returnCode = -99; string SP; if (!isPertial) { SP = "alrd_securityform_Update"; } else { SP = "alrd_securityform_PertialUpdate"; } using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { FillParameters(entity, cmd, Database); //FillSequrityParameters(securityCapsule, cmd, OparationType.Update, Database); AddOutputParameter(cmd); try { returnCode = Database.ExecuteNonQuery(cmd); } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("Update")); } } return(returnCode); }
public static void FillParameters(ALRD_SecurityFormEntity entity, DbCommand cmd, Database Database, bool forDelete = false) { if (entity.COMPID.HasValue) { Database.AddInParameter(cmd, "@COMPID", DbType.Int64, entity.COMPID); } if (forDelete) { return; } if (entity.MenuID.HasValue) { Database.AddInParameter(cmd, "@MenuID", DbType.Int64, entity.MenuID); } if (!(string.IsNullOrEmpty(entity.FormName))) { Database.AddInParameter(cmd, "@FormName", DbType.String, entity.FormName); } if (!(string.IsNullOrEmpty(entity.FormType))) { Database.AddInParameter(cmd, "@FormType", DbType.String, entity.FormType); } if (!(string.IsNullOrEmpty(entity.FormCaption))) { Database.AddInParameter(cmd, "@FormCaption", DbType.String, entity.FormCaption); } if (entity.CreatedBy.HasValue) { Database.AddInParameter(cmd, "@CreatedBy", DbType.Int64, entity.CreatedBy); } if (entity.CreatedOn.HasValue) { Database.AddInParameter(cmd, "@CreatedOn", DbType.DateTime, entity.CreatedOn); } if (entity.UpdatedBy.HasValue) { Database.AddInParameter(cmd, "@UpdatedBy", DbType.Int64, entity.UpdatedBy); } if (entity.UpdatedOn.HasValue) { Database.AddInParameter(cmd, "@UpdatedOn", DbType.DateTime, entity.UpdatedOn); } }
long IALRD_SecurityFormDao.Delete(ALRD_SecurityFormEntity entity) { long returnCode = -99; const string SP = "alrd_securityform_Delete"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { FillParameters(entity, cmd, Database, true); //FillSequrityParameters(securityCapsule, cmd, OparationType.Update, Database); AddOutputParameter(cmd); try { returnCode = Database.ExecuteNonQuery(cmd);//Convert.ToInt64(cmd.Parameters["@RETURN_KEY"].Value); } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("Delete")); } } return(returnCode); }
long IALRD_SecurityFormDao.Add(ALRD_SecurityFormEntity entity) { long returnCode = -99; const string SP = "alrd_securityform_Insert"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { FillParameters(entity, cmd, Database); //FillSequrityParameters(securityCapsule, cmd, OparationType.Save, Database); AddOutputParameter(cmd); try { returnCode = Database.ExecuteNonQuery(cmd); // GetReturnCodeFromParameter(cmd); } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("Add")); } } return(returnCode); }