/// <summary> /// Save a <see cref="FanWorkout" /> list passed as an argument. /// </summary> /// <param name="aFanKey">A <see cref="FanKey" /> object.</param> /// <param name="aFanWorkoutCollection">A cell fan collection.</param> /// <exception cref="Zephry.ZpAccessException">Access Denied; FanWorkout</exception> /// <exception cref="ArgumentNullException">If <c>aFanWorkout</c> argument is <c>null</c>.</exception> public static void Save(FanKey aFanKey, FanWorkoutCollection aFanWorkoutCollection) { if (aFanWorkoutCollection == null) { throw new ArgumentNullException("Update FanWorkoutCollection Business"); } //if (!FanFunctionAccessData.HasModeAccess(aFanKey, "FanWorkout", AccessMode.Update)) //{ // throw new ZpAccessException("Access Denied", String.Format("{0}", aFanKey.FannKey), AccessMode.Update, "FanWorkout"); //} //Set Dates of new fanworkouts DateTime x; foreach (FanWorkout aFw in aFanWorkoutCollection.FanWorkoutList) { if (!(DateTime.TryParse(aFw.FanWorkoutDateCreated, out x))) { aFw.FanWorkoutDateCreated = DateTime.Now.ToLongDateString();; } } FanWorkoutData.Save(aFanWorkoutCollection); }
/// <summary> /// Insert a <see cref="FanWorkout"/> passed as an argument via Stored Procedure that returns the newly inserted FanWorkout Key /// </summary> /// <param name="aFanWorkout">A <see cref="FanWorkout"/>.</param> /// <exception cref="ArgumentNullException">If <c>aFanWorkout</c> argument is <c>null</c>.</exception> public static void Insert(FanWorkoutCollection aFanWorkoutCollection) { if (aFanWorkoutCollection == null) { throw new ArgumentNullException("aFanWorkoutCollection"); } using (var vSqlCommand = new SqlCommand() { CommandType = CommandType.Text, Connection = new SqlConnection(Connection.Instance.SqlConnectionString) }) { var vStringBuilder = new StringBuilder(); vStringBuilder.AppendLine("insert into FAW_FanWorkout"); vStringBuilder.AppendLine(" (WRT_Key, FAN_Key,"); vStringBuilder.AppendLine(" FAW_DateCreated)"); vStringBuilder.AppendLine("values"); vStringBuilder.AppendLine(" (@WRTKey, @FANKey,"); vStringBuilder.AppendLine(" @FAWDateCreated)"); vStringBuilder.AppendLine(";"); vSqlCommand.Parameters.Add("@WRTKey", SqlDbType.Int); vSqlCommand.Parameters.Add("@FANKey", SqlDbType.Int); vSqlCommand.Parameters.Add("@FAWDateCreated", SqlDbType.DateTime); vSqlCommand.CommandText = vStringBuilder.ToString(); vSqlCommand.Connection.Open(); aFanWorkoutCollection.FanWorkoutList.ForEach(vFanWorkout => { vSqlCommand.Parameters["@WRTKey"].Value = vFanWorkout.WrtKey; vSqlCommand.Parameters["@FANKey"].Value = vFanWorkout.FanKey; vSqlCommand.Parameters["@FAWDateCreated"].Value = DateTime.Parse(vFanWorkout.FanWorkoutDateCreated); vSqlCommand.ExecuteScalar(); }); vSqlCommand.Connection.Close(); } }
public static webObject editFanWorkoutCollection(FanWorkoutCollection aFanWorkoutCollection) { FanToken vFanToken = ServerSession.GetFanToken(HttpContext.Current.Session); webObject vWebObject = new webObject(); vWebObject.aTransactionStatus = ServerSession.GetTransactionStatus(HttpContext.Current.Session); try { FanServiceConsumer.SaveFanWorkout(vFanToken, aFanWorkoutCollection); vWebObject.aTransactionStatus.TransactionResult = TransactionResult.OK; vWebObject.aTransactionStatus.Message = "FanWorkoutCollection Edited"; ServerSession.SetTransactionStatus(HttpContext.Current.Session, vWebObject.aTransactionStatus); vWebObject.AnObject = aFanWorkoutCollection; } catch (TransactionStatusException tx) { vWebObject.aTransactionStatus.AssignFromSource(tx.TransactionStatus); return(vWebObject); } catch (Exception ex) { vWebObject.aTransactionStatus.TransactionResult = TransactionResult.GeneralException; vWebObject.aTransactionStatus.Message = "Edit of FanWorkoutCollection unsuccesful" + ex.Message; vWebObject.aTransactionStatus.InnerMessage = ex.InnerException == null ? String.Empty : ex.InnerException.Message; return(vWebObject); } return(vWebObject); }
/// <summary> /// The overloaded Load method that will return a <see cref="FanWorkoutCollection"/>. /// </summary> /// <param name="aFanKey">A <see cref="FanKey"/> object.</param> /// <param name="aFanWorkoutCollection">A <see cref="FanWorkoutCollection"/> object.</param> /// <exception cref="ArgumentNullException">If <c>aFanWorkoutCollection</c> argument is <c>null</c>.</exception> public static void Load(FanKey aFanKey, FanWorkoutCollection aFanWorkoutCollection) { if (aFanWorkoutCollection == null) { throw new ArgumentNullException("Load FanWorkout Business"); } //if (!FanFunctionAccessData.HasModeAccess(aFanKey, "FanWorkout", AccessMode.List)) //{ // throw new ZpAccessException("Access Denied", String.Format("{0}", aFanKey.FannKey), AccessMode.List, "FanWorkout"); //} FanWorkoutData.Load(aFanWorkoutCollection); }
/// <summary> /// The overloaded Load method that will fill the <c>FanWorkoutList</c> property a <see cref="FanWorkoutCollection"/> object as an /// ordered <c>List</c> of <see cref="FanWorkout"/>, filtered by the filter properties of the passed <see cref="FanWorkoutCollection"/>. /// </summary> /// <param name="aFanWorkoutCollection">The <see cref="FanWorkoutCollection"/> object that must be filled.</param> /// <remarks> /// The filter properties of the <see cref="FanWorkoutCollection"/> must be correctly completed by the calling application. /// </remarks> /// <exception cref="ArgumentNullException">If <c>aFanWorkoutCollection</c> argument is <c>null</c>.</exception> public static void Load(FanWorkoutCollection aFanWorkoutCollection) { if (aFanWorkoutCollection == null) { throw new ArgumentNullException("aFanWorkoutCollection"); } using (var vSqlCommand = new SqlCommand() { CommandType = CommandType.Text, Connection = new SqlConnection(Connection.Instance.SqlConnectionString) }) { var vStringBuilder = BuildSQL(); if (aFanWorkoutCollection.IsFiltered) { if (aFanWorkoutCollection.FanWorkoutFilter.FawFilter.WrtKey > 0) { vStringBuilder.AppendLine("and t1.WRT_Key = @WRTKey"); vSqlCommand.Parameters.AddWithValue("@WRTKey", aFanWorkoutCollection.FanWorkoutFilter.FawFilter.WrtKey); } if (aFanWorkoutCollection.FanWorkoutFilter.FawFilter.FanKey > 0) { vStringBuilder.AppendLine("and t2.FAN_Key = @FANKey"); vSqlCommand.Parameters.AddWithValue("@FANKey", aFanWorkoutCollection.FanWorkoutFilter.FawFilter.FanKey); } if (aFanWorkoutCollection.FanWorkoutFilter.FawFilter.WrtName != null) { vStringBuilder.AppendFormat("and t1.WRT_Name like '%{0}%'", aFanWorkoutCollection.FanWorkoutFilter.FawFilter.WrtName); } if (aFanWorkoutCollection.FanWorkoutFilter.FawFilter.FanName != null) { vStringBuilder.AppendFormat("and t2.FAN_Name like '%{0}%'", aFanWorkoutCollection.FanWorkoutFilter.FawFilter.FanName); } } vStringBuilder.AppendLine("order by t1.WRT_Name"); vSqlCommand.CommandText = vStringBuilder.ToString(); vSqlCommand.Connection.Open(); using (SqlDataReader vSqlDataReader = vSqlCommand.ExecuteReader()) { while (vSqlDataReader.Read()) { var vFanWorkout = new FanWorkout(); DataToObject(vFanWorkout, vSqlDataReader, false); aFanWorkoutCollection.FanWorkoutList.Add(vFanWorkout); } vSqlDataReader.Close(); } vSqlCommand.Connection.Close(); } }
/// <summary> /// Save a <see cref="FanWorkout" /> list passed as an argument. /// </summary> /// <param name="aFanKey">A <see cref="FanKey" /> object.</param> /// <param name="aFanWorkoutCollection">A cell fan collection.</param> /// <exception cref="Zephry.ZpAccessException">Access Denied; FanWorkout</exception> /// <exception cref="ArgumentNullException">If <c>aFanWorkout</c> argument is <c>null</c>.</exception> public static void Save(FanKey aFanKey, FanWorkoutCollection aFanWorkoutCollection) { if (aFanWorkoutCollection == null) { throw new ArgumentNullException("Update FanWorkoutCollection Business"); } //if (!FanFunctionAccessData.HasModeAccess(aFanKey, "FanWorkout", AccessMode.Update)) //{ // throw new ZpAccessException("Access Denied", String.Format("{0}", aFanKey.FannKey), AccessMode.Update, "FanWorkout"); //} //Set Dates of new fanworkouts DateTime x; foreach (FanWorkout aFw in aFanWorkoutCollection.FanWorkoutList) { if (!(DateTime.TryParse(aFw.FanWorkoutDateCreated, out x))) { aFw.FanWorkoutDateCreated = DateTime.Now.ToLongDateString(); ; } } FanWorkoutData.Save(aFanWorkoutCollection); }
public static void Save(FanWorkoutCollection aFanWorkoutCollection) { Delete(aFanWorkoutCollection.FanWorkoutFilter.FawFilter); Insert(aFanWorkoutCollection); }
/// <summary> /// Gets a specified <see cref="FanWorkoutCollection"/>. /// </summary> /// <param name="aFanToken">A <see cref="FanToken"/> object used for Access Control.</param> /// <param name="aFanWorkoutCollection"><see cref="FanWorkout"/>Collection object.</param> public static void GetFanWorkoutCollection(FanToken aFanToken, FanWorkoutCollection aFanWorkoutCollection) { FanCallHandler.ServiceCall<FanWorkoutCollection>(aFanToken, "GetFanWorkoutCollection", aFanWorkoutCollection); }
/// <summary> /// Saves the provider suburb. /// </summary> /// <param name="aFanKey">A user key.</param> /// <param name="aXmlArgument">A XML argument.</param> /// <returns>A string of XML representing a FanWorkoutCollection</returns> /// <exception cref="System.ArgumentNullException">aXmlArgument of SaveFanWorkout</exception> public static string SaveFanWorkout(FanKey aFanKey, string aXmlArgument) { if (aXmlArgument == null) { throw new ArgumentNullException("aXmlArgument of SaveFanWorkout"); } FanWorkoutCollection vFanWorkoutCollection = new FanWorkoutCollection(); vFanWorkoutCollection = XmlUtils.Deserialize<FanWorkoutCollection>(aXmlArgument); FanWorkoutBusiness.Save(aFanKey, vFanWorkoutCollection); return XmlUtils.Serialize<FanWorkoutCollection>(vFanWorkoutCollection, true); }
public static webObject loadFanWorkoutCollection(FanWorkoutCollection aFanWorkoutCollection) { FanToken vFanToken = ServerSession.GetFanToken(HttpContext.Current.Session); webObject vWebObject = new webObject(); vWebObject.aTransactionStatus = ServerSession.GetTransactionStatus(HttpContext.Current.Session); try { FanServiceConsumer.GetFanWorkoutCollection(vFanToken, aFanWorkoutCollection); vWebObject.aTransactionStatus.TransactionResult = TransactionResult.OK; vWebObject.aTransactionStatus.Message = "FanWorkoutCollection Loaded"; ServerSession.SetTransactionStatus(HttpContext.Current.Session, vWebObject.aTransactionStatus); vWebObject.AnObject = aFanWorkoutCollection; } catch (TransactionStatusException tx) { vWebObject.aTransactionStatus.AssignFromSource(tx.TransactionStatus); return vWebObject; } catch (Exception ex) { vWebObject.aTransactionStatus.TransactionResult = TransactionResult.GeneralException; vWebObject.aTransactionStatus.Message = "Load of FanWorkoutCollection unsuccesful" + ex.Message; vWebObject.aTransactionStatus.InnerMessage = ex.InnerException == null ? String.Empty : ex.InnerException.Message; return vWebObject; } return vWebObject; }
/// <summary> /// Add a <see cref="FanWorkout" />. /// </summary> /// <param name="aFanToken">A <see cref="FanToken" /> object used for Access Control.</param> /// <param name="aFanWorkoutCollection">A provider suburb collection.</param> public static void SaveFanWorkout(FanToken aFanToken, FanWorkoutCollection aFanWorkoutCollection) { FanCallHandler.ServiceCall <FanWorkoutCollection>(aFanToken, "SaveFanWorkout", aFanWorkoutCollection); }
/// <summary> /// Gets a specified <see cref="FanWorkoutCollection"/>. /// </summary> /// <param name="aFanToken">A <see cref="FanToken"/> object used for Access Control.</param> /// <param name="aFanWorkoutCollection"><see cref="FanWorkout"/>Collection object.</param> public static void GetFanWorkoutCollection(FanToken aFanToken, FanWorkoutCollection aFanWorkoutCollection) { FanCallHandler.ServiceCall <FanWorkoutCollection>(aFanToken, "GetFanWorkoutCollection", aFanWorkoutCollection); }
/// <summary> /// Add a <see cref="FanWorkout" />. /// </summary> /// <param name="aFanToken">A <see cref="FanToken" /> object used for Access Control.</param> /// <param name="aFanWorkoutCollection">A provider suburb collection.</param> public static void SaveFanWorkout(FanToken aFanToken, FanWorkoutCollection aFanWorkoutCollection) { FanCallHandler.ServiceCall<FanWorkoutCollection>(aFanToken, "SaveFanWorkout", aFanWorkoutCollection); }