public ActionResult DeleteEvent(int id)
{
EventDBEntities _db = new EventDBEntities();
var Model = _db.Events.Where(e => e.EventID == id).FirstOrDefault();
//Set admin id here
SendEmail("*****@*****.**", Model.EventTitle + " Deleted", "Your event has been deleted");
Models.Event myEvent = (Models.Event)_db.Events.Where(y => y.EventID == id).FirstOrDefault();
if (myEvent.EventDate >= DateTime.Today && myEvent.Volunteers != null)
{
var volunteers = myEvent.Volunteers.ToList();
foreach (var volunteer in volunteers)
{
AdminUnScheduleVolunteer((int)volunteer.ID, id);
}
}
//have to do this AFTER emailing volunteers
EventSPEntities x = new EventSPEntities();
x.Delete_Event(id);
return(new EmptyResult());
}
public ActionResult AdminUnScheduleVolunteer(int volunteerID, int eventID)
{
ScheduleVolunteerDBEntities x = new ScheduleVolunteerDBEntities();
x.unSchedule_Volunteer(volunteerID, eventID);
EventDBEntities _Edb = new EventDBEntities();
var events = _Edb.Events.ToList();
Models.Event myEvent = (Models.Event)(events.Where(y => y.EventID == eventID).FirstOrDefault());
VolunteersDBEntities _Vdb = new VolunteersDBEntities();
var volunteers = _Vdb.Volunteers.ToList();
Models.Volunteer myVolunteer = (Models.Volunteer)(volunteers.Where(z => z.ID == volunteerID).FirstOrDefault());
//notify volunteer of schedule change
SmtpClient client = new SmtpClient();
MailMessage notifyVolunteer = new MailMessage();
notifyVolunteer.Subject = "You have been unscheduled from an event at the Challenged Champions Equestrian Center";
notifyVolunteer.Body = "This is an automated message informing you that an administrator has unscheduled you from the following event: "
+ myEvent.EventTitle + " on " + myEvent.EventDate.ToString("MM-dd-yyyy")
+ ". Please check the \"My Schedule\" portion of the volunteer website to review your schedule.";
notifyVolunteer.To.Add(myVolunteer.Email);
client.Send(notifyVolunteer);
return(new EmptyResult());
}
public List <UserEntity> Get()
{
List <UserEntity> list = new List <UserEntity>();
using (var db = new EventDBEntities())
{
var records = db.UserMasters.Where(x => x.IsActive == true).ToList();
foreach (var item in records)
{
UserEntity userentity = new UserEntity();
userentity.Id = item.Id;
userentity.Fullname = item.Fullname;
UserTypeEntity usertypeentity = new UserTypeEntity();
if (item.UserTypeMaster != null)
{
usertypeentity.Id = item.UserTypeMaster.Id;
usertypeentity.Usertype = item.UserTypeMaster.Usertype;
userentity.UserTypeMaster = usertypeentity;
}
list.Add(userentity);
}
}
return(list);
}
public ActionResult UpdateSave(Equipment euq)
{
using (EventDBEntities db = new EventDBEntities())
{
Equipment e = new Equipment();
e.EquipmentName = euq.EquipmentName;
e.EquipmentID = euq.EquipmentID;
e.EquipmentCost = euq.EquipmentCost;
if (euq.ImageFile == null)
{
db.Equipments.Attach(e);
db.Entry(e).Property(x => x.EquipmentCost).IsModified = true;
db.Entry(e).Property(x => x.EquipmentName).IsModified = true;
}
else
{
string FName = euq.ImageFile.FileName;
euq.ImageFile.SaveAs(Server.MapPath("~/UploadImage/" + FName));
e.EquipmentFilename = euq.ImageFile.FileName.ToString();
db.Entry(e).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("List"));
}
}
public ActionResult UpdateData(VenueViewModel vvm)
{
using (EventDBEntities db = new EventDBEntities())
{
if (vvm.imageFile != null)
{
vvm.imageFile.SaveAs(Server.MapPath("~/UploadImage/" + vvm.imageFile.FileName));
}
Venue v = new Venue();
v.VenueCost = vvm.VenueCost;
v.VenueID = vvm.VenueID;
v.VenueName = vvm.VenueName;
if (vvm.imageFile != null)
{
v.VenueFilePath = vvm.imageFile.FileName.ToString();
v.VenueFilename = vvm.VenueFilename;
db.Entry(v).State = EntityState.Modified;
}
else
{
db.Venues.Attach(v); // No Need to Add during Update ..this is only used when we want update specific propery
db.Entry(v).Property(x => x.VenueCost).IsModified = true; //this is only used when we want update specific propery
db.Entry(v).Property(x => x.VenueName).IsModified = true;
}
//db.Venues.Attach(v);// No Need to Add during Update
db.SaveChanges();
return(RedirectToAction("List"));
}
}
public List <EventEntryEntity> Get(int userid)
{
List <EventEntryEntity> list = new List <EventEntryEntity>();
using (var db = new EventDBEntities())
{
var records = db.EventEntryMasters.Where(x => x.IsActive == true).ToList();
foreach (var item in records)
{
EventEntryEntity entity = new EventEntryEntity();
entity.Id = item.Id;
entity.TotalAmount = item.TotalAmount;
entity.Eventdate = item.Eventdate;
EventEntity event_ = new EventEntity();
if (item.EventMaster != null)
{
event_.Id = item.EventMaster.Id;
event_.Eventname = item.EventMaster.Eventname;
entity.EventMaster = event_;
}
var isexist = db.EventCustomers.Where(x => x.Eventcustomerid == userid && x.Evententryid == item.Id).FirstOrDefault();
if (isexist != null)
{
list.Add(entity);
}
}
}
return(list);
}
public ActionResult List()
{
using (EventDBEntities db = new EventDBEntities())
{
var Euipmentlist = (from x in db.Equipments select x).ToList();
return(View(Euipmentlist));
}
}
// POST: api/VenueApi
public void Post(BookingVenue bv)
{
using (EventDBEntities db = new EventDBEntities())
{
db.BookingVenues.Add(bv);
db.SaveChanges();
}
}
public JsonResult CityList(int id)
{
using (EventDBEntities db = new EventDBEntities())
{
var CityList = new SelectList(db.Cities.Where(x => x.StateID == id).ToList(), "CityID", "CityName");
return(Json(CityList, JsonRequestBehavior.AllowGet));
}
}
public JsonResult StateList(int id)
{
using (EventDBEntities db = new EventDBEntities())
{
var State = new SelectList(db.States.Where(x => x.CountryID == id).ToList(), "StateID", "StateName");
return(Json(State, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetEventDetail(int id)
{
EventDBEntities _db = new EventDBEntities();
var EventList = _db.Events.ToList();
var Model = EventList.Where(x => x.EventID == id).FirstOrDefault();
return(PartialView("CopyEventPartial", Model));
}
public ActionResult Edit(int id)
{
using (EventDBEntities db = new EventDBEntities())
{
var equdata = (from x in db.Equipments where x.EquipmentID == id select x).FirstOrDefault();
equdata.EquipmentFilename = "~/UploadImage/" + equdata.EquipmentFilename;
return(View(equdata));
}
}
public ActionResult Save(Registration reg)
{
using (EventDBEntities db = new EventDBEntities())
{
db.Registrations.Add(reg);
db.SaveChanges();
}
return(View("Register"));
}
public ActionResult List()
{
using (EventDBEntities db = new EventDBEntities())
{
var vanues = (from x in db.Venues select x).ToList();
return(View(vanues));
}
}
public bool Update(EventEntryEntity entity)
{
bool isupdated = false;
using (var db = new EventDBEntities())
{
}
return(isupdated);
}
public List <CreditStatemententity> Getcreditstatement(int?id, int userid)
{
List <CreditStatemententity> list = new List <CreditStatemententity>();
if (id != null)
{
using (var db = new EventDBEntities())
{
var records = db.EventCustomers.Where(x => x.Evententryid == id).ToList();
if (records.Count > 1)
{
var noofcustomers = records.Count;
var totalamount = db.EventEntryMasters.Find(id).TotalAmount;
var userpaidamt = records.Where(x => x.Eventcustomerid == userid).FirstOrDefault().Paidamount;
records = records.Where(x => x.Eventcustomerid != userid).ToList();
var equalamt = totalamount / noofcustomers;
if (userpaidamt < equalamt)//if user paid less than divided amt
{
var userremainpaidamt = equalamt - userpaidamt;
foreach (var item in records)
{
CreditStatemententity entity = new CreditStatemententity();
if (item.Paidamount > equalamt)
{
if (userremainpaidamt > 0)
{
var creditpaidamt = item.Paidamount - equalamt;
if (userremainpaidamt <= creditpaidamt)
{
entity.creditamount = (decimal)userremainpaidamt;
entity.creditby = item.UserMaster.Fullname;
list.Add(entity);
userremainpaidamt = 0;
break;
}
else
{
userremainpaidamt = userremainpaidamt - creditpaidamt;
entity.creditamount = (decimal)creditpaidamt;
entity.creditby = item.UserMaster.Fullname;
list.Add(entity);
}
}
}
}
}
}
}
}
return(list);
}
public EventEntity Getbyid(int id)
{
EventEntity entity = new EventEntity();
using (var db = new EventDBEntities())
{
var record = db.EventMasters.Find(id);
entity.Eventname = record.Eventname;
}
return(entity);
}
public ActionResult Add()
{
using (EventDBEntities db = new EventDBEntities())
{
var VenueList = new SelectList((from x in db.Venues select new { x.VenueID, x.VenueName }).ToList(), "VenueID", "VenueName");
ViewBag.Venuelist = VenueList;
var EventList = new SelectList((from x in db.Events select new { x.EventID, x.EventType }).ToList(), "EventID", "EventType");
ViewBag.EventList = EventList;
}
return(View());
}
public bool Delete(int id)
{
bool isdeleted = false;
using (var db = new EventDBEntities())
{
var record = db.EventMasters.Find(id);
record.IsActive = false;
db.SaveChanges();
isdeleted = true;
}
return(isdeleted);
}
public bool Delete(long id)
{
bool deleted = false;
using (var db = new EventDBEntities())
{
var record = db.BillSettlementmasters.Find(id);
record.IsActive = false;
db.SaveChanges();
deleted = true;
}
return(deleted);
}
public ActionResult UnScheduleVolunteer(int id)
{
EventDBEntities _db = new EventDBEntities();
var Model = _db.Events.Where(e => e.EventID == id).FirstOrDefault();
Volunteer v = Model.Volunteers.FirstOrDefault();
//Set admin email here
SendEmail("*****@*****.**", Model.EventTitle + " Decommitted", v.FirstName.Trim() + " " + v.LastName.Trim() + " has decommitted from the " + Model.EventTitle + "event | The event is scheduled for" + Model.EventDate.ToLongDateString());
ScheduleVolunteerDBEntities x = new ScheduleVolunteerDBEntities();
x.unSchedule_Volunteer(Convert.ToInt32(currentUser), id); //we need to revisit inconsistencies in DB with bigint / int for id column datatypes
return(new EmptyResult());
}
// GET: Register
public ActionResult Register()
{
using (EventDBEntities db = new EventDBEntities())
{
var country = new SelectList(db.Countries.ToList(), "CountryID", "Name");
ViewBag.countrylist = country;
var role = new SelectList(db.Roles.ToList(), "RoleID", "Rolename");
ViewBag.Rolelist = role;
}
return(View());
}
public ActionResult save(Food Foo)
{
if (Request.Files.Count > 0)
{
Foo.ImageFile.SaveAs(Server.MapPath("~/UploadImage/" + Foo.ImageFile.FileName.ToString()));
Foo.FoodFilePath = Foo.ImageFile.FileName.ToString();
Foo.FoodFilename = Foo.ImageFile.FileName.ToString();
}
using (EventDBEntities db = new EventDBEntities())
{
db.Foods.Add(Foo);
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public bool Update(EventEntity entity)
{
bool isupdated = false;
using (var db = new EventDBEntities())
{
var record = db.EventMasters.Find(entity.Id);
record.Eventname = entity.Eventname;
record.Updatedate = entity.Updatedate;
record.Updatedby = entity.Updatedby;
db.SaveChanges();
isupdated = true;
}
return(isupdated);
}
public UserEntity Authenticateuser(LoginEntity entity)
{
UserEntity user = new UserEntity();
using (var db = new EventDBEntities())
{
var record = db.UserMasters.Where(x => x.Username == entity.UserName && x.password == entity.Password && x.IsActive == true).FirstOrDefault();
if (record != null)
{
user = Map(record);
}
}
return(user);
}
public ActionResult Edit(int Id)
{
using (EventDBEntities db = new EventDBEntities())
{
var v = (from x in db.Venues where x.VenueID == Id select new { x.VenueCost, x.VenueFilename, x.VenueID, x.VenueName, x.VenueFilePath }).FirstOrDefault();
VenueViewModel vvm = new VenueViewModel();
vvm.VenueCost = v.VenueCost;
vvm.VenueFilename = v.VenueFilename;
vvm.VenueName = v.VenueName;
vvm.VenueFilePath = "~/UploadImage/" + v.VenueFilePath;
vvm.VenueID = v.VenueID;
return(View("Edit", vvm));
}
}
public Billsettlemententity getbyid(long id)
{
Billsettlemententity entity = new Billsettlemententity();
using (var db = new EventDBEntities())
{
var record = db.BillSettlementmasters.Find(id);
entity.Entrydate = record.Entrydate;
entity.Creditedfrom = record.Creditedfrom;
entity.Creditamount = record.Creditamount;
entity.Paidamount = record.Paidamount;
entity.Paidby = record.Paidby;
}
return(entity);
}
public ActionResult List()
{
using (EventDBEntities db = new EventDBEntities())
{
var Dishtypelist = Enum.GetValues(typeof(DishtypeList)).Cast <DishtypeList>()
.Select(r => new { Value = (int)r, Name = r.ToString() }).ToList();
var MealtypeList = Enum.GetValues(typeof(MealtypeList)).Cast <MealtypeList>()
.Select(r => new { Value = (int)r, Name = r.ToString() }).ToList();
var FoodtypeList = Enum.GetValues(typeof(FoodtypeList)).Cast <FoodtypeList>()
.Select(r => new { Value = (int)r, Name = r.ToString() }).ToList();
var Foodlist = (from x in db.Foods select x).ToList();
var result1 = from t in Foodlist
join x in Dishtypelist on t.DishType equals x.Value
join y in FoodtypeList on Convert.ToInt32(t.FoodType) equals y.Value
join z in MealtypeList on Convert.ToInt32(t.MealType) equals z.Value
select new FoodViewModel
{
FoodID = t.FoodID, FoodName = t.FoodName, DishType = x.Name, FoodType = y.Name, MealType = z.Name, FoodFilePath = t.FoodFilePath, FoodFilename = t.FoodFilePath, FoodCost = t.FoodCost
};
return(View("List", result1.ToList()));
//One other Way
//Dictionary<int, string> DicRoles = new Dictionary<int, string>();
//var vals = Enum.GetValues(typeof(Dishtype));
//foreach (var val in vals)
//{
// DicRoles.Add((int)val, val.ToString());
//}
//var result = from t in Foodlist
// join x in DicRoles on t.DishType equals x.Key
// select new { t.FoodName , dishtype=x.Value };
}
}
static void Main(string[] args)
{
Console.WriteLine("Synchronization service started @{0}.", DateTime.Now);
try
{
while (true)
{
using (EventDBEntities _dbContext = new EventDBEntities())
{
Handler.EventHandler handler = new Handler.EventHandler();
List <Event> unSynchronizedEvents = _dbContext.Event.Where(t => !t.Synchronized && t.FailedTimes < 3).OrderBy(t => t.Id).ToList();
if (unSynchronizedEvents.Count > 0)
{
foreach (Event @event in unSynchronizedEvents)
{
try
{
Assembly assembly = Assembly.Load("Events");
Type type = assembly.GetType(@event.EventType);
object obj = JsonConvert.DeserializeObject(@event.Data, type);
handler.Handle(obj);
@event.Synchronized = true;
Console.WriteLine("AggregateRootId:{0},EventType:{1},Version:{2}", @event.AggregateRootId, @event.EventType, @event.Version);
}
catch (Exception ex)
{
@event.FailedTimes++;
@event.FailedReason = ex.Message;
}
_dbContext.Entry(@event).State = EntityState.Modified;
_dbContext.SaveChanges();
}
}
Thread.Sleep(5000); //每隔5秒执行一次
}
}
}
catch (Exception ex)
{
throw;
}
}
public bool Insert(EventEntity entity)
{
bool isinserted = false;
using (var db = new EventDBEntities())
{
EventMaster record = new EventMaster();
record.Id = entity.Id;
record.Eventname = entity.Eventname;
record.Createddate = entity.Createddate;
record.IsActive = true;
record.Createdby = entity.Createdby;
db.EventMasters.Add(record);
db.SaveChanges();
isinserted = true;
}
return(isinserted);
}
