public List <UpcommingEvents> History() { List <UpcommingEvents> List = new List <UpcommingEvents>(); try { SqlCon.Open(); var SqlCmd = new SqlCommand("[config].[uspReadUpcommingEvents]", SqlCon) { CommandType = CommandType.StoredProcedure }; SqlParameter parUp = new SqlParameter { ParameterName = "@pUpCommingFlag", SqlDbType = SqlDbType.Bit, Value = 1 }; SqlCmd.Parameters.Add(parUp); using (var dr = SqlCmd.ExecuteReader()) { while (dr.Read()) { var detail = new UpcommingEvents { EventID = Convert.ToInt32(dr["EventID"]), Title = dr["Title"].ToString(), MinisterID = Convert.ToInt32(dr["MinisterID"]), MinisterName = dr["MinisterName"].ToString(), Description = dr["Description"].ToString(), ScheduledDate = Convert.ToDateTime(dr["ScheduledDate"]), ScheduledTime = (TimeSpan)dr["ScheduledTime"], ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]), EventMonth = dr["Month"].ToString(), EventDay = dr["Day"].ToString(), EventTime = dr["Time"].ToString(), ReservationFlag = Convert.ToBoolean(dr["ReservationFlag"]), Capacity = Convert.ToInt32(dr["Capacity"]), Available = Convert.ToInt32(dr["Available"]), Booked = Convert.ToInt32(dr["Booked"]) }; List.Add(detail); } } } catch (Exception ex) { throw ex; } if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } return(List); }
public UpcommingEvents Details(int EventID) { UpcommingEvents ET = new UpcommingEvents(); try { SqlCon.Open(); var SqlCmd = new SqlCommand("[config].[uspReadUpcommingEvents]", SqlCon) { CommandType = CommandType.StoredProcedure }; //Insert Parameters SqlParameter pEventID = new SqlParameter { ParameterName = "@pEventID", SqlDbType = SqlDbType.Int, Value = EventID }; SqlCmd.Parameters.Add(pEventID); using (var dr = SqlCmd.ExecuteReader()) { dr.Read(); if (dr.HasRows) { ET.EventID = Convert.ToInt32(dr["EventID"]); ET.Title = dr["Title"].ToString(); ET.MinisterID = Convert.ToInt32(dr["MinisterID"]); ET.MinisterName = dr["MinisterName"].ToString(); ET.Description = dr["Description"].ToString(); ET.ScheduledDate = Convert.ToDateTime(dr["ScheduledDate"]); ET.ScheduledTime = (TimeSpan)dr["ScheduledTime"]; ET.ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]); ET.EventMonth = dr["Month"].ToString(); ET.EventDay = dr["Day"].ToString(); ET.EventTime = dr["Time"].ToString(); ET.ReservationFlag = Convert.ToBoolean(dr["ReservationFlag"]); ET.Capacity = Convert.ToInt32(dr["Capacity"]); ET.Available = Convert.ToInt32(dr["Available"]); ET.Booked = Convert.ToInt32(dr["Booked"]); } } } catch (Exception ex) { throw ex; } if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } return(ET); }
public HttpResponseMessage AddNew([FromBody] UpcommingEvents model) { var authHeader = this.Request.Headers.GetValues("Authorization").FirstOrDefault(); var token = authHeader.Substring("Bearer ".Length); var handler = new JwtSecurityTokenHandler(); var jsonToken = handler.ReadToken(token); var tokenS = handler.ReadToken(token) as JwtSecurityToken; var UserName = tokenS.Claims.First(claim => claim.Type == "UserName").Value; model.ScheduledDate = model.ScheduledDate.Add(model.ScheduledTime); var r = UBL.AddNew(model, UserName); if (!r) { return(this.Request.CreateResponse(HttpStatusCode.InternalServerError)); } else { return(this.Request.CreateResponse(HttpStatusCode.OK, r)); } }
public bool Update(UpcommingEvents Event, string insertuser) { return(UDAL.Update(Event, insertuser)); }
public bool AddNew(UpcommingEvents Event, string insertuser) { return(UDAL.AddNew(Event, insertuser)); }
public bool Update(UpcommingEvents Event, string InsertUser) { bool rpta = false; try { SqlCon.Open(); var SqlCmd = new SqlCommand("[adm].[uspUpdateUpcommingEvent]", SqlCon) { CommandType = CommandType.StoredProcedure }; //Insert Parameters SqlParameter EventID = new SqlParameter { ParameterName = "@EventID", SqlDbType = SqlDbType.Int, Value = Event.EventID }; SqlCmd.Parameters.Add(EventID); SqlParameter Title = new SqlParameter { ParameterName = "@Title", SqlDbType = SqlDbType.VarChar, Size = 50, Value = Event.Title }; SqlCmd.Parameters.Add(Title); SqlParameter MinisterID = new SqlParameter { ParameterName = "@MinisterID", SqlDbType = SqlDbType.Int, Value = Event.MinisterID }; SqlCmd.Parameters.Add(MinisterID); SqlParameter Description = new SqlParameter { ParameterName = "@Description", SqlDbType = SqlDbType.VarChar, Value = Event.Description }; SqlCmd.Parameters.Add(Description); SqlParameter ScheduleDate = new SqlParameter { ParameterName = "@ScheduleDate", SqlDbType = SqlDbType.DateTime, Value = Event.ScheduledDate }; SqlCmd.Parameters.Add(ScheduleDate); SqlParameter pRF = new SqlParameter { ParameterName = "@ReservationFlag", SqlDbType = SqlDbType.Bit, Value = Event.ReservationFlag }; SqlCmd.Parameters.Add(pRF); if (Event.ReservationFlag == true) { SqlParameter pCapacity = new SqlParameter { ParameterName = "@Capacity", SqlDbType = SqlDbType.Int, Value = Event.Capacity }; SqlCmd.Parameters.Add(pCapacity); } SqlParameter ParInsertUser = new SqlParameter { ParameterName = "@InsertUser", SqlDbType = SqlDbType.VarChar, Size = 50, Value = InsertUser }; SqlCmd.Parameters.Add(ParInsertUser); SqlParameter UpdateType = new SqlParameter { ParameterName = "@ActionType", SqlDbType = SqlDbType.VarChar, Size = 10, Value = Event.ActionType }; SqlCmd.Parameters.Add(UpdateType); //Exec Command SqlCmd.ExecuteNonQuery(); rpta = true; } catch (Exception ex) { throw ex; } if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } return(rpta); }