/// <summary>
/// Shows the values for the given provider
/// </summary>
/// <param name="provider">The provider</param>
private void ShowData(CustomEnums.Provider provider)
{
_provider = provider;
_mappingData = ConfigManager.GetData();
SetSource(_mappingData.Where(w => w.Provider == provider).ToList());
}
/// <summary>
/// Generates the class
/// </summary>
/// <param name="provider">The provider</param>
/// <param name="className">The name of the class</param>
/// <param name="autoProperty">true if only auto properties are needed, otherwise false</param>
/// <param name="tableModel">The list of the columns</param>
/// <returns>The generated class</returns>
public static string CreateClass(CustomEnums.Provider provider, string className, bool autoProperty, List <ColumnModel> tableModel)
{
if (tableModel == null)
{
throw new ArgumentNullException(nameof(tableModel));
}
var result = $"public class {className}\r\n{{\r\n";
foreach (var column in tableModel)
{
if (autoProperty)
{
result += $"\tpublic {GetType(provider, column.Type)} {column.Field.FirstCharToUpper()} {{ get; set; }}\r\n";
}
else
{
result += $"\tprivate {GetType(provider, column.Type)} _{column.Field.FirstCharToLower()};\r\n";
result += $"\tpublic {GetType(provider, column.Type)} {column.Field.FirstCharToUpper()}\r\n\t{{\r\n" +
$"\t\tget {{ return _{column.Field.FirstCharToLower()}; }}\r\n" +
$"\t\tset {{ _{column.Field.FirstCharToLower()} = value; }}\r\n\t}}\r\n\r\n";
}
}
return($"{result}}}");
}
/// <summary>
/// Occurs when the form was shown
/// </summary>
private void ClassGenerator_Shown(object sender, EventArgs e)
{
var selector = new SourceSelection();
if (selector.ShowDialog() == DialogResult.OK)
{
_provider = selector.Provider;
_mySqlRepo = selector.MySqlConnection;
_msSqlRepo = selector.MsSqlConnection;
ShowDatabases();
}
}
/// <summary>
/// Gets the according c sharp data type
/// </summary>
/// <param name="provider">The provider</param>
/// <param name="type">The sql data type</param>
/// <returns>The c# type</returns>
public static string GetType(CustomEnums.Provider provider, string type)
{
const string defaultMappingType = "TypeMissing";
var mappingList = ConfigManager.GetData();
if (mappingList == null || mappingList.Count == 0)
{
return(defaultMappingType);
}
var entry =
mappingList.FirstOrDefault(w => w.Provider == provider && w.SqlType.ToLower().Equals(type));
return(entry == null ? defaultMappingType : entry.CSharpType);
}
/// <summary>
/// Occurs when the user selects a provider
/// </summary>
private void comboProvider_SelectedIndexChanged(object sender, EventArgs e)
{
var provider = comboProvider.SelectedItem as ComboBoxItem;
if (provider == null)
{
return;
}
if ((CustomEnums.Provider)provider.Value == CustomEnums.Provider.None)
{
return;
}
Provider = (CustomEnums.Provider)provider.Value;
txtServer.Enabled = true;
txtUser.Enabled = true;
txtPassword.Enabled = true;
btnConnectToServer.Enabled = true;
checkWindowsAuthentication.Enabled = Provider == CustomEnums.Provider.MsSql;
}
/// <summary>
/// Creates a new instance of the form
/// </summary>
/// <param name="provider">The provider</param>
/// <param name="columnList"></param>
public ColumnSelector(CustomEnums.Provider provider, List <ColumnModel> columnList)
{
InitializeComponent();
ColumnList = columnList;
_provider = provider;
}
