public static bool CreateNewEvent(string Title, string Description, string NewEventDate, string NewEventTime, string NewEventDuration, EventType eventType, int EventID = 0) { try { DiaryContainer ent = new DiaryContainer(); AppointmentDiary rec = new AppointmentDiary(); rec.Title = Title; rec.Description = Description; rec.EventType = (int)eventType; rec.DateTimeScheduled = DateTime.ParseExact(NewEventDate + " " + NewEventTime, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); rec.AppointmentLength = Int32.Parse(NewEventDuration); if (EventID > 0) { rec.ID = EventID; ent.Entry(rec).State = System.Data.Entity.EntityState.Modified; ent.SaveChanges(); } else { ent.AppointmentDiary.Add(rec); ent.SaveChanges(); } } catch (Exception) { return(false); } return(true); }
public static bool InitialiseDiary() { // init connection to database DiaryContainer ent = new DiaryContainer(); try { for (int i = 0; i < 30; i++) { AppointmentDiary item = new AppointmentDiary(); // record ID is auto generated item.Title = "Appt: " + i.ToString(); item.SomeImportantKey = i; item.StatusENUM = GetRandomValue(0, 3); // random is exclusive - we have three status enums if (i <= 5) // create a few appointments for todays date { item.DateTimeScheduled = GetRandomAppointmentTime(false, true); } else { // rest of appointments on previous and future dates if (i % 2 == 0) item.DateTimeScheduled = GetRandomAppointmentTime(true, false); // flip/flop between date ahead of today and behind today else item.DateTimeScheduled = GetRandomAppointmentTime(false, false); } item.AppointmentLength = GetRandomValue(1, 5) * 15; // appoiment length in blocks of fifteen minutes in this demo ent.AppointmentDiary.Add(item); ent.SaveChanges(); } } catch (Exception) { return false; } return ent.AppointmentDiary.Count() > 0; }
public JsonResult SendContact(ContactInfo model) { // bool isOK = false; var contact = new ContactInfo { FullName = model.FullName, Email = model.Email, Phone = model.Phone, Message = model.Message, DateSent = DateTime.Now }; DiaryContainer db = new DiaryContainer(); db.ContactInfo.Add(contact); db.SaveChanges(); return(Json("Your message has been sent successfully. We will contact you with feedback shortly.", JsonRequestBehavior.DenyGet)); }
public static bool InitialiseDiary() { DiaryContainer ent = new DiaryContainer(); try { for (int i = 0; i < 30; i++) { AppointmentDiary item = new AppointmentDiary(); //record ID is auto generated item.Title = "Appt : " + i.ToString(); item.SomeImportantKey = i; item.StatuENUM = GetRandomValue(0, 3); //radom is exclusive - we have three status enums if (i <= 5) //create ten appointments for todays date { item.DateTimeSchedule = GetRandomAppointmentTime(false, true); } else { //rest of appointments on previous and future dates if (i % 2 == 0) { item.DateTimeSchedule = GetRandomAppointmentTime(true, false); //flip/flop between date ahead of today and behind today } else { item.DateTimeSchedule = GetRandomAppointmentTime(false, false); } item.AppointmentLength = GetRandomValue(1, 5) * 15; //appointment length always less than an hour in blocks of fifteen ent.AppointmentDiaries.Add(item); ent.SaveChanges(); } } } catch (Exception) { return(false); } return(ent.AppointmentDiaries.Count() > 0); }
public static void UpdateDiaryEvent(int id, string NewEventStart, string NewEventEnd) { // EventStart comes ISO 8601 format, eg: "2000-01-10T10:00:00Z" - need to convert to DateTime using (DiaryContainer ent = new DiaryContainer()) { var rec = ent.AppointmentDiary.FirstOrDefault(s => s.ID == id); if (rec != null) { DateTime DateTimeStart = DateTime.Parse(NewEventStart, null, DateTimeStyles.RoundtripKind).ToLocalTime(); // and convert offset to localtime rec.DateTimeScheduled = DateTimeStart; if (!String.IsNullOrEmpty(NewEventEnd)) { TimeSpan span = DateTime.Parse(NewEventEnd, null, DateTimeStyles.RoundtripKind).ToLocalTime() - DateTimeStart; rec.AppointmentLength = Convert.ToInt32(span.TotalMinutes); } ent.SaveChanges(); } } }
public static bool CreateNewEvent(string Title, string NewEventDate, string NewEventTime, string NewEventDuration) { try { DiaryContainer ent = new DiaryContainer(); AppointmentDiary rec = new AppointmentDiary(); rec.Title = Title; rec.DateTimeScheduled = DateTime.ParseExact(NewEventDate + " " + NewEventTime, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); rec.AppointmentLength = Int32.Parse(NewEventDuration); ent.AppointmentDiary.Add(rec); ent.SaveChanges(); } catch (Exception) { return(false); } return(true); }
public ActionResult Create(RegisterViewModel icmb) { if (ModelState.IsValid) { var member = new IcomMembers { Country = icmb.Country, FullName = icmb.FullName, State = icmb.State, Address = icmb.Address, City = icmb.City, DOB = icmb.DOB, Email = icmb.Email, Phone = icmb.Phone, PostalCode = icmb.PostalCode }; member.DateRegistered = DateTime.Now; db.IcomMembers.Add(member); db.SaveChanges(); //var dOB = member.DOB; //var fullName = member.FullName; //db.FamilyMembers.Add(new FamilyMembers { DOB = dOB, FullName = fullName, IcomMembersId = member.IcomMembersId, DateAdded = DateTime.Now }); //db.SaveChanges(); icmb.Family = icmb.Family.Concat(new List <FamilyViewModel>() { new FamilyViewModel { FamilyDOB = member.DOB, FamilyFullName = member.FullName, IncIndex = 1, IsPrimary = true } }); //mList.Add icmb.IcomMembersId = member.IcomMembersId; SaveFamilies(icmb.IcomMembersId, icmb.Family); Response.Redirect("https://services.madinaapps.com/donation/clients/icom/paymentOptions/308"); } return(View(icmb)); }
public ActionResult SaveSalaat(string Fajr, string Dhuhr, string Asr, string Maghrib, string Isha, string Khutbah1, string Khutbah2, string Jumma1, string Jumma2) { var Sataals = db.Salaat.FirstOrDefault(); Sataals.Asr = Asr; Sataals.Fajr = Fajr; Sataals.DateAdded = DateTime.Now; Sataals.Dhuhr = Dhuhr; Sataals.Maghrib = Maghrib; Sataals.Isha = Isha; Sataals.Khutbah1 = Khutbah1; Sataals.Jumma1 = Jumma1; Sataals.Khutbah2 = Khutbah2; Sataals.Jumma2 = Jumma2; db.Entry(Sataals).State = EntityState.Modified;// System.Data.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SetSalaat")); }
public static void UpdateDiaryEvent(int id, string NewEventStart, string NewEventEnd) { // EventStart comes ISO 8601 format, eg: "2000-01-10T10:00:00Z" - need to convert to DateTime using (DiaryContainer ent = new DiaryContainer()) { var rec = ent.AppointmentDiary.FirstOrDefault(s => s.ID == id); if (rec != null) { DateTime DateTimeStart = DateTime.Parse(NewEventStart, null, DateTimeStyles.RoundtripKind).ToLocalTime(); // and convert offset to localtime rec.DateTimeScheduled = DateTimeStart; if (!String.IsNullOrEmpty(NewEventEnd)) { TimeSpan span = DateTime.Parse(NewEventEnd, null, DateTimeStyles.RoundtripKind).ToLocalTime() - DateTimeStart; rec.AppointmentLength = Convert.ToInt32(span.TotalMinutes); } ent.SaveChanges(); } } }
public static bool CreateNewEvent(string Title, string NewEventDate, string NewEventTime, string NewEventDuration) { try { DiaryContainer ent = new DiaryContainer(); AppointmentDiary rec = new AppointmentDiary(); rec.Title = Title; rec.DateTimeScheduled = DateTime.ParseExact(NewEventDate + " " + NewEventTime, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); rec.AppointmentLength = Int32.Parse(NewEventDuration); ent.AppointmentDiary.Add(rec); ent.SaveChanges(); } catch (Exception) { return false; } return true; }