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 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)); }