public void Verify_User_FeddConfig_DBData(string username)
{
int Uname_maxLength = Math.Min(username.Length, 50);
int Paswd_maxLength = Math.Min(Entered_Password.Length, 50);
int OptionalName_maxLength = Math.Min(Entered_OPtionalName.Length, 50);
int URL_Length = Math.Min(Entered_Url.Length, 50);
Entered_Username = username.Substring(0, Uname_maxLength);
Entered_Password = Entered_Password.Substring(0, Paswd_maxLength);
Entered_OPtionalName = Entered_OPtionalName.Substring(0, OptionalName_maxLength);
Entered_Url = Entered_Url.Substring(0, URL_Length);
FeedConfig_SavedDBData = Verify_FeddConfig_DBData(Entered_Username); // Get user feed config data from DB
Assert.AreEqual(true, FeedConfig_SavedDBData.UserName == Entered_Username, "Successful entry created for username");
string DB_Password = CommonMethod.DecryptRijndael(FeedConfig_SavedDBData.Password); //Retrive decrypted password
Assert.AreEqual(true, DB_Password == Entered_Password, "Successful entry created for Password");
if (Entered_OPtionalName == "")
{
Assert.AreEqual(true, FeedConfig_SavedDBData.OptionalName == "", "Successful entry created for optionalName");
}
else
{
Assert.AreEqual(true, FeedConfig_SavedDBData.OptionalName == Entered_OPtionalName, "Successful entry created for optionalName");
}
if (provider == "others")
{
Assert.AreEqual(true, FeedConfig_SavedDBData.Url == Entered_Url, "Successful entry created for URL");
}
}
public void VerifyUpdatedUserName_Password()
{
if (UpdateConnection_Flag == false)
{
bool msg_Status = Msg_UNamePaswd_CannotbeNull.Displayed;
Assert.AreEqual(true, msg_Status, "UserName/Password cannot be null/empty message is displayed");
}
else
{
FeedConfig_SavedDBData = Verify_UpadtedFeddConfig_DBData(ID_ConfiguredUsername);
string DBUpdated_Username = FeedConfig_SavedDBData.UserName;
string DBUpdated_Password = CommonMethod.DecryptRijndael(FeedConfig_SavedDBData.Password);
string DBUpdated_Url = FeedConfig_SavedDBData.Url;
Assert.AreEqual(true, Updated_Username == DBUpdated_Username, "UserName updated successfully in DB");
Assert.AreEqual(true, Updated_Password == DBUpdated_Password, "UserName updated successfully in DB");
}
}
public FeedConfig_DBModel Verify_UpadtedFeddConfig_DBData(int Id)
{
try
{
sql.Open();
string Query = @"select SPD.UserName,SPD.Password, SPD.OptionalName,SPCD.Url from serviceproviderdata SPD
left join Serviceprovidercustomdata SPCD
on SPD.Id = SPCD.serviceProviderData_id
where SPD.Id= @SPDId";
FeedConfig_SavedDBData = sql.Query <FeedConfig_DBModel>(Query, new { SPDId = Id }).FirstOrDefault();
}
catch (Exception e)
{ }
finally
{
sql.Close();
}
return(FeedConfig_SavedDBData);
}
