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