public void AddOLDMember()
{
//var memberTree = db.tbl_member_tree.ToList();
var memberTree = (from mt in db.tbl_member_tree
where !(from m in db.tbl_members
select m.PlacementID)
.Contains(mt.PlacementID)
select mt).OrderBy(o => o.SerialNo).ToList();
string newMemmberID = "-1";
// using (var tr = db.Database.BeginTransaction())
// {
// try
// {
memberTree.ForEach(x =>
{
if (x.PlacementID != "al-arafa01" && x.PlacementID != "al-arafa02" && x.PlacementID != "al-arafa03" &&
x.PlacementID != "al-baraka01" && x.PlacementID != "al-baraka02" && x.PlacementID != "al-baraka03" &&
x.PlacementID != "jalal-01" && x.PlacementID != "jalal-02" && x.PlacementID != "w-founder81" &&
x.PlacementID != "bpd(r)" && x.PlacementID != "khairul0?0" && x.PlacementID != "rasad,05")
{
tbl_members newMember = new tbl_members();
newMemmberID = KDMSettings.GetNextMemberID(db);
newMember.MemberID = newMemmberID;
newMember.PlacementID = x.PlacementID;
newMember.Phone1 = x.PlacementID;
newMember.CreateBy = "Jobaed";
newMember.CreateDate = DateTime.Now;
db.tbl_members.Add(newMember);
db.SaveChanges();
IdentityManager im = new IdentityManager();
ApplicationUser newUser = new ApplicationUser();
newUser.UserName = x.PlacementID;
newUser.IsActive = true;
im.CreateUser(newUser, KDMEnvironmentConstants.DefaultUserPassword);
im.AddUserToRole(x.PlacementID, KDMEnvironmentConstants.DefaultUserRole);
//db.tbl_members.Add(newMember);
db.SaveChanges();
}
});
//tr.Commit();
//}
//catch (Exception ex)
//{
// //tr.Rollback();
// Log.Error(ex, "[M_0000011]");
//}
// }
}
public ActionResult LinkedMemberTransfer(UserMemberLinkVModel model)
{
ViewBag.PageTitle = "Member MANAGEMENT";
Dictionary <string, string> PanelTitles = new Dictionary <string, string>();
PanelTitles["MemberTransfer"] = "Member Transfer";
ViewBag.PanelTitles = PanelTitles;
if (!ModelState.IsValid)
{
ViewBag.ErrorMessage = "Linked Member Transfer Failed.";
return(View(model));
}
else
{
ViewBag.SuccessMessage = "Successfully Transfer Linked Member.";
tbl_user_member_transfer_history transfer = new tbl_user_member_transfer_history();
transfer.MemberId = model.MemberId;
transfer.From = model.From;
transfer.To = model.To;
transfer.TransferBy = User.Identity.GetUserId();
transfer.TransferDate = DateTime.Now;
db.tbl_user_member_transfer_history.Add(transfer);
var IsExistInMaster = db.tbl_user_member_master.FirstOrDefault(x => x.MemberId == model.MemberId.Trim() && x.UserId == model.From.Trim());
if (IsExistInMaster != null)
{
db.tbl_user_member_master.Remove(IsExistInMaster);
tbl_user_member_master master = new tbl_user_member_master();
master.MemberId = model.MemberId;
master.UserId = User.Identity.GetUserId();
master.ModificationDate = DateTime.Now;
db.tbl_user_member_master.Add(master);
tbl_members member = new tbl_members();
member = db.tbl_members.FirstOrDefault(x => x.Phone1 == model.From);
member.Phone1 = model.To;
db.Entry(member).State = EntityState.Modified;
}
db.SaveChanges();
ModelState.Clear();
return(View());
}
}
public ActionResult AddMember(MemberRegistrationViewModel member)
{
string oldplacementId = db.tbl_members.Where(x => x.MemberID == member.PlacementID).Select(s => s.PlacementID).FirstOrDefault();
string newMemmberID = "-1";
tbl_members newMember = new tbl_members();
using (var tr = db.Database.BeginTransaction())
{
//try
//{
if (!ModelState.IsValid)
{
ViewBag.EMsg = "Input validation failed.";
return(View(member));
}
newMemmberID = KDMSettings.GetNextMemberID(db);
if (newMemmberID == "-1")
{
Log.Warning("[M_0000011] Can't create new placement ID");
ViewBag.EMsg = "Can't create the new placement id";
return(View());
}
var memberIDExist = db.tbl_members.Where(x => x.MemberID == newMemmberID).FirstOrDefault();
var phoneExist = db.tbl_members.Where(x => x.Phone1 == member.Phone1).FirstOrDefault();
if (memberIDExist != null)
{
ViewBag.EMsg = "Member No already exits";
ViewBag.EMsg = "Phone number already exist. Register with new phone numbers";
return(View(member));
}
if (phoneExist != null)
{
ViewBag.EMsg = "Phone number already exist. Register with new phone numbers";
return(View(member));
}
int checkdata = MemberTreeAvaility(oldplacementId, Convert.ToString(member.PlacementPosition), newMemmberID);
if (checkdata != 1)
{
ViewBag.EMsg = "Placement is not ok";
return(View(member));
}
newMember.MemberID = newMemmberID;
newMember.SponsorID = member.SponsorID;
// newMember.PlacementID = member.PlacementID; // child of
newMember.PlacementID = newMemmberID; // for new member
newMember.DistributorName = member.DistributorName;
newMember.FathersName = member.FathersName;
newMember.MothersName = member.MothersName;
newMember.PresentAddress = member.PresentAddress;
newMember.PermanentAddress = member.PermanentAddress;
newMember.NID = member.NID;
newMember.Phone1 = member.Phone1;
newMember.Phone2 = member.Phone2;
newMember.NomineeName = member.NomineeName;
newMember.RelationWithNominee = member.RelationWithNominee;
newMember.NomineeNIDOrBirthCertificate = member.NomineeNIDOrBirthCertificate;
newMember.CreateBy = User.Identity.Name;
newMember.CreateDate = DateTime.Now;
db.tbl_members.Add(newMember);
if (member.Photo != null)
{
//string photoId = ControllerHelper.SaveFile(member.Photo);
string photoId = SaveFile(member.Photo);
//newMember.PhotoID = Convert.ToInt64(photoId);
if (!String.IsNullOrWhiteSpace(photoId))
{
db.tbl_file.Add(new tbl_file()
{
file_title = "Member Id",
file_type = "Member",
file_details = photoId
});
}
}
#region create new entry for new member in tbl_member_tree
db.tbl_member_tree.Add(new tbl_member_tree()
{
PlacementID = newMemmberID,
LeftPoint = 0,
RightPoint = 0,
PV = 0,
BV = 0,
TotalBV = 0,
LeftChildCount = 0,
RightChildCount = 0
});
#endregion
#region Placement the member
var placement = db.tbl_member_tree.Where(x => x.PlacementID == oldplacementId).FirstOrDefault();
if (placement != null)
{
if (!String.IsNullOrWhiteSpace(placement.LeftID) && !String.IsNullOrWhiteSpace(placement.RightID))
{
ViewBag.EMsg = "Placement id left and right is not blank";
return(View(member));
}
if (member.PlacementPosition == "Left" && placement.PlacementID != newMemmberID)
{
placement.LeftID = newMemmberID;
//placement.TotalBV = 0;
placement.LeftPoint = 0;
//placement.RightPoint = 0;
//placement.BV = 0;
//placement.PV = 0;
}
else if (member.PlacementPosition == "Right" && placement.PlacementID != newMemmberID)
{
placement.RightID = newMemmberID;
//placement.TotalBV = 0;
//placement.LeftPoint = 0;
placement.RightPoint = 0;
//placement.BV = 0;
///placement.PV = 0;
}
}
else
{
ViewBag.EMsg = "Placement id does not exist.";
return(View(member));
}
#endregion
#region create new user if withpassword set true
if (member.WithPassword && !String.IsNullOrWhiteSpace(member.Phone1))
{
IdentityManager im = new IdentityManager();
ApplicationUser newUser = new ApplicationUser();
newUser.UserName = member.Phone1;
newUser.IsActive = true;
newUser.ChangePassword = true;
if (im.CreateUser(newUser, KDMEnvironmentConstants.DefaultUserPassword))
{
if (!im.IsRoleExists(KDMEnvironmentConstants.DefaultUserRole))
{
im.CreateRole(KDMEnvironmentConstants.DefaultUserRole);
}
if (!im.AddUserToRole(member.Phone1, KDMEnvironmentConstants.DefaultUserRole))
{
ViewBag.EMsg = "Can't create the role";
return(View(member));
}
}
else
{
ViewBag.EMsg = "Can't create the user";
return(View(member));
}
}
#endregion
db.SaveChanges();
tr.Commit();
ViewBag.SMsg = "Member Successfully created. Your new member id " + newMemmberID;
// }
//catch(Exception ex)
//{
// tr.Rollback();
// Log.Error(ex, "[M_0000011]");
// ViewBag.EMsg = "Can't create new member";
//}
}
return(View(member));
}
