public static int Update(PrizeDrawingWinners o) { int iReturn = -1; //assume the worst SqlParameter[] arrParams = new SqlParameter[9]; arrParams[0] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); arrParams[1] = new SqlParameter("@PDID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDID, o.PDID.GetTypeCode())); arrParams[2] = new SqlParameter("@PatronID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PatronID, o.PatronID.GetTypeCode())); arrParams[3] = new SqlParameter("@NotificationID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.NotificationID, o.NotificationID.GetTypeCode())); arrParams[4] = new SqlParameter("@PrizePickedUpFlag", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrizePickedUpFlag, o.PrizePickedUpFlag.GetTypeCode())); arrParams[5] = new SqlParameter("@LastModDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModDate, o.LastModDate.GetTypeCode())); arrParams[6] = new SqlParameter("@LastModUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModUser, o.LastModUser.GetTypeCode())); arrParams[7] = new SqlParameter("@AddedDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedDate, o.AddedDate.GetTypeCode())); arrParams[8] = new SqlParameter("@AddedUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedUser, o.AddedUser.GetTypeCode())); try { iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Update", arrParams); } catch (SqlException exx) { System.Diagnostics.Debug.Write(exx.Message); } return(iReturn); }
public static int Delete(PrizeDrawingWinners o) { int iReturn = -1; //assume the worst SqlParameter[] arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); try { iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Delete", arrParams); } catch (SqlException exx) { System.Diagnostics.Debug.Write(exx.Message); } return(iReturn); }
public static int Insert(PrizeDrawingWinners o) { SqlParameter[] arrParams = new SqlParameter[9]; arrParams[0] = new SqlParameter("@PDID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDID, o.PDID.GetTypeCode())); arrParams[1] = new SqlParameter("@PatronID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PatronID, o.PatronID.GetTypeCode())); arrParams[2] = new SqlParameter("@NotificationID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.NotificationID, o.NotificationID.GetTypeCode())); arrParams[3] = new SqlParameter("@PrizePickedUpFlag", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrizePickedUpFlag, o.PrizePickedUpFlag.GetTypeCode())); arrParams[4] = new SqlParameter("@LastModDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModDate, o.LastModDate.GetTypeCode())); arrParams[5] = new SqlParameter("@LastModUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModUser, o.LastModUser.GetTypeCode())); arrParams[6] = new SqlParameter("@AddedDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedDate, o.AddedDate.GetTypeCode())); arrParams[7] = new SqlParameter("@AddedUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedUser, o.AddedUser.GetTypeCode())); arrParams[8] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); arrParams[8].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Insert", arrParams); o.PDWID = int.Parse(arrParams[8].Value.ToString()); return(o.PDWID); }
public static int Delete(PrizeDrawingWinners o) { int iReturn = -1; //assume the worst SqlParameter[] arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); try { iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Delete", arrParams); } catch (SqlException exx) { System.Diagnostics.Debug.Write(exx.Message); } return iReturn; }
public static int Update(PrizeDrawingWinners o) { int iReturn = -1; //assume the worst SqlParameter[] arrParams = new SqlParameter[9]; arrParams[0] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); arrParams[1] = new SqlParameter("@PDID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDID, o.PDID.GetTypeCode())); arrParams[2] = new SqlParameter("@PatronID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PatronID, o.PatronID.GetTypeCode())); arrParams[3] = new SqlParameter("@NotificationID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.NotificationID, o.NotificationID.GetTypeCode())); arrParams[4] = new SqlParameter("@PrizePickedUpFlag", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrizePickedUpFlag, o.PrizePickedUpFlag.GetTypeCode())); arrParams[5] = new SqlParameter("@LastModDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModDate, o.LastModDate.GetTypeCode())); arrParams[6] = new SqlParameter("@LastModUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModUser, o.LastModUser.GetTypeCode())); arrParams[7] = new SqlParameter("@AddedDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedDate, o.AddedDate.GetTypeCode())); arrParams[8] = new SqlParameter("@AddedUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedUser, o.AddedUser.GetTypeCode())); try { iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Update", arrParams); } catch (SqlException exx) { System.Diagnostics.Debug.Write(exx.Message); } return iReturn; }
public static int Insert(PrizeDrawingWinners o) { SqlParameter[] arrParams = new SqlParameter[9]; arrParams[0] = new SqlParameter("@PDID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDID, o.PDID.GetTypeCode())); arrParams[1] = new SqlParameter("@PatronID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PatronID, o.PatronID.GetTypeCode())); arrParams[2] = new SqlParameter("@NotificationID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.NotificationID, o.NotificationID.GetTypeCode())); arrParams[3] = new SqlParameter("@PrizePickedUpFlag", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrizePickedUpFlag, o.PrizePickedUpFlag.GetTypeCode())); arrParams[4] = new SqlParameter("@LastModDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModDate, o.LastModDate.GetTypeCode())); arrParams[5] = new SqlParameter("@LastModUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModUser, o.LastModUser.GetTypeCode())); arrParams[6] = new SqlParameter("@AddedDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedDate, o.AddedDate.GetTypeCode())); arrParams[7] = new SqlParameter("@AddedUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedUser, o.AddedUser.GetTypeCode())); arrParams[8] = new SqlParameter("@PDWID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PDWID, o.PDWID.GetTypeCode())); arrParams[8].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_Insert", arrParams); o.PDWID = int.Parse(arrParams[8].Value.ToString()); return o.PDWID; }
public bool Fetch(int PDWID) { // declare reader SqlDataReader dr; SqlParameter[] arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@PDWID", PDWID); dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_GetByID", arrParams); if (dr.Read()) { // declare return value PrizeDrawingWinners result = new PrizeDrawingWinners(); DateTime _datetime; int _int; //decimal _decimal; if (int.TryParse(dr["PDWID"].ToString(), out _int)) this.PDWID = _int; if (int.TryParse(dr["PDID"].ToString(), out _int)) this.PDID = _int; if (int.TryParse(dr["PatronID"].ToString(), out _int)) this.PatronID = _int; if (int.TryParse(dr["NotificationID"].ToString(), out _int)) this.NotificationID = _int; this.PrizePickedUpFlag = bool.Parse(dr["PrizePickedUpFlag"].ToString()); if (DateTime.TryParse(dr["LastModDate"].ToString(), out _datetime)) this.LastModDate = _datetime; this.LastModUser = dr["LastModUser"].ToString(); if (DateTime.TryParse(dr["AddedDate"].ToString(), out _datetime)) this.AddedDate = _datetime; this.AddedUser = dr["AddedUser"].ToString(); dr.Close(); return true; } dr.Close(); return false; }
public static int DrawWinners(int PDID, int numWinners, int additional = 0) { SqlParameter[] arrParams = new SqlParameter[3]; arrParams[0] = new SqlParameter("@PDID", PDID); arrParams[1] = new SqlParameter("@NumWinners", numWinners); arrParams[2] = new SqlParameter("@Additional", additional); var ds = SqlHelper.ExecuteDataset(conn, CommandType.StoredProcedure, "app_PrizeDrawing_DrawWinners", arrParams); var ret = ds.Tables[0].Rows.Count; var pd = PrizeDrawing.FetchObject(PDID); var pt = PrizeTemplate.FetchObject(pd.TID); var now = DateTime.Now; for (var i = 0; i < ds.Tables[0].Rows.Count; i++) { int PID = (int)ds.Tables[0].Rows[i]["PatronID"]; int NID = (int)ds.Tables[0].Rows[i]["NotificationID"]; int PDWID = (int)ds.Tables[0].Rows[i]["PDWID"]; // insert patron prize var pp = new PatronPrizes { PID = PID, PrizeSource = 0, BadgeID = 0, DrawingID = PDWID, PrizeName = pd.PrizeName, RedeemedFlag = false, AddedDate = now, LastModDate = now, AddedUser = "******", LastModUser = "******" }; pp.Insert(); if (pt.SendNotificationFlag) { // generate notification var not = new Notifications { PID_To = PID, PID_From = 0, //0 == System Notification Subject = pt.NotificationSubject, Body = pt.NotificationMessage, isQuestion = false, AddedDate = now, LastModDate = now, AddedUser = "******", LastModUser = "******" }; not.Insert(); var w = PrizeDrawingWinners.FetchObject(PDWID); w.NotificationID = not.NID; w.Update(); } else { var w = PrizeDrawingWinners.FetchObject(PDWID); w.NotificationID = -1; w.Update(); } } return(ret); }
public static PrizeDrawingWinners FetchObject(int PDWID) { // declare reader SqlDataReader dr; SqlParameter[] arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@PDWID", PDWID); dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_PrizeDrawingWinners_GetByID", arrParams); if (dr.Read()) { // declare return value PrizeDrawingWinners result = new PrizeDrawingWinners(); DateTime _datetime; int _int; //decimal _decimal; if (int.TryParse(dr["PDWID"].ToString(), out _int)) { result.PDWID = _int; } if (int.TryParse(dr["PDID"].ToString(), out _int)) { result.PDID = _int; } if (int.TryParse(dr["PatronID"].ToString(), out _int)) { result.PatronID = _int; } if (int.TryParse(dr["NotificationID"].ToString(), out _int)) { result.NotificationID = _int; } result.PrizePickedUpFlag = bool.Parse(dr["PrizePickedUpFlag"].ToString()); if (DateTime.TryParse(dr["LastModDate"].ToString(), out _datetime)) { result.LastModDate = _datetime; } result.LastModUser = dr["LastModUser"].ToString(); if (DateTime.TryParse(dr["AddedDate"].ToString(), out _datetime)) { result.AddedDate = _datetime; } result.AddedUser = dr["AddedUser"].ToString(); dr.Close(); return(result); } dr.Close(); return(null); }