public Repository(
string instance,
string user,
string password,
type_of_authentication authenticationMode//SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
)
{
Connect(instance, user, password, authenticationMode);//SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
}
//SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
public bool Connect(string instance, string user, string password, type_of_authentication authenticationMode)
{
try
{
if ((instance.ToUpper() + "\\").StartsWith("(LOCAL)\\"))
{
m_ServerName = instance.ToUpper().Replace("(LOCAL)", Environment.MachineName).ToUpper();
}
else if ((instance + "\\").StartsWith(".\\"))
{
m_ServerName = instance.Replace(".", Environment.MachineName).ToUpper();
}
else if ((instance + "\\").StartsWith("localhost\\"))
{
m_ServerName = instance.Replace("localhost", Environment.MachineName).ToUpper();
}
else
{
m_ServerName = instance.ToUpper();
}
//Start-SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
if (authenticationMode == type_of_authentication.windows)
{
m_ConnectionStringBuilder = Sql.SqlHelper.ConstructConnectionString(m_ServerName, string.Empty, string.Empty, Utility.Activity.TypeServerOnPremise);
}
else
{
m_ConnectionStringBuilder = Sql.SqlHelper.ConstructConnectionString(m_ServerName, user, password, Utility.Activity.TypeServerOnPremise);
}
//End-SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
if (Connect())
{
//SQLsecure 3.1 (Tushar)--Saving UserName and Password in UserData object which will be saved in config file on closure of UI.
//m_User = user;
//m_Password = password;
UserData.Current.RepositoryInfo.UserName = m_User = user;
UserData.Current.RepositoryInfo.Password = m_Password = password;
UserData.Current.RepositoryInfo.AuthenticationMode = Convert.ToString(authenticationMode);//SQLsecure 3.1 (Tushar)--Supporting windows auth for repository connection
}
}
catch (SqlException ex)
{
logX.loggerX.Error(string.Format(Utility.ErrorMsgs.ErrorStub, Utility.ErrorMsgs.CantConnectRepository), ex);
MsgBox.ShowError(Utility.ErrorMsgs.CantConnectRepository, ex);
}
return(m_IsValid);
}
