public ParticipationWindowViewModel(ParticipationModel c)
{
db = new DBOperations();
d = new Data();
p = c;
d.Employees = db.GetAllEmployees();
d.Roles = db.GetAllRoles();
}
public static ParticipationModel ToModel(this Participation dto)
{
ParticipationModel result = new ParticipationModel();
result.Id = dto.Id;
result.EpreuveId = dto.EpreuveId;
result.ParticipantId = dto.ParticipantId;
result.Prenom = dto.Participant.Prenom;
result.Nom = dto.Participant.Nom;
return(result);
}
private void AddParticipation(object obj)
{
sel_part = new ParticipationModel();
ParticipationWindow cw = new ParticipationWindow(sel_part);
if (cw.ShowDialog() == true)
{
sel_part.Project_ID = Pr.ID;
db.AddParticipation(sel_part);
db.Save();
d1.Participations = db.GetAllParticipations(Pr.ID);
}
}
public static Participation ToDTO(this ParticipationModel model)
{
Participation participation = new Participation();
if (model.Id != 0)
{
participation.Id = model.Id;
}
participation.EpreuveId = model.EpreuveId;
participation.ParticipantId = model.ParticipantId;
return(participation);
}
public static ParticipationTechniqueModel ConvertToTechnique(this ParticipationModel input)
{
var result = new ParticipationTechniqueModel();
result.ParticipantId = input.ParticipantId;
result.ClubId = input.ClubId;
result.Club = input.Club;
result.EpreuveId = input.EpreuveId;
result.Nom = input.Nom;
result.Prenom = input.Prenom;
return(result);
}
public static ParticipationCombatModel ConvertToCombat(this ParticipationModel input)
{
var result = new ParticipationCombatModel();
result.CategoriePratiquantId = input.CategoriePratiquantId;
result.ParticipantId = input.ParticipantId;
result.ClubId = input.ClubId;
result.Club = input.Club;
result.EpreuveId = input.EpreuveId;
result.Nom = input.Nom;
result.Prenom = input.Prenom;
result.Id = input.Id;
result.Vainqueur = null;
return(result);
}
public static ParticipationModel ToPresentielModel(this Competiteur dto, int epreuveId, bool present)
{
ParticipationModel result = new ParticipationModel();
result.ParticipantId = dto.Id;
result.CategoriePratiquantId = dto.CategoriePratiquantId;
result.Nom = dto.Nom;
result.Prenom = dto.Prenom;
result.Present = present;
result.EpreuveId = epreuveId;
result.ClubId = dto.ClubId;
if (dto.Club != null)
{
result.Club = dto.Club.Nom;
}
return(result);
}
public JsonResult Get()
{
if (this.participantRepository == null)
{
this.participantRepository = unitOfWork.Repository <Participant>();
}
var result = new JsonResult();
var dispo = this.participantRepository.Read();
var local = this.repository.Read().Select(enc => enc.ToModel());
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
List <EpreuveVentileeModel> models = new List <EpreuveVentileeModel>();
foreach (ParticipationModel model in local)
{
var found = models.FirstOrDefault(m => m.EpreuveId == model.EpreuveId);
if (found == null)
{
EpreuveVentileeModel epreuveVentilee = new EpreuveVentileeModel();
epreuveVentilee.EpreuveId = model.EpreuveId;
ParticipationModel participation = new ParticipationModel();
participation.EpreuveId = model.EpreuveId;
participation.Nom = model.Nom;
participation.ParticipantId = model.ParticipantId;
participation.Prenom = model.Prenom;
epreuveVentilee.ParticipationModels.Add(participation);
models.Add(epreuveVentilee);
}
else
{
ParticipationModel participation = new ParticipationModel();
participation.EpreuveId = model.EpreuveId;
participation.Nom = model.Nom;
participation.ParticipantId = model.ParticipantId;
participation.Prenom = model.Prenom;
found.ParticipationModels.Add(participation);
}
}
result.Data = models;
return(result);
}
public ParticipationModel CountToParticipation(int id = 0)
{
ParticipationModel model = new ParticipationModel();
model.CountChannelManager = 0; model.CountChannelOwner = 0; model.CountComments = 0; model.CountTopics = 0;
model.HundredFollowers = 0; model.FiftyFollowers = 0;
using (var db = DatabaseFactory.OpenDbConnection())
{
if (id == 0)
{
id = NimbusUser.UserId;
}
model.CountChannelOwner = db.Where <Role>(r => r.UserId == id && r.IsOwner == true).Count();
model.CountChannelManager = db.Where <Role>(r => r.IsOwner == false && r.UserId == id && r.Accepted == true)
.Select(c => c.ChannelMagager == true || c.MessageManager == true ||
c.ModeratorManager == true || c.TopicManager == true || c.UserManager == true)
.Count();
model.CountTopics = db.Where <Topic>(t => t.Visibility == true && t.AuthorId == id).Count();
model.CountComments = db.Where <Comment>(c => c.UserId == id && c.Visible == true).Where(c => c != null).Count();
model.FiftyFollowers = db.SqlScalar <int>(@"SELECT COUNT(*) AS [value]
FROM [Channel] AS [CH]
WHERE (((
SELECT COUNT(*)
FROM [ChannelUser] AS [CS]
WHERE ([CS].[ChannelId] = [CH].[Id]) AND ([CS].[Follow] = 1) AND ([CS].[Accepted] = 1) AND ([CS].[Visible] = 1)
)) > 50) AND ([CH].[OwnerId] = @OwnerId) AND ([CH].[Visible] = 1)", new { OwnerId = id });
model.HundredFollowers = db.SqlScalar <int>(@"SELECT COUNT(*) AS [value]
FROM [Channel] AS [CH]
WHERE (((
SELECT COUNT(*)
FROM [ChannelUser] AS [CS]
WHERE ([CS].[ChannelId] = [CH].[Id]) AND ([CS].[Follow] = 1) AND ([CS].[Accepted] = 1) AND ([CS].[Visible] = 1)
)) > 100) AND ([CH].[OwnerId] = @OwnerId) AND ([CH].[Visible] = 1)", new { OwnerId = id });
}
return(model);
}
public APIResult CheckConglomerationSetUp([FromBody] ParticipationModel input)
{
var conglomerationSetUp = db.ConglomerationSetUp.Find(input.ConglomerationSetUpId);
if (conglomerationSetUp == null)
{
return(Error("记录不存在"));
}
if (conglomerationSetUp.EndTime < DateTime.Now)
{
return(Error("该拼团已结束"));
}
var conglomerationActivity = db.ConglomerationActivity.Find(conglomerationSetUp.ConglomerationActivityId);
if (conglomerationActivity.ActivityEndTime <= DateTime.Now)
{
return(Error("活动已经结束"));
}
return(Success());
}
public ParticipationWindow(ParticipationModel c)
{
InitializeComponent();
csw = new ParticipationWindowViewModel(c);
DataContext = csw;
}
public APIResult Participation([FromBody] ParticipationModel input)
{
var conglomerationSetUp = db.ConglomerationSetUp.Find(input.ConglomerationSetUpId);
if (conglomerationSetUp == null || conglomerationSetUp.IsDel)
{
return(Error("记录不存在"));
}
if (conglomerationSetUp.MemberId.Equals(GetMemberId()))
{
return(Error("不能参加自己的拼团"));
}
var conglomerationActivity = db.ConglomerationActivity.Find(conglomerationSetUp.ConglomerationActivityId);
if (conglomerationActivity.ActivityEndTime <= DateTime.Now)
{
return(Error("活动已经结束"));
}
//开始执行逻辑
if (conglomerationSetUp.EndTime <= DateTime.Now ||
conglomerationSetUp.CurrentMemberNumber.Equals(conglomerationSetUp.MemberNumber) ||
conglomerationSetUp.Status.Equals(ConglomerationSetUpStatus.已经成团))
{
return(Error("该拼团已经结束"));
}
var conglomerationParticipations = db.ConglomerationParticipation.Where(m => !m.IsDel && m.ConglomerationSetUpId.Equals(input.ConglomerationSetUpId));
if (conglomerationParticipations.Count() >= conglomerationSetUp.MemberNumber)
{
return(Error("该拼团已经结束"));
}
//获取请求集合
var list = ShopConglomerationActivityOptions.GetSetupIdAndMemberId(conglomerationSetUp.Id, _logger);
if ((conglomerationSetUp.MemberNumber - conglomerationSetUp.CurrentMemberNumber) <= list.Count())
{
//判断是否还可以加入集合，如果不可以则提示稍后重试
return(Error("请稍后再试"));
}
//否则加入集合
ShopConglomerationActivityOptions.AddList(list, new ShopConglomerationActivityOptions.RequestModel()
{
CreateTime = DateTime.Now, MmeberId = GetMemberId()
});
_logger.LogInformation($"==============================添加到请求集合用户ID{GetMemberId()}===============");
var conglomerationActivityType = db.ConglomerationActivityType.Find(conglomerationSetUp.ConglomerationActivityTypeId);
//生成订单
var memberId = GetMemberId();
var memberAddress = db.Query <MemberAddress>().FirstOrDefault(m => m.Id.Equals(input.MemberAddressId));
if (memberAddress == null)
{
memberAddress = db.Query <MemberAddress>().FirstOrDefault(m => m.IsUsed);
}
ShopConglomerationOrderDto shopConglomerationOrderDto = new ShopConglomerationOrderDto()
{
AddIp = GetIp(),
ConglomerationSetUpId = conglomerationSetUp.Id,
ConglomerationSetUp = conglomerationSetUp,
MemberAddressId = input.MemberAddressId,
//MemberId = 70,
MemberId = memberId,
ShopId = input.ShopId,
Type = input.Type,
Name = memberAddress.Name,
Phone = memberAddress.Phone,
Delivery = input.Delivery,
FormId = input.FormId
};
var order = _shopConglomerationOrderServer.Create(db, shopConglomerationOrderDto);
return(Success(new { ConglomerationOrderId = order.Id }));
}
