public UserViewModel LoginUser(LoginViewModel model)
{
using (var context = new DmsDomainContext())
{
// If using Code First we need to make sure the model is built before we open the connection
// This isn't required for models created with the EF Designer
context.Database.Initialize(force: false);
// Create a SQL command to execute the sproc
var cmd = context.Database.Connection.CreateCommand();
cmd.CommandText = "EXEC sp_userlogin @email ,@password";
cmd.Parameters.Add(new SqlParameter("email", model.UserName));
cmd.Parameters.Add(new SqlParameter("password", CommonFunction.EncryptPassword(model.Password)));
context.Database.Connection.Open();
// Run the sproc
var reader = cmd.ExecuteReader();
// Read the first result set
UserViewModel Userviewmodel =
((IObjectContextAdapter)context)
.ObjectContext
.Translate <UserViewModel>(reader)
.FirstOrDefault();
return(Userviewmodel);
}
}
/// <summary>
/// CreatedDate:23-Nov-2017
/// Desc:Update record of Individual Users
/// </summary>
/// <param name="objIndividualRegistrationViewModel"></param>
/// <returns></returns>
public bool UpdateIndividualClient(IndividualRegistrationViewModel objIndividualRegistrationViewModel)
{
try
{
using (DataContext = new DmsDomainContext())
{
Individual objIndividual = new Individual();
objIndividual = DataContext.Individuals.Where(x => x.IndividualRecordId == objIndividualRegistrationViewModel.IndividualRecordId).FirstOrDefault();
objIndividual.FirstName = objIndividualRegistrationViewModel.FirstName;
objIndividual.MiddleName = objIndividualRegistrationViewModel.MiddleName;
objIndividual.LastName = objIndividualRegistrationViewModel.LastName;
objIndividual.BirthDate = Convert.ToDateTime(objIndividualRegistrationViewModel.BirthDate);
objIndividual.Prefix = objIndividualRegistrationViewModel.Prefix; //1 for Mr., 2 for Ms.
objIndividual.Suffix = objIndividualRegistrationViewModel.Suffix;
objIndividual.SSN = Convert.ToString(objIndividualRegistrationViewModel.SSN);
objIndividual.Phone = objIndividualRegistrationViewModel.Phone;
objIndividual.ModifiedDate = DateTime.Now;
objIndividual.ModifiedBy = objIndividualRegistrationViewModel.IndividualRecordId;
objIndividual.IsDeleted = false;
DataContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateFirm(FirmViewModel model)
{
try
{
using (DataContext = new DmsDomainContext())
{
Firm objFirm = new Firm();
objFirm = DataContext.Firms.Where(x => x.FirmId == model.FirmId).FirstOrDefault();
objFirm.FirmId = Convert.ToInt32(SessionManagement.LoggedInUser.FirmId);
objFirm.FirmName = model.FirmName;
objFirm.FirmEmail = model.FirmEmail;
objFirm.IsActive = true;
objFirm.IsDeleted = false;
objFirm.ModifiedDate = DateTime.Now;
objFirm.ModifiedBy = 5534534543545;
objFirm.CreatedDate = DateTime.Now;
objFirm.CreatedBy = 5534534543545;
DataContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw;
}
}
public IndividualRepository()
{
if (uow == null)
{
DataContext = new DmsDomainContext();
uow = new UnityOfWork(DataContext);
}
}
public ClientRepository()
{
if (uow == null)
{
SubDataContext = new DmsSubDomainContext();
DataContext = new DmsDomainContext();
uow = new UnityOfWork(DataContext);
subuow = new UnityOfWork(SubDataContext);
}
}
public bool DeleteFirm(long FirmId)
{
try
{
using (DataContext = new DmsDomainContext())
{
var _entity = DataContext.Firms.Where(x => x.FirmId == FirmId).FirstOrDefault();
_entity.IsDeleted = true;
DataContext.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public Firm GetFirm(long FirmId)
{
try
{
using (DataContext = new DmsDomainContext())
{
Firm objFirm = new Firm();
objFirm = DataContext.Firms.Where(x => x.FirmId == FirmId).Include(y => y.Users).FirstOrDefault();
return(objFirm);
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// CreatedDate:23-Nov-2017
/// Desc:Get Detail of Individual Users
/// </summary>
/// <returns></returns>
public IndividualRegistrationViewModel GetIndividualClientDetail(long?UserID)
{
using (DataContext = new DmsDomainContext())
{
User objUser = new User();
objUser = DataContext.Users.Where(x => x.UserId == UserID).FirstOrDefault();
IndividualRegistrationViewModel objIndividualRegistrationViewModel = new IndividualRegistrationViewModel();
objIndividualRegistrationViewModel.IndividualRecordId = objUser.IndividualRecordId;
objIndividualRegistrationViewModel.FirstName = objUser.Individual.FirstName;
objIndividualRegistrationViewModel.MiddleName = objUser.Individual.MiddleName;
objIndividualRegistrationViewModel.LastName = objUser.Individual.LastName;
objIndividualRegistrationViewModel.BirthDate = Convert.ToDateTime(objUser.Individual.BirthDate).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
objIndividualRegistrationViewModel.SSN = objUser.Individual.SSN;
objIndividualRegistrationViewModel.Prefix = objUser.Individual.Prefix;
objIndividualRegistrationViewModel.Suffix = objUser.Individual.Suffix;
objIndividualRegistrationViewModel.Phone = objUser.Individual.Phone;
objIndividualRegistrationViewModel.UserName = objUser.UserName;
objIndividualRegistrationViewModel.EmailAddress = objUser.Email;
return(objIndividualRegistrationViewModel);
}
}