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)); } }