public ActionResult Invite(int id, string email)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsModels eventsModels = db.EventsModels.Find(id);
if (eventsModels == null)
{
return(HttpNotFound());
}
var newInvite = new EventGuestsModels();
newInvite.EventId = id;
newInvite.GuestEmail = email;
newInvite.EventName = eventsModels.Name;
newInvite.EventDate = eventsModels.EventDate;
newInvite.EventLocation = db.LocationsModels.Find(eventsModels.LocationId).Name;
db.EventGuestsModels.Add(newInvite);
db.SaveChanges();
return(View(eventsModels));
}
public ActionResult ChoseLocation(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsModels eventsModels = db.EventsModels.Find(id);
if (eventsModels == null)
{
return(HttpNotFound());
}
string SQL_querry = "SELECT * FROM LocationsModels EXCEPT (SELECT LocationsModels.Id, LocationsModels.Name, LocationsModels.City, LocationsModels.State, LocationsModels.Street, LocationsModels.Number, LocationsModels.AddressDetails, LocationsModels.Description, LocationsModels.Capacity FROM LocationsModels INNER JOIN ApprovedReservationsModels ON ApprovedReservationsModels.LocationReserved = LocationsModels.Id AND ApprovedReservationsModels.Date = @p0)";
var model = new EventLocationsViewModels()
{
Event = eventsModels,
Locations = (db.Database.SqlQuery <LocationsModels>(SQL_querry, eventsModels.EventDate))
};
return(View(model));
}
// GET: Events/Details/5
public ActionResult Details(int id)
{
var myEvent = new EventsModels {
EventID = id, EventName = "Hello"
};
return(View(myEvent));
}
public ActionResult DeleteConfirmed(int id)
{
EventsModels eventsModels = db.EventsModels.Find(id);
db.EventsModels.Remove(eventsModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult ViewEventKod(string category, string kod)
{
List <EventsModels> events = SenaraiAktiviti(category);
EventsModels araca = events.FirstOrDefault(s => s.kod == kod);
if (araca == null)
{
araca = new EventsModels();
}
return(Json(araca, JsonRequestBehavior.AllowGet));
}
public JsonResult CariCuti(HR_ACARA aktiviti, HR_TARIKH_ACARA tarikhaktiviti, string HR_KATEGORI, string HR_JENIS)
{
if (HR_KATEGORI == "C")
{
EventsModels events = SenaraiAktiviti("ALL").FirstOrDefault(s => s.id == tarikhaktiviti.HR_TARIKH.ToString() && s.kod == aktiviti.HR_KOD_ACARA);
if (events != null)
{
return(Json(new { error = true, msg = "Maaf tarikh cuti telah wujud" }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { error = false, msg = "" }, JsonRequestBehavior.AllowGet));
}
// GET: Events/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsModels eventsModels = db.EventsModels.Find(id);
if (eventsModels == null)
{
return(HttpNotFound());
}
return(View(eventsModels));
}
public ActionResult BookLocationForEvent(int id, int locationId)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (locationId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsModels eventsModels = db.EventsModels.Find(id);
if (eventsModels == null)
{
return(HttpNotFound());
}
eventsModels.LocationId = locationId;
eventsModels.LocationName = db.LocationsModels.Find(locationId).Name;
db.SaveChanges();
var newApprovedReservation = new ApprovedReservationsModels();
newApprovedReservation.User = eventsModels.CreationUser;
newApprovedReservation.Date = eventsModels.EventDate;
newApprovedReservation.Reason = eventsModels.Name;
newApprovedReservation.Phone = " ";
newApprovedReservation.LocationReserved = eventsModels.LocationId;
db.ApprovedReservationsModels.Add(newApprovedReservation);
db.SaveChanges();
var newCostsModels = new CostsModels();
newCostsModels.UserName = eventsModels.CreationUser;
newCostsModels.Date = DateTime.Now;
newCostsModels.Amount = 200;
newCostsModels.Month = eventsModels.EventDate;
newCostsModels.EventId = eventsModels.Id;
newCostsModels.EventName = eventsModels.Name;
db.CostsModels.Add(newCostsModels);
db.SaveChanges();
string redirectUrl = "/Events";
return(Redirect(redirectUrl));
}
// GET: Events/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsModels eventsModels = db.EventsModels.Find(id);
string user_name = User.Identity.GetUserName();
if (eventsModels == null)
{
return(HttpNotFound());
}
if (eventsModels.CreationUser == user_name)
{
return(View(eventsModels));
}
return(HttpNotFound());
}
public ActionResult Create([Bind(Include = "Id,Name,Description,EventDate")] EventsModels eventsModels)
{
SqlConnection conn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=aspnet-ArtClub-20180506023021;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
conn.Open();
SqlCommand com1 = new SqlCommand("SELECT SUM(Amount) FROM PaymentsModels WHERE FORMAT(Month,'yyyy-MM') = @p0", conn);
SqlCommand com2 = new SqlCommand("SELECT SUM(Amount) FROM CostsModels WHERE FORMAT(Month,'yyyy-MM') = @p0", conn);
com1.Parameters.AddWithValue("@p0", eventsModels.EventDate.ToString("yyyy-MM"));
string totalPayments = com1.ExecuteScalar().ToString();
com2.Parameters.AddWithValue("@p0", eventsModels.EventDate.ToString("yyyy-MM"));
string totalCosts = com2.ExecuteScalar().ToString();
float totalPaymentsForMonth = float.Parse(totalPayments);
float totalCostsForMonth = float.Parse(totalCosts);
if (totalPaymentsForMonth < totalCostsForMonth)
{
ViewBag.message = "You cannot reserve anymore. The club budget it's over for this month.";
return(View(eventsModels));
}
if (ModelState.IsValid)
{
eventsModels.CreationUser = User.Identity.GetUserName();
eventsModels.CreationDate = DateTime.Now;
db.EventsModels.Add(eventsModels);
db.SaveChanges();
string redirectUrl = "/Events/ChoseLocation/" + eventsModels.Id;
return(Redirect(redirectUrl));
}
return(View(eventsModels));
}
public List <EventsModels> SenaraiAktiviti(string category)
{
List <EventsModels> events = new List <EventsModels>();
if (category == "C" || category == "ALL")
{
string cutiInd = "C";
//if(category == "C")
//{
// cutiInd = "B";
//}
List <HR_CUTI> cuti = db.HR_CUTI.Where(s => s.HR_AKTIF_IND == "Y" && s.HR_CUTI_IND == cutiInd).ToList();
foreach (HR_CUTI item in cuti)
{
List <HR_CUTI_UMUM> cutiumum = db.HR_CUTI_UMUM.Where(s => s.HR_KOD_CUTI_UMUM == item.HR_KOD_CUTI).OrderBy(s => s.HR_TARIKH).ToList();
if (category == "ALL")
{
foreach (HR_CUTI_UMUM item2 in cutiumum)
{
EventsModels aktiviti = new EventsModels();
aktiviti.id = item2.HR_TARIKH.ToString();
aktiviti.title = item.HR_KETERANGAN;
aktiviti.description = item2.HR_CATATAN;
aktiviti.icon = item.HR_ICON;
aktiviti.className = item.HR_COLOR == null ? "bg-color-blue" : item.HR_COLOR;
aktiviti.start = Convert.ToDateTime(item2.HR_TARIKH);
aktiviti.startHour = 0;
aktiviti.startMinute = 0;
//aktiviti.startSecond = Convert.ToInt16(waktuMula[2]);
aktiviti.end = Convert.ToDateTime(item2.HR_TARIKH);
aktiviti.endHour = 0;
aktiviti.endMinute = 0;
//aktiviti.endSecond = Convert.ToInt16(waktuAkhir[2]);
aktiviti.category = "C";
aktiviti.kod = item.HR_KOD_CUTI.ToString();
aktiviti.allDay = true;
events.Add(aktiviti);
}
}
else
{
EventsModels aktiviti = new EventsModels();
aktiviti.kod = item.HR_KOD_CUTI.ToString();
aktiviti.title = item.HR_KETERANGAN;
//aktiviti.description = item.HR_CATATAN;
aktiviti.icon = item.HR_ICON;
aktiviti.className = item.HR_COLOR == null ? "bg-color-blue" : item.HR_COLOR;
aktiviti.category = "C";
aktiviti.allDay = true;
events.Add(aktiviti);
}
}
}
if (category == "A" || category == "ALL")
{
List <HR_ACARA> sAktiviti = db.HR_ACARA.Where(s => s.HR_AKTIF_IND == "Y").ToList();
foreach (HR_ACARA item3 in sAktiviti)
{
if (category == "ALL")
{
List <HR_TARIKH_ACARA> tAktiviti = db.HR_TARIKH_ACARA.Where(s => s.HR_KOD_ACARA == item3.HR_KOD_ACARA).ToList();
foreach (HR_TARIKH_ACARA item4 in tAktiviti)
{
EventsModels aktiviti = new EventsModels();
if (item4.HR_WAKTU_MULA == null)
{
item4.HR_WAKTU_MULA = "00:00";
}
if (item4.HR_WAKTU_AKHIR == null)
{
item4.HR_WAKTU_AKHIR = "00:00";
}
string[] waktuMula = item4.HR_WAKTU_MULA.Split(':');
string[] waktuAkhir = item4.HR_WAKTU_AKHIR.Split(':');
aktiviti.id = item4.HR_KOD_TARIKH_ACARA;
aktiviti.title = item3.HR_TAJUK;
aktiviti.description = item4.HR_KETERANGAN;
aktiviti.icon = item3.HR_ICON;
aktiviti.className = item3.HR_WARNA == null ? "bg-color-blue" : item3.HR_WARNA;
aktiviti.start = Convert.ToDateTime(item4.HR_TARIKH);
aktiviti.startHour = Convert.ToInt16(waktuMula[0]);
aktiviti.startMinute = Convert.ToInt16(waktuMula[1]);
//aktiviti.startSecond = Convert.ToInt16(waktuMula[2]);
aktiviti.end = Convert.ToDateTime(item4.HR_TARIKH);
aktiviti.endHour = Convert.ToInt16(waktuAkhir[0]);
aktiviti.endMinute = Convert.ToInt16(waktuAkhir[1]);
//aktiviti.endSecond = Convert.ToInt16(waktuAkhir[2]);
aktiviti.category = "A";
aktiviti.kod = item3.HR_KOD_ACARA;
aktiviti.allDay = false;
events.Add(aktiviti);
}
}
else
{
EventsModels aktiviti = new EventsModels();
aktiviti.kod = item3.HR_KOD_ACARA;
aktiviti.title = item3.HR_TAJUK;
//aktiviti.description = item3.HR_KETERANGAN;
aktiviti.icon = item3.HR_ICON;
aktiviti.className = item3.HR_WARNA == null ? "bg-color-blue" : item3.HR_WARNA;
aktiviti.category = "A";
aktiviti.allDay = false;
events.Add(aktiviti);
}
}
}
if (category == "T" || category == "ALL")
{
List <HR_SENARAI_TEMUDUGA> iv = db.HR_SENARAI_TEMUDUGA.Include(s => s.HR_MAKLUMAT_CALON_TEMUDUGA).Include(s => s.HR_MAKLUMAT_PENEMUDUGA).ToList();
foreach (HR_SENARAI_TEMUDUGA item in iv)
{
EventsModels aktiviti = new EventsModels();
if (item.HR_MASA_MULA == null)
{
item.HR_MASA_MULA = "00:00";
}
if (item.HR_MASA_AKHIR == null)
{
item.HR_MASA_AKHIR = "00:00";
}
string[] waktuMula = item.HR_MASA_MULA.Split(':');
string[] waktuAkhir = item.HR_MASA_AKHIR.Split(':');
string penemuduga = string.Join(",\n", item.HR_MAKLUMAT_PENEMUDUGA.Select(s => new { HR_NAMA_PENEMUDUGA = Pekerja(s.HR_PENEMUDUGA).HR_NAMA_PEKERJA }));
string jawatan = null;
if (db.HR_JAWATAN.Where(s => s.HR_KOD_JAWATAN == item.HR_KOD_JAWATAN).Count() > 0)
{
jawatan = db.HR_JAWATAN.FirstOrDefault(s => s.HR_KOD_JAWATAN == item.HR_KOD_JAWATAN).HR_NAMA_JAWATAN;
}
aktiviti.id = string.Format("{0:dd/MM/yyyy}", item.HR_TARIKH_TEMUDUGA) + "|_|" + item.HR_KOD_JAWATAN + "|_|" + item.HR_TARAF_JAWATAN;
aktiviti.title = "TEMUDUGA " + item.HR_KOD_JAWATAN + " " + item.HR_TARAF_JAWATAN;
//aktiviti.description = "PENEMUDUGA : " + penemuduga;
aktiviti.icon = "fa-users";
aktiviti.className = "bg-color-blue txt-color-white";
aktiviti.start = Convert.ToDateTime(item.HR_TARIKH_TEMUDUGA);
aktiviti.startHour = Convert.ToInt16(waktuMula[0]);
aktiviti.startMinute = Convert.ToInt16(waktuMula[1]);
//aktiviti.startSecond = Convert.ToInt16(waktuMula[2]);
aktiviti.end = Convert.ToDateTime(item.HR_TARIKH_TEMUDUGA);
aktiviti.endHour = Convert.ToInt16(waktuAkhir[0]);
aktiviti.endMinute = Convert.ToInt16(waktuAkhir[1]);
//aktiviti.endSecond = Convert.ToInt16(waktuAkhir[2]);
aktiviti.category = "T";
aktiviti.kod = item.HR_KOD_JAWATAN;
aktiviti.allDay = false;
aktiviti.place = item.HR_TEMPAT;
aktiviti.gred = item.HR_GRED_GAJI;
events.Add(aktiviti);
}
}
return(events);
}
public ActionResult EventForm(EventsModels model)
{
return(View(model));
}
