public bool IsLoginNameExist(string providerName)
{
using (EDL_CONFIG_DBEntities db = new EDL_CONFIG_DBEntities())
{
return(db.EDL_DataProviderEnrollmentConfig.Where(o => o.ProviderName.Equals(providerName)).Any());
}
}
public List <ProviderUserView> GetAllUserProfiles()
{
List <ProviderUserView> profiles = new List <ProviderUserView>();
using (EDL_CONFIG_DBEntities db = new EDL_CONFIG_DBEntities())
{
ProviderUserView UPV;
var users = db.EDL_DataProviderEnrollmentConfig.ToList();
foreach (EDL_DataProviderEnrollmentConfig u in db.EDL_DataProviderEnrollmentConfig)
{
UPV = new ProviderUserView();
UPV.ProviderName = u.ProviderName;
UPV.DataLakeLandingFilePath = u.DataLakeLandingFilePath;
UPV.FileSchedule = u.FileSchedule;
UPV.NumberofFilesExpected = (Int32)u.NumberofFilesExpected;
UPV.NumberofFilesPlaced = (Int32)u.NumberofFilesPlaced;
UPV.ProviderCredentials = u.ProviderCredentials;
profiles.Add(UPV);
}
}
return(profiles);
}
public void AddUserAccount(ProviderUserModel user)
{
using (EDL_CONFIG_DBEntities db = new EDL_CONFIG_DBEntities())
{
EDL_DataProviderEnrollmentConfig SU = new EDL_DataProviderEnrollmentConfig();
SU.ProviderName = user.ProviderName;
SU.DataLakeLandingFilePath = user.DataLakeLandingFilePath;
SU.FileSchedule = user.FileSchedule;
SU.ProviderCredentials = user.ProviderCredentials;
SU.NumberofFilesExpected = 1;
SU.NumberofFilesPlaced = 1;
SU.CreateUser = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
SU.UpdateUser = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
SU.CreateDate = DateTime.Now;
SU.UpdateDate = DateTime.Now;
SU.Active = true;
db.EDL_DataProviderEnrollmentConfig.Add(SU);
db.SaveChanges();
}
}
