public static MyEventsModel TranslateAsMyEvent(this SqlDataReader reader, bool isList = false)
{
if (!isList)
{
if (!reader.HasRows)
{
return(null);
}
reader.Read();
}
var item = new MyEventsModel();
if (reader.IsColumnExists("Id"))
{
item.Id = SqlHelper.GetNullableInt32(reader, "Id");
}
if (reader.IsColumnExists("EventTitle"))
{
item.EventTitle = SqlHelper.GetNullableString(reader, "EventTitle");
}
if (reader.IsColumnExists("EventDate"))
{
item.EventDate = SqlHelper.GetNullableDateTime(reader, "EventDate");
}
if (reader.IsColumnExists("Category"))
{
item.Category = SqlHelper.GetNullableString(reader, "Category");
}
if (reader.IsColumnExists("Picture"))
{
item.Picture = SqlHelper.GetNullableString(reader, "Picture");
}
if (reader.IsColumnExists("Screen_format"))
{
item.Screen_format = SqlHelper.GetNullableScreenFormat(reader, "Screen_format");
}
if (reader.IsColumnExists("EventVenue"))
{
item.EventVenue = SqlHelper.GetNullableString(reader, "EventVenue");
}
if (reader.IsColumnExists("Discription"))
{
item.Discription = SqlHelper.GetNullableString(reader, "Discription");
}
if (reader.IsColumnExists("Organizer"))
{
item.Organizer = SqlHelper.GetNullableString(reader, "Organizer");
}
return(item);
}
public ActionResult AllEvents()
{
MyEventsModel events = new MyEventsModel()
{
UserPurchasedEvents = GenericMethodsservices.GetAdminEvents()
};
return(View(events));
}
public ActionResult Events()
{
if (Session["UserId"] != null)
{
MyEventsModel events = new MyEventsModel()
{
UserPurchasedEvents = GenericMethods.GetAdminEvents()
};
return(View(events));
}
return(RedirectToAction(LoginPages.Login, LoginPages.Account, new { area = "" }));
}
public ActionResult MyEvents()
{
if (Session["UserId"] != null)
{
MyEventsModel Events = new MyEventsModel()
{
UserPurchasedEvents = UserSelectionServices.MyUserEvents(Convert.ToInt32(Session["UserId"].ToString()))
};
return(View(Events));
}
return(RedirectToAction(LoginPages.Login, LoginPages.Account, new { area = "" }));
}
public IActionResult saveMyEvent([FromBody] MyEventsModel myEvents)
{
if (myEvents == null)
{
return(BadRequest());
}
var msg = new Message <MyEventsModel>();
var data = DbClientFactory <MyEventsDBClient> .Instance.SaveMyEvent(myEvents,
configuration.GetSection("MySettings").GetSection("DbConnection").Value);
if (data == "c200")
{
msg.IsSuccess = true;
if (myEvents.Id == 0)
{
msg.ReturnMessage = "User saved successfully";
}
else
{
msg.ReturnMessage = "User updated successfully";
}
}
else if (data == "c201")
{
msg.IsSuccess = false;
msg.ReturnMessage = "Organizer not found";
}
else if (data == "c202")
{
msg.IsSuccess = false;
msg.ReturnMessage = "Category not found";
}
else if (data == "c203")
{
msg.IsSuccess = false;
msg.ReturnMessage = "Updated myevent not found";
}
return(Ok(msg));
}
