Int64 IRegistration.FirstTimeRegistration(string CompanyName, int LicenseCount, string EmailID, string Key, string SystemName, string MacAddress, string Name, string MobileNo, List <Service> SearchTypeList) { RegistrationMaster _Reg = new RegistrationMaster(); _Reg.CompanyName = CompanyName; _Reg.LicenseCount = Convert.ToInt32(LicenseCount); _Reg.CreatedBy = 1; _Reg.CreatedDtTm = DateTime.Now; _Reg.EmailID = EmailID; _Reg.IsActive = true; _Reg.Key = Key; _Reg.SystemName = SystemName; _Reg.MacAddress = MacAddress; _Reg.Name = Name; _Reg.MobileNo = MobileNo; _Reg.IsSentForRegistration = true; db.RegistrationMasters.Add(_Reg); db.SaveChanges(); foreach (var item in SearchTypeList) { RegistrationWiseSearchTypes reg = new RegistrationWiseSearchTypes(); reg.CreatedBy = 1; reg.CreatedDtTm = DateTime.Now; reg.IsActive = true; reg.RegistrationID = _Reg.RegistrationID; reg.IsRequired = item.IsRequired; reg.SearchTypeID = item.ServiceID; db.RegistrationWiseSearchTypes.Add(reg); db.SaveChanges(); } return(_Reg.RegistrationID); }
private void btnValidate_Click(object sender, RoutedEventArgs e) { txtActivationKey.SelectAll(); string value = Utility.Utility.Decrypt(txtActivationKey.Selection.Text); licvm = Newtonsoft.Json.JsonConvert.DeserializeObject <LicenseViewModel>(value); var _ExistReg = db.RegistrationMasters.Where(w => w.Key == licvm.Key && w.SystemName == licvm.SystemName && w.MacAddress == licvm.MacAddress && w.MobileNo == licvm.MobileNo && w.EmailID == licvm.EmailID && w.Name == licvm.Name).FirstOrDefault(); if (_ExistReg != null) { if (_ExistReg.IsActivated) { licvm.ServiceList = new List <Service>(); licvm.ServiceList.AddRange(db.RegistrationWiseSearchTypes.Join(db.SearchTypeMasters, x => x.SearchTypeID, y => y.SearchTypeID, (x, y) => new { x, y.SearchName }).Where(w => w.x.RegistrationID == _ExistReg.RegistrationID).Select(s => new Service() { ServiceID = s.x.SearchTypeID, IsRequired = s.x.IsRequired, IsActivated = s.x.IsActivated, ServiceName = s.SearchName }).ToList()); licvm.IsActivated = _ExistReg.IsActivated; licvm.ActivationDtTm = _ExistReg.ActivatedDtTm; licvm.ActivationKey = _ExistReg.ActivationKey; licvm.ActivationUptoDtTm = _ExistReg.ActivatedTillDtTm; MessageBox.Show("Same key has been already activated."); MailData(licvm, _ExistReg.RegistrationID); } } else { if (licvm != null) { listBoxSeachType.ItemsSource = licvm.ServiceList; txtFullName.Text = licvm.Name; txtMobileNo.Text = licvm.MobileNo; txtEmailID.Text = licvm.EmailID; txtCompany.Text = licvm.CompanyName; txtLicenseCount.Text = Convert.ToString(licvm.SystemCount); txtActivationKey.IsEnabled = false; btnValidate.IsEnabled = false; _Reg = new RegistrationMaster(); _Reg.Name = licvm.Name; _Reg.MobileNo = licvm.MobileNo; _Reg.EmailID = licvm.EmailID; _Reg.Key = licvm.Key; _Reg.MacAddress = licvm.MacAddress; _Reg.SystemName = licvm.SystemName; _Reg.CompanyName = licvm.CompanyName; _Reg.LicenseCount = licvm.SystemCount; _Reg.IsActive = true; _Reg.CreatedBy = 1; _Reg.CreatedDtTm = DateTime.Now; _Reg.IsSentForRegistration = true; } } }
public RegistrationViewModel WebInterfaceAddReg(RegistrationViewModel model) { RegistrationMaster obj = new RegistrationMaster(); obj.Fname = model.Fname; obj.Lname = model.Lname; obj.Mobile = model.Mobile; obj.CorrespondenceAddress = model.CorrespondenceAddress; obj.CorrespondenceCity = model.CorrespondenceCity; obj.CorrespondenceState = model.CorrespondenceState; obj.CorrespondenceZip = model.CorrespondenceZip; obj.PermanentAddress = model.PermanentAddress; obj.PermanentCity = model.PermanentCity; obj.PermanentState = model.PermanentState; obj.PermanentZip = model.PermanentZip; if (model.DateOfBirth != null && model.DateOfBirth != "") { obj.DOB = DateTime.ParseExact(model.DateOfBirth, "dd/MM/yyyy", CultureInfo.InvariantCulture); } obj.Email = model.Email; obj.Gender = model.Gender; obj.Height = model.Height; obj.Width = model.Width; obj.RegistartionNo = MaxRegistartionNumber(); obj.IsPassport = model.IsPassport; obj.IsAppeared = model.IsAppeared; obj.Education = model.Education; obj.IsConsultantCandidate = model.IsConsultantCandidate; obj.IsHRCandidate = model.IsHRCandidate; obj.RegistrationDate = DateTime.Now; obj.PaymentDate = DateTime.Now; obj.PaymentId = model.PaymentId; if (string.IsNullOrEmpty(model.CourseName)) { obj.PaymentStatus = false; } else { obj.PaymentStatus = model.PaymentStatus; } obj.ModOfPayment = model.ModOfPayment; obj.IsActive = true; obj.PassingYear = model.PassingYear; if (model.CurrentYear > 0 && !string.IsNullOrEmpty(model.CourseName)) { var sessionCourseData = GetSessionIdByCourse(model.CurrentYear, model.CourseName); if (sessionCourseData != null) { obj.SessionId = sessionCourseData.SessionId; obj.CourseId = sessionCourseData.CourseId; } } obj.OrderId = model.OrderId; obj.ApplicationNo = model.ApplicationNo; obj.SerialNo = model.SerialNo; if (!string.IsNullOrEmpty(model.LeadType)) { if (model.LeadType == "Consultant") { obj.IsConsultantCandidate = true; } else if (model.LeadType == "SpiceJet HR") { obj.IsHRCandidate = true; } } obj.SourceOfCandidate = model.LeadType; if (!string.IsNullOrEmpty(model.IsAadharCard) && model.IsAadharCard == "Yes") { obj.IsAadharCard = true; } obj.AadharCardNo = model.AadharCardNo; obj.DepartmentMasterId = 1; var list = _context.RegistrationMasters.Where(w => (w.Email == model.Email || w.Mobile == model.Mobile) && !w.IsReRegister).ToList(); if (list.Count() > 0) { foreach (var i in list) { i.IsActive = false; i.IsReRegister = true; } } _context.RegistrationMasters.Add(obj); _context.SaveChanges(); model.RegistartionNo = obj.RegistartionNo; return(model); }
Int64 IRegistration.AdminUserCreateAndRoleMapping(RegistrationMaster _Reg, ViewModel.LicenseViewModel licvm) { Int64 RegistrationID = 0; //Updating R egistraionDetails var _ExistReg = db.RegistrationMasters.Where(w => w.RegistrationID == _Reg.RegistrationID).ToList(); foreach (var item in _ExistReg) { RegistrationID = item.RegistrationID; if (licvm.IsActivated == true) { item.IsActivated = licvm.IsActivated; item.ActivationKey = licvm.ActivationKey; item.ActivatedDtTm = licvm.ActivationDtTm; item.ActivatedTillDtTm = licvm.ActivationUptoDtTm; item.LicenseCount = licvm.SystemCount; item.LicenseUsed = 1; item.ModifiedBy = _Reg.CreatedBy; item.ModifiedDtTm = DateTime.Now; db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } break; } foreach (var item in licvm.ServiceList) { var serviceupdate = db.RegistrationWiseSearchTypes.Where(w => w.RegistrationID == _Reg.RegistrationID && w.SearchTypeID == item.ServiceID).First(); serviceupdate.IsActivated = item.IsActivated; serviceupdate.ActivatedDtTm = licvm.ActivationDtTm; db.Entry(serviceupdate).State = EntityState.Modified; db.SaveChanges(); } //License Info Update string MacAddress = AppUtility.GetMachineData("MacAddress"); string SystemName = System.Net.Dns.GetHostName(); var _ExistLicense = db.LicenseKeys.Where(w => w.RegistrationID == _Reg.RegistrationID && w.DesktopName == SystemName && w.MacAddress == MacAddress).ToList(); if (_ExistLicense.Count == 0) { LicenseKeys key = new LicenseKeys(); key.CreatedBy = 1; key.CreatedDtTm = DateTime.Now; key.DesktopName = licvm.SystemName; key.IpAddress = ""; key.IsActive = true; key.LicenseKeyCode = licvm.ActivationKey; key.LicenseKeySequence = 1; key.MacAddress = licvm.MacAddress; key.RegistrationDtTm = licvm.ActivationDtTm; key.RegistrationID = RegistrationID; key.ValidUptoDtTm = licvm.ActivationUptoDtTm; db.LicenseKeys.Add(key); db.SaveChanges(); } RoleMaster role = new RoleMaster(); var _ExistRole = db.RoleMasters.Where(w => w.RoleName == "Super Admin").ToList(); if (_ExistRole.Count > 0) { foreach (var item in _ExistRole) { role = item; break; } } else { role.CreatedBy = 1; role.CreatedDtTm = DateTime.Now; role.IsActive = true; role.RoleName = "Super Admin"; db.RoleMasters.Add(role); db.SaveChanges(); } var pages = db.PageMasters.ToList(); foreach (var page in pages) { RolePageMapping mapping = new RolePageMapping(); var _Existmapping = db.RolePageMappings.Where(w => w.PageID == page.PageID && w.RoleID == role.RoleID).ToList(); if (_Existmapping.Count == 0) { mapping.CreatedBy = 1; mapping.CreatedDtTm = DateTime.Now; mapping.IsActive = true; mapping.PageID = page.PageID; mapping.RoleID = role.RoleID; db.RolePageMappings.Add(mapping); db.SaveChanges(); } } UserMaster user = new UserMaster(); var _Existuser = db.UserMasters.Where(w => w.RoleID == role.RoleID).ToList(); if (_Existuser.Count == 0) { user.CreatedBy = 1; user.CreatedDtTm = DateTime.Now; user.IsActive = true; user.EmailID = _Reg.EmailID; user.FullName = _Reg.Name; user.ManagerID = null; user.MobileNo = _Reg.MobileNo; user.Password = _Reg.MobileNo; user.RoleID = role.RoleID; user.UserName = _Reg.MobileNo; user.ConfirmPassword = _Reg.MobileNo; db.UserMasters.Add(user); db.SaveChanges(); } else { foreach (var item in _Existuser) { user = item; break; } } return(user.UserID); }