public Guid AddNewCustomerRequest(CreateNewUsersEntity item)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities dB = new FacilitiesEntities())
{
try
{
// Add data Customer Name In Customer Table
Customer C = new Customer();
if (item.UserEntity.UserId == Guid.Empty)
{
if (!IsCustomerExists(item.CustomerEntity.CustomerName))
{
// Add data User In User Table
var U = VM_User.AddDataInUser <User>(item.UserEntity);
//var UserId1 = dB.CustomerUsers.Where(x => x.User == U.UserId).FirstOrDefault();
if (U != null)
{
C.CustomerId = Guid.NewGuid();
C.CustomerName = item.CustomerEntity.CustomerName;
C.ActiveFlag = "Y";
dB.Customers.Add(C);
//Add data in clientcustomer Table
ClientCustomer CC = new ClientCustomer();
CC.ClientCustomerId = Guid.NewGuid();
CC.Client = item.ClientCustomerEntity.Client;
CC.Customer = C.CustomerId;
CC.ActiveFlag = "Y";
dB.ClientCustomers.Add(CC);
dB.SaveChanges();
item.CustomerUserEntity.User = U.UserId;
item.CustomerUserEntity.Customer = C.CustomerId;
VM_CustomerUsers.AddDataInCustomerUsers(item.CustomerUserEntity);
UserID = U.UserId;
}
}
}
else
{
var CUS = dB.Customers.Where(a => a.CustomerId == item.CustomerEntity.CustomerId).FirstOrDefault();
if (CUS != null)
{
var user = VM_User.UpdateDataInUser <User>(item.UserEntity);
item.CustomerUserEntity.ActiveFlag = item.UserEntity.ActiveFlag;
VM_CustomerUsers.UpdateDataInCustomerUsers(item.CustomerUserEntity);
CUS.CustomerName = item.CustomerEntity.CustomerName;
dB.SaveChanges();
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
public API_Response <VM_User> Login(DTO_UserLogin model)
{
return(InvokeAPI(() =>
{
VM_User user = null;
if (!Global.Cache.CheckEmailExists(model.UserName))
{
throw new Exception("User Not Found");
}
//
var UserLoginDetails = _DL.User.Account.LoginDetails_ByEmail(model.UserName);
// Check User Login Details
if (ModelState.IsValid)
{
// Check Password
if (HashHMACSHA1.CheckSaltedHash(model.UserPassword, UserLoginDetails.PasswordHash))
{
user = _DL.User.Get.ByID(UserLoginDetails.UserID); // Get User
user.ApiKey = API_KeyHelper.GenarateKey(user.UserID); // Generate Token
}
else
{
throw new Exception("Incorrect password");
}
}
else
{
throw new Exception("Login Error");
}
return user;
}, "", false));
}
public Guid AddNewClientRequest(CreateNewUsersEntity item)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities dB = new FacilitiesEntities())
{
try
{
if (item.UserEntity.UserId == Guid.Empty)
{
var U = VM_User.AddDataInUser <User>(item.UserEntity);
var UserId1 = dB.ClientUsers.Where(x => x.User == U.UserId).FirstOrDefault();
if (U != null && UserId1 == null)
{
item.ClientUserEntity.User = U.UserId;
VM_ClientUsers.AddDataInClientUser(item.ClientUserEntity);
UserID = U.UserId;
}
}
else
{
item.UserEntity.ActiveFlag = item.ClientUserEntity.ActiveFlag;
VM_ClientUsers.UpdateDataInClientUser(item.ClientUserEntity);
var U = VM_User.UpdateDataInUser <User>(item.UserEntity);
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
// GET: ApplicationUsers/Details/5
public async Task <IActionResult> Details(string id)
{
if (id == null)
{
return(NotFound());
}
var predictions = _context.Predictions.Include("Fixture").Where(p => p.ApplicationUserId == id).Where(p => p.Fixture.FixtureDateTime <= DateTime.Now).ToList();
var applicationUser = await _context.ApplicationUser
.SingleOrDefaultAsync(m => m.Id == id);
if (applicationUser == null)
{
return(NotFound());
}
VM_User vm = new VM_User();
vm.Id = applicationUser.Id;
vm.FirstName = applicationUser.FirstName;
vm.Surname = applicationUser.Surname;
vm.Predictions = predictions;
vm.Points = predictions.Sum(p => p.Points);
return(View(vm));
}
public static VM_User ByExternalID(string externalID, EN_RegistrationSource registrationSource)
{
VM_User User = new VM_User();
using (var exodusDB = new exodusEntities())
{
var result = exodusDB.stp_User_ByExternalID(externalID,
registrationSource.ToInt()).FirstOrDefault();
if (result != null)
{
User.UserID = result.UserID;
User.UserGuid = result.UserGuid;
User.UserFirstName = result.UserFirstName;
User.UserLastName = result.UserLastName;
User.UserType = (En_UserType)result.UserTypeID;
User.UserStatus = (En_CurrentStatus)result.UserStatusID;
User.UserStatusMessage = result.UserStatusMessage;
User.UserAbout = result.UserAbout;
User.UserRegistered = result.UserRegistered;
User.UserRegistrationSource = (EN_RegistrationSource)result.RegistrationSourceID;
User.Avatar = Global.Cache.dicUserAvatars[result.UserID];
}
else
{
return(null);
}
}
return(User);
}
public API_Response <VM_User> Current([FromUri] string api_key = "")
{
return(InvokeAPI(() =>
{
VM_User user = String.IsNullOrEmpty(SessionID) ? null : Global.Global.CurrentUser;
return user;
}, api_key));
}
public static VM_User SystemUser()
{
//641C2AD5-9F5B-432A-81A3-8DD5670F1784
string sysUser = "******";
VM_User systemUser = ByGuid(sysUser);
return(systemUser);
}
public static void SessionSetUser(string sessionID, VM_User user)
{
if (String.IsNullOrEmpty(sessionID) || user == null)
{
return;
}
//
if (dicUserSession.ContainsKey(sessionID)) // Update
{
dicUserSession[sessionID].User = user;
}
else if (user != null)
{
dicUserSession.Add(sessionID, new GM_Session(user));
if (!dicUserIDSessionID.ContainsKey(user.UserID))
{
dicUserIDSessionID.Add(user.UserID, sessionID);
}
}
}
public Guid SaveCustomerUsers(CustomerUsers item)
{
Guid UserId = Guid.Empty;
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
CustomerUser CU = new CustomerUser();
if (item.UserEntity.UserId == Guid.Empty && item.CustomerUserEntity.CustomerUserId == Guid.Empty)
{
var U = VM_User.AddDataInUser <User>(item.UserEntity);
item.CustomerUserEntity.User = U.UserId;
UserId = U.UserId;
item.CustomerUserEntity.ActiveFlag = U.ActiveFlag;
CU.CustomerUserId = Guid.NewGuid();
CU.Customer = item.CustomerUserEntity.Customer;
CU.Role = item.CustomerUserEntity.Role;
CU.User = item.CustomerUserEntity.User;
CU.ActiveFlag = "Y";
db.CustomerUsers.Add(CU);
db.SaveChanges();
//VM_CustomerUsers.AddDataInCustomerUsers(item.CustomerUserEntity);
var CustomerRole = db.Roles.Where(a => a.RoleId == item.CustomerUserEntity.Role && a.ActiveFlag == "Y").Select(m => m.RoleName).FirstOrDefault();
if (CustomerRole == "Customer location User")
{
if (item.CustomerLocationID != Guid.Empty)
{
CustomerLocationUser CL = new CustomerLocationUser();
CL.CustomerLocationUser1 = Guid.NewGuid();
CL.CustomerLocation = item.CustomerLocationID;
CL.User = U.UserId;
CL.ActiveFlag = "Y";
db.CustomerLocationUsers.Add(CL);
db.SaveChanges();
}
else
{
foreach (var value in item.CustomerLocation)
{
CustomerLocationUser CL = new CustomerLocationUser();
CL.CustomerLocationUser1 = Guid.NewGuid();
CL.CustomerLocation = value;
CL.User = U.UserId;
CL.ActiveFlag = "Y";
db.CustomerLocationUsers.Add(CL);
db.SaveChanges();
}
}
}
}
else
{
//Nitin31082018
var U = VM_User.UpdateDataInUser <User>(item.UserEntity);
var AfterActionUrl = db.CustomerUsers.Join(db.Roles, LH => LH.Role, CGL => CGL.RoleId, (LH, CGL) => new { RoleName = CGL.RoleName, User = LH.User }).Where(LH => LH.User == U.UserId).FirstOrDefault().RoleName;
if (AfterActionUrl == "Customer location User")
{
var allRec = db.CustomerLocationUsers.Where(a => a.User == item.UserEntity.UserId);
if (allRec != null)
{
db.CustomerLocationUsers.RemoveRange(allRec);
db.SaveChanges();
}
}
//item.CustomerUserEntity = db.CustomerUsers.Where(p => p.User == item.UserEntity.UserId).FirstOrDefault();
var Rolename = db.Roles.Where(x => x.RoleId == item.CustomerUserEntity.Role && x.ActiveFlag == "Y").Select(m => m.RoleName).FirstOrDefault();
if (Rolename == "Customer location User")
{
if (item.CustomerLocationID != Guid.Empty)
{
var allRec = db.CustomerLocationUsers.Where(a => a.User == item.UserEntity.UserId);
if (allRec != null)
{
db.CustomerLocationUsers.RemoveRange(allRec);
db.SaveChanges();
}
CustomerLocationUser CL = new CustomerLocationUser();
CL.CustomerLocationUser1 = Guid.NewGuid();
CL.CustomerLocation = item.CustomerLocationID;
CL.User = U.UserId;
CL.ActiveFlag = "Y";
db.CustomerLocationUsers.Add(CL);
db.SaveChanges();
}
else
{
var allRec = db.CustomerLocationUsers.Where(a => a.User == item.UserEntity.UserId);
if (allRec != null)
{
db.CustomerLocationUsers.RemoveRange(allRec);
db.SaveChanges();
}
foreach (var value in item.CustomerLocation)
{
CustomerLocationUser CL = new CustomerLocationUser();
CL.CustomerLocationUser1 = Guid.NewGuid();
CL.CustomerLocation = value;
CL.User = U.UserId;
CL.ActiveFlag = "Y";
db.CustomerLocationUsers.Add(CL);
db.SaveChanges();
}
}
}
var CustomerUsersdetails = db.CustomerUsers.Where(p => p.User == item.UserEntity.UserId).FirstOrDefault();
CustomerUsersdetails.Role = item.CustomerUserEntity.Role;
VM_CustomerUsers.UpdateDataInCustomerUsers(CustomerUsersdetails);
}
return(UserId);
}
catch (Exception ex)
{
return(UserId);
}
}
}
public GM_Session(VM_User user)
{
User = user;
}
public Guid CreateVendor(VendorEntities vendor)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities db = new FacilitiesEntities())
{
UOWVendor vendorObj = new UOWRepository.UOWVendor();
try
{
vendor.UserEntity.Email = vendor.Email;
var newVendor = new Vendor();
if (vendor.Email != null && (!vendorObj.IsVendorExists(vendor.Email)))
{
if (vendor.UserEntity.FirstName != null && vendor.UserEntity.FirstName.Trim().Length > 0)
{
if (vendor.UserEntity.LastName == null)
{
vendor.UserEntity.LastName = "";
}
var U = VM_User.AddDataInUser <User>(vendor.UserEntity);
if (U != null)
{
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = (vendor.VendorName != null && vendor.VendorName.Trim().Length > 0) ? vendor.VendorName : vendor.UserEntity.FirstName + " " + vendor.UserEntity.LastName;
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = vendor.TaxId != null ? vendor.TaxId : " ";
newVendor.TaxIdisEIN = vendor.TaxIdisEIN != null ? vendor.TaxIdisEIN : " ";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = vendor.Status;
newVendor.AddressVerifiedFlag = "Y";
//client vendors
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = vendor.Status;
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
//Get Vendor Admin Id
var GetVendorAdminId = db.Roles.Where(a => a.RoleName == "Vendor Admin" && a.ActiveFlag == "Y").FirstOrDefault();
if (GetVendorAdminId != null)
{
// Add data in VendorUser Table
VendorUser CU = new VendorUser();
CU.VendorUserId = Guid.NewGuid();
CU.Vendor = newVendor.VendorId;
CU.Role = GetVendorAdminId.RoleId;
CU.User = U.UserId;
CU.ActiveFlag = vendor.Status;
db.VendorUsers.Add(CU);
}
foreach (Guid value in vendor.ClientProblemClassId)
{
ClientVendorProblemClass CP = new ClientVendorProblemClass();
CP.ClientVendorProblemClassesId = Guid.NewGuid();
CP.ClientVendor = clientVendor.ClientVendorId;
CP.ProblemClass = value;
db.ClientVendorProblemClasses.Add(CP);
}
db.Vendors.Add(newVendor);
db.ClientVendors.Add(clientVendor);
if (db.SaveChanges() > 0)
{
UserID = U.UserId;
}
}
}
else
{
//we must need the vendor name
if (vendor.VendorName != null && vendor.VendorName.Trim().Length > 0)
{
#region No information entered by user for Vendor
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = vendor.VendorName != null ? vendor.VendorName : " ";
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = vendor.TaxId != null ? vendor.TaxId : " ";
newVendor.TaxIdisEIN = vendor.TaxIdisEIN != null ? vendor.TaxIdisEIN : " ";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = vendor.Status;
newVendor.AddressVerifiedFlag = "Y";
//client vendors
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = vendor.Status;
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
foreach (Guid value in vendor.ClientProblemClassId)
{
ClientVendorProblemClass CP = new ClientVendorProblemClass();
CP.ClientVendorProblemClassesId = Guid.NewGuid();
CP.ClientVendor = clientVendor.ClientVendorId;
CP.ProblemClass = value;
db.ClientVendorProblemClasses.Add(CP);
}
db.Vendors.Add(newVendor);
db.ClientVendors.Add(clientVendor);
if (db.SaveChanges() > 0)
{
UserID = newVendor.VendorId;
}
#endregion
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
public static VM_User ByEmail(string UserEmail)
{
VM_User user = null;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Exodus_Direct"].ConnectionString))
{
var cmd = new SqlCommand("stp_User_ByEmail", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("UserEmail", UserEmail);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable userMain = ds.Tables[0]; // Users
DataTable userInvitedBy = ds.Tables[1]; // UserInvitedBy
DataTable userLoginDetails = ds.Tables[2]; // UserLoginDetails
DataTable userHelpDetails = ds.Tables[3]; // UserHelpDetails
if (userMain.Rows.Count > 0)
{
user = new VM_User();
user.UserID = Convert.ToInt64(userMain.Rows[0]["UserID"]);
user.UserGuid = userMain.Rows[0]["UserGuid"].ToString();
user.UserFirstName = userMain.Rows[0]["UserFirstName"].ToString();
user.UserLastName = userMain.Rows[0]["UserLastName"].ToString();
user.UserType = (En_UserType)Convert.ToInt32(userMain.Rows[0]["UserTypeID"]);
user.UserStatus = (En_CurrentStatus)Convert.ToInt32(userMain.Rows[0]["UserStatusID"]);
user.UserStatusMessage = userMain.Rows[0]["UserStatusMessage"].ToString();
user.UserAbout = userMain.Rows[0]["UserAbout"].ToString();
user.UserRegistered = DateTime.Parse(userMain.Rows[0]["UserRegistered"].ToString());
user.UserRegistrationSource = (EN_RegistrationSource)int.Parse(userMain.Rows[0]["UserRegistrationSource"].ToString());
user.Avatar = new UserAvatar(userMain.Rows[0]["AvatarBIG"].ToString(), userMain.Rows[0]["AvatarSMALL"].ToString());
if (userInvitedBy.Rows.Count > 0)
{
user.UserInvitedBy = new VM_User
{
UserID = Convert.ToInt64(userInvitedBy.Rows[0]["UserID"]),
UserGuid = userInvitedBy.Rows[0]["UserGuid"].ToString()
};
user.UserStatus = (En_CurrentStatus)Convert.ToInt32(userMain.Rows[0]["UserStatusID"]);
user.UserInvitedBy.UserFirstName = userInvitedBy.Rows[0]["UserFirstName"].ToString();
user.UserInvitedBy.UserLastName = userInvitedBy.Rows[0]["UserLastName"].ToString();
user.UserInvitedBy.UserType = (En_UserType)Convert.ToInt32(userInvitedBy.Rows[0]["UserTypeID"]);
user.UserInvitedBy.UserAbout = userInvitedBy.Rows[0]["UserAbout"].ToString();
}
if (userLoginDetails.Rows.Count > 0)
{
user.UserEmail = userLoginDetails.Rows[0]["UserLogin"].ToString();
}
if (userHelpDetails.Rows.Count > 0)
{
user.HelpDetail = new VM_UserHelpDetail
{
HelpDetailID = Convert.ToInt64(userHelpDetails.Rows[0]["HelpDetailID"]),
UpdatedDateTime = DateTime.Parse(userHelpDetails.Rows[0]["UpdatedDateTime"].ToString()),
UserHelpAmountCurrency = (En_Currency)Convert.ToInt32(userHelpDetails.Rows[0]["fk_UserHelpAmountCurrencyID"]),
UserHelpAmountRequired = Convert.ToDecimal(userHelpDetails.Rows[0]["UserHelpAmountRequired"]),
UserHelpDetails = Convert.ToString(userHelpDetails.Rows[0]["UserHelpDetails"]),
UserHelpPeriod = (En_HelpPeriods)Convert.ToInt32(userHelpDetails.Rows[0]["fk_UserHelpPeriodID"]),
UserID = Convert.ToInt64(userHelpDetails.Rows[0]["fk_UserID"])
};
}
}
}
return(user);
}
