public ResultModel EventOperation(EventOperationModel model)
{
ResultModel result = new ResultModel();
sqlCommand = new SqlCommand()
{
Connection = connectionHelper.connection,
CommandType = CommandType.StoredProcedure,
CommandText = "EventOperationSP",
};
sqlCommand.Parameters.Add("@EventId", SqlDbType.Int).Value = model.EventId;
sqlCommand.Parameters.Add("@PersonId", SqlDbType.Int).Value = model.PersonId;
sqlCommand.Parameters.Add("@IsGoing", SqlDbType.Bit).Value = model.IsGoing;
sqlCommand.Parameters.Add("@IsInterested", SqlDbType.Bit).Value = model.IsInterested;
connectionHelper.connection.Open();
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
if (sqlReader.HasRows)
{
if (sqlReader.Read())
{
result = new ResultModel()
{
IsSuccess = (bool)sqlReader["IsSuccess"],
Message = sqlReader["Message"] as string
};
}
}
connectionHelper.connection.Close();
return(result);
}
protected void Interested_Click(object sender, EventArgs e)
{
var user = (UserBO)Session["user"];
if (interestedButton.InnerText == "Interested")
{
goingButton.InnerText = "Going";
interestedButton.InnerText = "Cancel";
var model = new EventOperationModel()
{
EventId = eventId,
PersonId = user.Id,
IsGoing = false,
IsInterested = true
};
var response = eventOperationBal.EventsOperation(model);
if (response != null && response.IsSuccess == true)
{
GetEventOperationStatusRequest();
GetEventOperationStatisticRequest();
}
}
else
{
goingButton.InnerText = "Going";
interestedButton.InnerText = "Interested";
var model = new EventOperationModel()
{
EventId = eventId,
PersonId = user.Id,
IsGoing = false,
IsInterested = false
};
var response = eventOperationBal.EventsOperation(model);
if (response != null && response.IsSuccess == true)
{
GetEventOperationStatusRequest();
GetEventOperationStatisticRequest();
}
}
}
public ResultModel EventsOperation(EventOperationModel model)
{
return(eventOperationDal.EventOperation(model));
}