public static IResult WriteConnectionData(ConnectionValuesModel connectionValuesModel)
{
try
{
if (!Directory.Exists(Application.StartupPath + @"\AppSetting"))
{
Directory.CreateDirectory(Application.StartupPath + @"\AppSetting");
}
var settings = new XmlWriterSettings {
Indent = true
};
var writter = XmlWriter.Create(Application.StartupPath + @"\AppSetting\ConnectionSetting.xml", settings);
writter.WriteStartDocument();
writter.WriteComment("Created by KARYA");
writter.WriteStartElement("Connection");
writter.WriteAttributeString("Server", connectionValuesModel.Server);
writter.WriteAttributeString("Database", connectionValuesModel.Database);
writter.WriteAttributeString("User", connectionValuesModel.User);
writter.WriteAttributeString("Password", connectionValuesModel.Password);
writter.WriteEndElement();
writter.WriteEndDocument();
writter.Flush();
writter.Close();
return(new SuccessResult("Saved succesfully"));
}
catch (Exception ex)
{
return(new ErrorResult(ex.Message));
}
}
private bool SaveSetting()
{
var connData = new ConnectionValuesModel
{
Server = txt_server.Text,
Database = txt_database.Text,
User = txt_user.Text,
Password = txt_password.Text
};
var result = FileFunctions.WriteConnectionData(connData);
if (result.Success)
{
lbl_Message.ForeColor = Color.Green;
lbl_Message.Text = result.Message;
return(true);
}
else
{
lbl_Message.ForeColor = Color.Maroon;
lbl_Message.Text = result.Message;
return(false);
}
}
public static IResult TestConnection(ConnectionValuesModel connectionValuesModel)
{
var connectionString = $"Server={connectionValuesModel.Server};Database={connectionValuesModel.Database};User Id={connectionValuesModel.User};Password={connectionValuesModel.Password};";
using (var conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
return(new SuccessResult("Connection is successful"));
}
catch (SqlException ex)
{
return(new ErrorResult(ex.Message));
}
}
}
private void btn_test_Click(object sender, EventArgs e)
{
var connData = new ConnectionValuesModel
{
Server = txt_server.Text,
Database = txt_database.Text,
User = txt_user.Text,
Password = txt_password.Text
};
var result = DatabaseConnection.TestConnection(connData);
if (result.Success)
{
lbl_Message.ForeColor = Color.Green;
lbl_Message.Text = result.Message;
}
else
{
lbl_Message.ForeColor = Color.Maroon;
lbl_Message.Text = result.Message;
}
}
public static IDataResult <ConnectionValuesModel> ReadConnectionData()
{
var connData = new ConnectionValuesModel();
try
{
if (File.Exists(Application.StartupPath + $@"\AppSetting\ConnectionSetting.xml"))
{
var reader = XmlReader.Create(Application.StartupPath + $@"\AppSetting\ConnectionSetting.xml");
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.Element && reader.Name == "Connection")
{
connData.Server = reader.GetAttribute(0);
connData.Database = reader.GetAttribute(1);
connData.User = reader.GetAttribute(2);
connData.Password = reader.GetAttribute(3);
}
}
reader.Close();
reader.Dispose();
return(new SuccessDataResult <ConnectionValuesModel>(connData, "Connection Setting file saved successfully"));
}
else
{
return(new ErrorDataResult <ConnectionValuesModel>(connData, "Connection Setting file was not created"));
}
}
catch (Exception ex)
{
return(new ErrorDataResult <ConnectionValuesModel>(connData, ex.Message));
}
}
