public static DateTimeOffset?GetConvertdatetimeoffset(this IDataRecord dr, int i) { if (dr.IsDBNull(i)) { return(default(DateTimeOffset)); } var date = dr.GetValue(i); if (date is DateTime) { return(UtilMethods.GetDateTimeOffsetByDateTime((DateTime)(date))); } else { var result = (DateTimeOffset)date; return(result); } }
public static object ConvertDataByTypeName(string ctypename, string value) { var item = new ConditionalModel() { CSharpTypeName = ctypename, FieldValue = value }; if (item.CSharpTypeName.EqualCase(UtilConstants.DecType.Name)) { return(Convert.ToDecimal(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.DobType.Name)) { return(Convert.ToDouble(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.DateType.Name)) { return(Convert.ToDateTime(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.IntType.Name)) { return(Convert.ToInt32(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.LongType.Name)) { return(Convert.ToInt64(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.ShortType.Name)) { return(Convert.ToInt16(item.FieldValue)); } else if (item.CSharpTypeName.EqualCase(UtilConstants.DateTimeOffsetType.Name)) { return(UtilMethods.GetDateTimeOffsetByDateTime(Convert.ToDateTime(item.FieldValue))); } else { return(item.FieldValue); } }