public void AssignDatatype(string datatype, Datatypesource source) { if (source == Datatypesource.REDCap) { List <string> inttypes = new List <string> { "radio", "yesno" }; List <string> floattypes = new List <string> { "number" }; List <string> texttypes = new List <string> { "text", "notes" }; List <string> datetypes = new List <string> { "date_mdy" }; List <string> datetimetypes = new List <string> { "time" }; if (inttypes.Contains(datatype)) { _sqldatatype = SqlDatatype.Integer; } else if (texttypes.Contains(datatype)) { _sqldatatype = SqlDatatype.Varchar; } else if (floattypes.Contains(datatype)) { _sqldatatype = SqlDatatype.Float; } else if (datetypes.Contains(datatype)) { _sqldatatype = SqlDatatype.Date; } else if (datetimetypes.Contains(datatype)) { _sqldatatype = SqlDatatype.DateTime; } else { _sqldatatype = SqlDatatype.Varchar; } } else if (source == Datatypesource.DxChartsettings) { if (datatype == "int") { _sqldatatype = SqlDatatype.Integer; } else if (datatype == "num" | datatype == "int" | datatype == "float") { _sqldatatype = SqlDatatype.Float; } else if (datatype == "date") { _sqldatatype = SqlDatatype.Date; } else if (datatype == "text") { _sqldatatype = SqlDatatype.Varchar; } else { _sqldatatype = SqlDatatype.Varchar; } } }
public Datatype(SqlDatatype mySqlDatatype) { _sqldatatype = mySqlDatatype; }