protected override Task <bool> ExecuteAsync(PipelineContext context)
{
if (_huangliScheduler.Pop() is HuangliMonth model)
{
var year = model.Date.Year;
var month = model.Date.Month.ToString().PadLeft(2, '0');
foreach (var day in model.resultList)
{
CalendarEntity entity = new CalendarEntity();
entity.LunarDate = day.Nongli;
entity.GregorianDate = DateTime.Parse($"{year}/{month}/{day.Day.ToString().PadLeft(2,'0')}");
entity.SolarTerms = day.JieQi;
entity.TraditionFestival = day.JieRi;
entity.SuitableDo = day.Yi;
entity.TabooDo = day.Ji;
entity.TraditionLunarDate = day.GanZhi;
fsql.InsertOrUpdate <CalendarEntity>().SetSource(entity).ExecuteAffrows();
}
Logger.Info($"数据库插入成功");
}
return(Task.FromResult(false));
}
protected override void Seed(WebCalendar.DAL.Context.WebCalendarContext context)
{
CalendarEntity cal = new CalendarEntity {
CalendarID = 1, Title = "MVC", /*Date = new DateTime(2017, 03, 15), */ Description = "Learn Asp.Net MVC"
};
EventEntity ev = new EventEntity {
EventID = 1, Title = "To-Do List", Description = "Create a Asp.Net Mvc application with database", CalendarID = 1, BeginTime = new DateTime(2017, 03, 16), EndTime = new DateTime(2017, 03, 20), EventColor = "#f44842", EveryMonth = true
};
EventEntity ev1 = new EventEntity {
EventID = 2, Title = "JS", Description = "Write functions", CalendarID = 1, BeginTime = new DateTime(2017, 03, 16), EndTime = new DateTime(2017, 03, 20), EventColor = "#f44842", EveryMonth = true
};
EventEntity ev2 = new EventEntity {
EventID = 3, Title = "Chat", Description = "Create a simple chat", CalendarID = 1, BeginTime = new DateTime(2017, 04, 16), EndTime = new DateTime(2017, 04, 25), EventColor = "#f44842", EveryMonth = true
};
EventEntity ev3 = new EventEntity {
EventID = 4, Title = "User Authorization", Description = "Registration and Login", CalendarID = 1, BeginTime = new DateTime(2017, 01, 05), EndTime = new DateTime(2017, 05, 8), EventColor = "#f44842", EveryMonth = true
};
cal.Events.Add(ev);
cal.Events.Add(ev1);
cal.Events.Add(ev2);
cal.Events.Add(ev3);
context.Calendars.AddOrUpdate(cal);
context.Events.AddOrUpdate(ev, ev1, ev2, ev3);
}
public static void Map(CalendarEntity to, Calendar from)
{
to.CalendarID = from.ID;
to.Title = from.Title;
to.UserID = from.UserID;
to.Description = from.Description;
}
public void Add(Calendar cal)
{
var entity = new CalendarEntity();
DomainToDal.Map(entity, cal);
this.dal.Add(entity);
this.unitOfWork.Commit();
cal.ID = entity.ID;
}
public void Delete(int id)
{
CalendarEntity entity = this.dal.Find(id);
if (entity != null)
{
this.dal.Attach(entity);
this.dal.Remove(entity);
this.unitOfWork.Commit();
}
}
public void Delete(int id)
{
CalendarEntity entity = this.dal.Find(id);
if (entity == null)
{
throw new ArgumentNullException("entity");
}
this.dal.Attach(entity);
this.dal.Remove(entity);
this.unitOfWork.Commit();
}
public void Add(Calendar cal)
{
if (cal == null)
{
throw new ArgumentNullException("entity");
}
var entity = new CalendarEntity();
DomainToDal.Map(entity, cal);
this.dal.Add(entity);
this.unitOfWork.Commit();
this.unitOfWork.Dispose();
}
protected override void Seed(WebCalendar.DAL.Context.WebCalendarContext context)
{
CalendarEntity cal = new CalendarEntity {
ID = 1, Title = "My First Calendar"
};
EventEntity ev = new EventEntity {
ID = 1, Description = "First Event", StartDate = new DateTime(2017, 02, 03), EndDate = new DateTime(2017, 03, 03), CalendarID = 1
};
cal.Events.Add(ev);
context.Calendars.AddOrUpdate(cal);
context.Events.AddOrUpdate(ev);
}
public async Task <CalendarEntity> Add(string name)
{
using (var ctx = _context.Create())
{
ctx.Open();
var calendar = new CalendarEntity
{
Name = name
};
var insertSql = @"INSERT INTO Calendar.Calendar (Name) VALUES (@name) RETURNING Id";
var id = await ctx.ExecuteScalarAsync <int>(insertSql, calendar);
calendar.Id = id;
return(calendar);
}
}
public void Update(Calendar entity)
{
var newEntity = new CalendarEntity();
DomainToDal.Map(newEntity, entity);
if (entity.ID == 0)
{
dal.Add(newEntity);
}
else
{
CalendarEntity cal = dal.Find(entity.ID);
if (cal != null)
{
cal.Title = newEntity.Title;
}
}
this.unitOfWork.Commit();
}
public void Update(Calendar entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
var newEntity = new CalendarEntity();
DomainToDal.Map(newEntity, entity);
if (entity.ID == Constants.NEW_DATABASE_ID_VALUE)
{
dal.Add(newEntity);
}
else
{
CalendarEntity cal = dal.Find(entity.ID);
cal.Title = newEntity.Title;
cal.Description = newEntity.Description;
}
this.unitOfWork.Commit();
this.unitOfWork.Dispose();
}
public static IObservable <StateChange <CalendarEntity, EntityState <CalendarAttributes> > > StateAllChangesWithCurrent(this CalendarEntity entity)
{
return(entity.StateAllChangesWithCurrent <CalendarEntity, EntityState <CalendarAttributes>, CalendarAttributes>());
}
public static void Map(CalendarEntity to, Calendar from)
{
to.ID = from.ID;
to.Title = from.Title;
}
public static Calendar Map(CalendarEntity to)
{
return(new Calendar {
ID = to.ID, Title = to.Title
});
}
public static Calendar Map(CalendarEntity to)
{
return(new Calendar {
ID = to.CalendarID, Title = to.Title, UserID = to.UserID, Description = to.Description
});
}
