public RecordDto Add(RecordDto dto)
{
var item = new Record()
{
UserId = dto.UserId,
RecordDate = dto.RecordDate,
};
_dao.Create(item);
_record2ProcedureDao.CreateRange(dto.Record2Procedure.Select(x => new Record2Procedure()
{
IdRecord = item.Id, IdProcedure = x.IdProcedure
}));
return(_map(item));
}
public PriceCostDto UpdatePriceCost(MonthReportDto monthReport, int year, int month)
{
var newPriceCost = new PriceCost()
{
Type = monthReport.Type,
Procedure = monthReport.Procedure,
DateEnd = new DateTime(year, month, 1).AddMonths(1).AddDays(-1),
Value = monthReport.CostPrice,
};
var dbPriceCost = _priceCostDao.Get(
x => x.Procedure == newPriceCost.Procedure && x.Type == newPriceCost.Type && x.DateEnd == newPriceCost.DateEnd);
if (dbPriceCost.Any())
{
if (dbPriceCost.Count == 1)
{
var dbPriceCostOld = dbPriceCost.First();
dbPriceCostOld.Value = newPriceCost.Value;
_priceCostDao.Update(dbPriceCostOld);
return(_map(dbPriceCostOld));
}
else
{
throw new Exception("Найдено больше одной себестоимости!");
}
}
else
{
_priceCostDao.Create(newPriceCost);
return(_map(newPriceCost));
}
}
public CheckDto Add(CheckDto dto)
{
var item = new Check()
{
RecordId = dto.RecordId,
Price = dto.Price,
Comment = dto.Comment,
};
_dao.Create(item);
_check2BaseDao.CreateRange(dto.Check2Base.Select(x => new Check2Base()
{
IdCheck = item.Id, IdBase = x.IdBase, Comment = x.Comment
}));
_check2ColorDao.CreateRange(dto.Check2Color.Select(x => new Check2Color()
{
IdCheck = item.Id, IdColor = x.IdColor, Comment = x.Comment
}));
_check2TopDao.CreateRange(dto.Check2Top.Select(x => new Check2Top()
{
IdCheck = item.Id, IdTop = x.IdTop, Comment = x.Comment
}));
_check2DesignDao.CreateRange(dto.Check2Design.Select(x => new Check2Design()
{
IdCheck = item.Id, IdDesign = x.IdDesign, Comment = x.Comment, Count = x.Count
}));
return(_map(item));
}
/// <summary>
/// <li>The new game is first time saving, change status and let it to
/// DB.</li><li>The ongoing game is serialize to a xml that named with
/// user id.It does not need to connect DB every time. But the ongoing
/// game may only be one for a free account.</li><li>The completed game
/// is saving to DB.</li>
/// </summary>
/// <param name="f">A futoshiki object</param>
/// <returns>bool</returns>
public bool Save(Futoshiki f)
{
bool isSaved = false;
int affectedRows;
switch (f.Status)
{
case (int)Futoshiki.Mode.New:
f.Status = (int)Futoshiki.Mode.Ongoing;
affectedRows = _dao.Create(f);
isSaved = affectedRows == f.Length ? true : false;
break;
case (int)Futoshiki.Mode.Ongoing:
// serialize game for current user.
isSaved = XmlHelper.Serialize(f, f.Uid, XmlHelper.U,
f.Scale.ToString());
MoveSolution(f.Id);
break;
case (int)Futoshiki.Mode.Completed:
affectedRows = _dao.Update(f);
isSaved = -1 < affectedRows ? true : false;
if (isSaved)
{ // delete cached futoshiki
XmlHelper.Del(f.Uid, XmlHelper.U, f.Scale.ToString());
}
break;
default:
break;
}
return(isSaved);
}
public BaseDto Add(BaseDto dto)
{
var item = new Base()
{
Name = dto.Name,
Comment = dto.Comment,
};
_dao.Create(item);
return(_map(item));
}
public ColorDto Add(ColorDto dto)
{
var item = new Color()
{
Name = dto.Name,
Comment = dto.Comment,
};
_dao.Create(item);
return(_map(item));
}
public TopDto Add(TopDto dto)
{
var item = new Top()
{
Name = dto.Name,
Comment = dto.Comment,
};
_dao.Create(item);
return(_map(item));
}
public ProcedureDto Add(ProcedureDto dto)
{
var item = new Procedure()
{
Name = dto.Name,
ShortName = dto.ShortName,
Price = dto.Price,
PriceVip = dto.PriceVip,
};
_dao.Create(item);
return(_map(item));
}
public DesignDto Add(DesignDto dto)
{
var item = new Design()
{
Name = dto.Name,
Comment = dto.Comment,
Price = dto.Price,
PriceVip = dto.PriceVip,
};
_dao.Create(item);
return(_map(item));
}
public PriceCostDto Add(PriceCostDto dto)
{
var item = new PriceCost()
{
Procedure = dto.Procedure,
Type = dto.Type,
Value = dto.Value,
DateEnd = dto.DateEnd,
};
_dao.Create(item);
return(_map(item));
}
public UserDto Add(UserDto dto)
{
var item = new User()
{
Name = dto.Name,
Phone = dto.Phone,
CommunicationType = dto.CommunicationType,
Comment = dto.Comment,
Vip = dto.Vip,
};
_dao.Create(item);
return(_map(item));
}
public int?ValidCreate(T item, int?userId, IDao <T> dao)
{
switch (userId)
{
case 0:
return(userId);
case null:
return(null);
default:
return(dao.Create(item, (int)userId));
}
}
public void Save(TEntity entity, params Func <TEntity, object>[] keys)
{
var result = true;
foreach (var item in keys)
{
if (entity.GetType().GetProperty(item.GetType().Name) == null)
{
result = false;
}
}
if (result)
{
_dao.Create(entity);
}
else
{
_dao.Update(entity);
}
}
public string CreateEducation(EducationDto educationDto)
{
string returnMessage;
var education = educationDto.ToEntity();
if (education.Id > 0)
{
_educationDao.Update(education);
returnMessage = "Education updated";
}
else
{
_educationDao.Create(education);
returnMessage = "Education created";
}
_educationDao.Commit();
return(returnMessage);
}
public string CreateProject(ProjectDto projectDto)
{
string returnMessage;
var project = projectDto.ToEntity();
if (project.Id > 0)
{
_projectDao.Update(project);
returnMessage = "Project updated";
}
else
{
_projectDao.Create(project);
returnMessage = "Project created";
}
_projectDao.Commit();
return(returnMessage);
}
public string CreateSkill(SkillDto skillDto)
{
string returnMessage;
var skill = skillDto.ToEntity();
if (skill.Id > 0)
{
_skillsDao.Update(skill);
returnMessage = "Skill updated";
}
else
{
_skillsDao.Create(skill);
returnMessage = "Skill created";
}
_skillsDao.Commit();
return(returnMessage);
}
public string CreateExperience(ExperienceDto experienceDto)
{
string returnMessage;
var experience = experienceDto.ToEntity();
if (experience.Id > 0)
{
_experienceDao.Update(experience);
returnMessage = "Work updated";
}
else
{
_experienceDao.Create(experience);
returnMessage = "Work created";
}
_experienceDao.Commit();
return(returnMessage);
}