public void AgentStructHandle(AgentStruct AgentStruct)
{
string select_str = "select levelId, l9, l8, l7,companyId , betSetting from [lottery].[dbo].[member] with(nolock) ";
string where_str = " Where id = @id ";
var e = conn.Query <member>(select_str + where_str,
new { Id = AgentStruct.ParentId }).FirstOrDefault();
select_str = "select betRate, defaultBetSetting from [lottery].[dbo].[company] with(nolock) ";
where_str = " Where principalId = @principalId ";
var h = conn.Query <company>(select_str + where_str,
new { principalId = AgentStruct.ParentId }).FirstOrDefault();
Define memberDefine = new Define();
member m = new member()
{
username = AgentStruct.Username,
password = AgentStruct.Password,
levelId = memberDefine.GetNextLevelId(e.levelId),
companyId = 0,
parentId = AgentStruct.ParentId,
externalId = "",
createDateTime = DateTime.Now,
l9 = e.l9,
l8 = e.l8,
l7 = e.l7,
betSetting = e.betSetting,
status = Define.MemberStauts.Enable,
nickname = AgentStruct.Nickname
};
dcdc.members.InsertOnSubmit(m);
dcdc.SubmitChanges();
int principalId = m.id;
company c = new company()
{
title = AgentStruct.Title,
createDateTime = DateTime.Now,
principalId = principalId,
betRate = h.betRate,
defaultBetSetting = h.defaultBetSetting
};
dcdc.companies.InsertOnSubmit(c);
dcdc.SubmitChanges();
int companyId = c.Id;
if (AgentStruct.LevelId == Define.MemberLevels.UpAgent)
{
m.l8 = principalId;
}
if (AgentStruct.LevelId == Define.MemberLevels.Agent)
{
m.l7 = principalId;
}
m.companyId = companyId;
dcdc.SubmitChanges();
}
