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