public bool Save(TaxiAppzDBContext context, AdminDetails adminDetails, LoggedInUser loggedInUser)
{
var emailid = context.TabAdmin.FirstOrDefault(t => t.IsDeleted == 0 && t.Email.ToLower() == adminDetails.Email.ToLower() && t.Id != adminDetails.Id);
if (emailid != null)
{
throw new DataValidationException($"Email id '{emailid.Email}' already exists.");
}
var service = context.TabServicelocation.FirstOrDefault(t => t.IsDeleted == 0 && t.Servicelocid == adminDetails.Area);
if (service == null)
{
throw new DataValidationException($"Service location does not exists.");
}
var role = context.TabRoles.FirstOrDefault(t => t.IsDelete == 0 && t.Roleid == adminDetails.RoleId);
if (role == null)
{
throw new DataValidationException($"Role already not exists.");
}
TabAdmin tabAdmin = new TabAdmin();
tabAdmin.AdminKey = "";
tabAdmin.AdminReference = 0;
tabAdmin.AreaName = adminDetails.Area;
tabAdmin.Email = adminDetails.Email.ToLower();
tabAdmin.EmergencyNumber = adminDetails.Emerphonenumber;
tabAdmin.Firstname = adminDetails.Firstname;
tabAdmin.Language = adminDetails.Languagename;
tabAdmin.Lastname = adminDetails.Lastname;
tabAdmin.Password = adminDetails.Password;
tabAdmin.PhoneNumber = adminDetails.Phonenumber;
tabAdmin.ProfilePic = adminDetails.ProfilePicture;
tabAdmin.RegistrationCode = (context.TabAdmin.Count() + 1).ToString();
tabAdmin.Role = adminDetails.RoleId;
tabAdmin.IsActive = 1;
tabAdmin.IsDeleted = 0;
tabAdmin.CreatedAt = DateTime.UtcNow;
tabAdmin.UpdatedAt = DateTime.UtcNow;
tabAdmin.UpdatedBy = tabAdmin.CreatedBy = loggedInUser.Email;
context.TabAdmin.Add(tabAdmin);
context.SaveChanges();
TabAdminDetails tabAdminDetails = new TabAdminDetails();
tabAdminDetails.AdminId = tabAdmin.Id;
tabAdminDetails.Address = adminDetails.Address;
tabAdminDetails.PostalCode = adminDetails.Postalcode;
tabAdminDetails.CountryId = adminDetails.Country;
context.TabAdminDetails.Add(tabAdminDetails);
context.SaveChanges();
return(true);
}
public AdminDetails GetbyId(long id, TaxiAppzDBContext context)
{
try
{
AdminDetails adminInfo = new AdminDetails();
var data = context.TabAdmin.Include(t => t.TabAdminDetails).Where(t => t.Id == id && t.IsDeleted == 0).FirstOrDefault();
if (data != null)
{
adminInfo.Country = 0;
adminInfo.Email = data.Email;
adminInfo.Emerphonenumber = data.EmergencyNumber;
adminInfo.Firstname = data.Firstname;
adminInfo.Languagename = data.Language;
adminInfo.Lastname = data.Lastname;
adminInfo.Password = data.Password;
adminInfo.Phonenumber = data.PhoneNumber;
adminInfo.RoleId = data.Role;
}
var tabAdmin = context.TabAdminDetails.Where(t => t.AdminId == id && t.IsDeleted == 0).FirstOrDefault();
if (tabAdmin != null)
{
adminInfo.Address = tabAdmin.Address;
adminInfo.Postalcode = tabAdmin.PostalCode;
adminInfo.Country = tabAdmin.CountryId;
adminInfo.Postalcode = tabAdmin.PostalCode;
adminInfo.DocumentName = tabAdmin.DocumentName;
}
return(adminInfo != null ? adminInfo : null);
}
catch (Exception ex)
{
Extention.insertlog(ex.Message, "Admin", "GetbyId", context);
return(null);
}
}
public bool Edit(TaxiAppzDBContext context, AdminDetails adminDetails, LoggedInUser loggedInUser)
{
var admin = context.TabAdmin.FirstOrDefault(t => t.IsDeleted == 0 && t.Id == adminDetails.Id);
if (admin != null)
{
throw new DataValidationException($"Admin does not exists");
}
var emailid = context.TabAdmin.FirstOrDefault(t => t.IsDeleted == 0 && t.Email.ToLower() == adminDetails.Email.ToLower() && t.Id != adminDetails.Id);
if (emailid != null)
{
throw new DataValidationException($"Email id '{emailid.Email}' already exists.");
}
var service = context.TabServicelocation.FirstOrDefault(t => t.IsDeleted == 0 && t.Servicelocid == adminDetails.Area);
if (emailid != null)
{
throw new DataValidationException($"Email id '{emailid.Email}' already exists.");
}
var tabAdmin = context.TabAdmin.Include(t => t.TabAdminDetails).Where(r => r.Id == adminDetails.Id && r.IsDeleted == 0).FirstOrDefault();
if (tabAdmin != null)
{
tabAdmin.AreaName = adminDetails.Area;
tabAdmin.Email = adminDetails.Email;
tabAdmin.EmergencyNumber = adminDetails.Emerphonenumber;
tabAdmin.Firstname = adminDetails.Firstname;
tabAdmin.Language = adminDetails.Languagename;
tabAdmin.Lastname = adminDetails.Lastname;
tabAdmin.PhoneNumber = adminDetails.Phonenumber;
tabAdmin.ProfilePic = adminDetails.ProfilePicture;
tabAdmin.Role = adminDetails.RoleId;
tabAdmin.UpdatedAt = DateTime.UtcNow;
tabAdmin.UpdatedBy = loggedInUser.Email;
context.TabAdmin.Update(tabAdmin);
context.SaveChanges();
}
else
{
TabAdmin tab = new TabAdmin();
tab.AreaName = adminDetails.Area;
tab.Email = adminDetails.Email;
tab.EmergencyNumber = adminDetails.Emerphonenumber;
tab.Firstname = adminDetails.Firstname;
tab.Language = adminDetails.Languagename;
tab.Lastname = adminDetails.Lastname;
tab.Password = adminDetails.Password;
tab.PhoneNumber = adminDetails.Phonenumber;
tab.ProfilePic = adminDetails.ProfilePicture;
tab.Role = adminDetails.RoleId;
tab.UpdatedAt = DateTime.UtcNow;
tab.UpdatedBy = loggedInUser.Email;
context.TabAdmin.Add(tab);
context.SaveChanges();
}
var tabAdmindetails = context.TabAdminDetails.Where(r => r.AdminId == adminDetails.Id && r.IsDeleted == 0).FirstOrDefault();
if (tabAdmindetails != null)
{
tabAdmindetails.AdminId = tabAdmin.Id;
tabAdmindetails.Address = adminDetails.Address;
tabAdmindetails.PostalCode = adminDetails.Postalcode;
tabAdmindetails.CountryId = adminDetails.Country;
tabAdmindetails.UpdatedAt = DateTime.UtcNow;
tabAdmindetails.UpdatedBy = loggedInUser.Email;
context.TabAdminDetails.Update(tabAdmindetails);
context.SaveChanges();
}
else
{
TabAdminDetails details = new TabAdminDetails();
details.AdminId = tabAdmin.Id;
details.Address = adminDetails.Address;
details.PostalCode = adminDetails.Postalcode;
details.CountryId = adminDetails.Country;
details.UpdatedAt = DateTime.UtcNow;
details.UpdatedBy = loggedInUser.Email;
context.TabAdminDetails.Add(details);
context.SaveChanges();
}
return(true);
}