public static object SQLiteTypeValue(EbDbTypes EbDbType, object Value)
{
if (EbDbType == EbDbTypes.String)
{
return(Value?.ToString());
}
else if (EbDbType == EbDbTypes.Int16 || EbDbType == EbDbTypes.Int32)
{
int.TryParse(Value?.ToString(), out int i);
return(i);
}
else if (EbDbType == EbDbTypes.Decimal || EbDbType == EbDbTypes.Double)
{
double.TryParse(Value?.ToString(), out double i);
return(i);
}
else if (EbDbType == EbDbTypes.Boolean || EbDbType == EbDbTypes.BooleanOriginal)
{
bool.TryParse(Value?.ToString(), out bool i);
return(i ? 1 : 0);
}
else
{
return(Value);
}
}
public static string SQLiteType(EbDbTypes EbDbType)
{
if (EbDbType == EbDbTypes.String)
{
return("TEXT");
}
else if (EbDbType == EbDbTypes.Int16 || EbDbType == EbDbTypes.Int32)
{
return("INT");
}
else if (EbDbType == EbDbTypes.Decimal || EbDbType == EbDbTypes.Double)
{
return("REAL");
}
else if (EbDbType == EbDbTypes.Date || EbDbType == EbDbTypes.DateTime)
{
return("DATETIME");
}
else if (EbDbType == EbDbTypes.Boolean || EbDbType == EbDbTypes.BooleanOriginal)
{
return("INT");
}
else
{
return("TEXT");
}
}
//tbl -> master table name, ins -> is insert, _col -> cols/colvals, _extqry -> extended query, ocF -> old column field
public virtual bool ParameterizeControl(ParameterizeCtrl_Params args, string crudContext)
{
if (this.BypassParameterization && args.cField.Value == null)
{
throw new Exception($"Unable to proceed/bypass with value '{args.cField.Value}' for {this.Name}");
}
string paramName = args.cField.Name + crudContext;
if (args.cField.Value == null || (this.EbDbType == EbDbTypes.Decimal && Convert.ToString(args.cField.Value) == string.Empty))
{
var p = args.DataDB.GetNewParameter(paramName, (EbDbTypes)args.cField.Type);
p.Value = DBNull.Value;
args.param.Add(p);
}
else if (!this.BypassParameterization)
{
EbDbTypes _t = (EbDbTypes)args.cField.Type;
if (_t == EbDbTypes.Decimal || _t == EbDbTypes.Int32)
{
if (!double.TryParse(Convert.ToString(args.cField.Value), out double temp))
{
throw new Exception($"Unable to proceed with value '{args.cField.Value}' for {this.Name}");
}
}
args.param.Add(args.DataDB.GetNewParameter(paramName, (EbDbTypes)args.cField.Type, args.cField.Value));
}
if (args.ins)
{
args._cols += args.cField.Name + CharConstants.COMMA + CharConstants.SPACE;
if (this.BypassParameterization)
{
args._vals += Convert.ToString(args.cField.Value) + CharConstants.COMMA + CharConstants.SPACE;
}
else
{
args._vals += CharConstants.AT + paramName + CharConstants.COMMA + CharConstants.SPACE;
}
}
else
{
if (this.BypassParameterization)
{
args._colvals += args.cField.Name + CharConstants.EQUALS + Convert.ToString(args.cField.Value) + CharConstants.COMMA + CharConstants.SPACE;
}
else
{
args._colvals += args.cField.Name + CharConstants.EQUALS + CharConstants.AT + paramName + CharConstants.COMMA + CharConstants.SPACE;
}
}
args.i++;
return(true);
}
public void SetEbDbType(string name, EbDbTypes ebDbType)
{
for (int i = 0; i < this.Columns.Count; i++)
{
if (this.Columns[i].Name.Equals(name))
{
this.Columns[i].Type = (int)ebDbType;
return;
}
}
throw new KeyNotFoundException("KeyNotFoundException : Key = " + name);
}
public DbTypedValue(string Name, object Value, EbDbTypes Type)
{
if (Name == "eb_created_at_device")
{
this.Type = EbDbTypes.DateTime;
}
else
{
this.Type = Type;
this.Value = Value;
}
}
public dynamic GetDataFieldValue(string column_name, int i, int tableIndex)
{
dynamic value = null;
int index;
if (DataSet != null && DataSet.Tables.Count > 0 && DataSet.Tables[tableIndex].Rows?.Count > 0)
{
index = (DataSet.Tables[tableIndex].Rows.Count > 1) ? i : 0;
EbDbTypes type = (DataSet.Tables[tableIndex].Columns[column_name].Type);
value = (type == EbDbTypes.Bytea) ? DataSet.Tables[tableIndex].Rows[index][column_name] : DataSet.Tables[tableIndex].Rows[index][column_name].ToString();
}
return(value);
}
private void AddParam(IDatabase DataDB, List <DbParameter> param, int i, EbDbTypes type, Dictionary <string, string> _d, Dictionary <string, string> _od, string key, object altVal)
{
if (_d.ContainsKey(key))
{
altVal = _d[key];
}
else if (_od != null && _od.ContainsKey(key))
{
altVal = _od[key];
}
param.Add(DataDB.GetNewParameter($"{key}_{i}", type, altVal));
}
public DbTypedValue GetDbType(string name, object value, EbDbTypes type)
{
DbTypedValue TV = new DbTypedValue(name, value, type);
EbMobileControl ctrl = ControlDictionary.ContainsKey(name) ? ControlDictionary[name] : null;
if (ctrl != null)
{
TV.Type = ctrl.EbDbType;
TV.Value = ctrl.SQLiteToActual(value);
}
else
{
if (TV.Type == EbDbTypes.Date)
{
TV.Value = Convert.ToDateTime(value).ToString("yyyy-MM-dd");
}
else if (TV.Type == EbDbTypes.DateTime)
{
TV.Value = Convert.ToDateTime(value).ToString("yyyy-MM-dd HH:mm:ss");
}
}
return(TV);
}
public DbTypedValue GetDbType(string name, object value, EbDbTypes type)
{
DbTypedValue TV = new DbTypedValue(name, value, type);
EbMobileControl ctrl = ChildControls.Find(item => item.Name == name);
if (ctrl != null)
{
TV.Type = ctrl.EbDbType;
TV.Value = ctrl.SQLiteToActual(value);
}
else
{
if (type == EbDbTypes.Date)
{
TV.Value = Convert.ToDateTime(value).ToString("yyyy-MM-dd");
}
else if (type == EbDbTypes.DateTime)
{
TV.Value = Convert.ToDateTime(value).ToString("yyyy-MM-dd HH:mm:ss");
}
}
return(TV);
}
public void DoLoopInDetail(int serialnumber)
{
ph_Yposition = (PageNumber == 1) ? ReportHeaderHeight + this.Margin.Top : this.Margin.Top;
dt_Yposition = ph_Yposition + PageHeaderHeight;
foreach (EbReportDetail detail in Detail)
{
string column_val;
RowHeight = 0;
MultiRowTop = 0;
EbDataField[] SortedList = FieldsNotSummaryPerDetail[detail];
EbPdfGlobals globals = new EbPdfGlobals();
for (int iSortPos = 0; iSortPos < SortedList.Length; iSortPos++)
{
EbDataField field = SortedList[iSortPos];
if (field is EbCalcField)
{
//globals.CurrentField = field;
column_val = (field as EbCalcField).GetCalcFieldValue(globals, DataSet, serialnumber, this);
EbDbTypes dbtype = (EbDbTypes)((field as EbCalcField).CalcFieldIntType);
if (CalcValInRow.ContainsKey(field.Title))
{
CalcValInRow[field.Title] = new PdfNTV {
Name = field.Title, Type = (PdfEbDbTypes)(int)dbtype, Value = column_val
}
}
;
else
{
CalcValInRow.Add(field.Title, new PdfNTV {
Name = field.Title, Type = (PdfEbDbTypes)(int)dbtype, Value = column_val
});
}
AddParamsNCalcsInGlobal(globals);
}
else
{
column_val = GetDataFieldValue(field.ColumnName, serialnumber, field.TableIndex);
}
if (field.RenderInMultiLine)
{
field.DoRenderInMultiLine(column_val, this);
}
}
EbReportField[] SortedReportFields = this.ReportFieldsSortedPerDetail[detail];
if (SortedReportFields.Length > 0)
{
for (int iSortPos = 0; iSortPos < SortedReportFields.Length; iSortPos++)
{
EbReportField field = SortedReportFields[iSortPos];
if (field is EbDataField)
{
field.HeightPt += RowHeight;
}
DrawFields(field, dt_Yposition, serialnumber);
}
detailprintingtop += detail.HeightPt + RowHeight;
detailEnd = detailprintingtop;
}
else
{
detailEnd = detailprintingtop;
IsLastpage = true;
Writer.PageEvent.OnEndPage(Writer, Doc);
return;
}
}
}
public EbDataColumn NewDataColumn(int index, string name, EbDbTypes type)
{
return(new EbDataColumn(index, name, type));
}
public VendorDbType(EbDbTypes type, dynamic vDbType, string vDbText)
{
this.EbDbType = type;
this.VDbType = vDbType;
this.VDbText = vDbText;
}
public abstract DbParameter GetNewOutParameter(string parametername, EbDbTypes type);
// DbCommand GetNewCommand(DbConnection con, string sql, DbTransaction trans); public abstract DbParameter GetNewParameter(string parametername, EbDbTypes type, object value);
public EbDataColumn(string columnname, EbDbTypes type)
{
this.ColumnName = columnname;
this.Type = type;
}
public MobileTableColumn(string name, EbDbTypes type, object value)
{
Name = name;
Type = type;
Value = value;
}
public EbDataColumn(int index, string columnname, EbDbTypes type)
{
this.ColumnIndex = index;
this.ColumnName = columnname;
this.Type = type;
}
public override void DrawMe(float printingTop, EbReport Rep, List <Param> Params, int slno)
{
ColumnText ct = new ColumnText(Rep.Canvas);
string column_val = string.Empty;
EbDbTypes dbtype = EbDbTypes.String;
EbPdfGlobals globals = new EbPdfGlobals();
try
{
column_val = Rep.ExecuteExpression(Rep.ValueScriptCollection[Name], slno, globals, DataFieldsUsedInCalc, true).ToString();
dbtype = (EbDbTypes)CalcFieldIntType;
if (Rep.CalcValInRow.ContainsKey(Title))
{
Rep.CalcValInRow[Title] = new PdfNTV {
Name = Title, Type = (PdfEbDbTypes)(int)dbtype, Value = column_val
}
}
;
else
{
Rep.CalcValInRow.Add(Title, new PdfNTV {
Name = Title, Type = (PdfEbDbTypes)(int)dbtype, Value = column_val
});
}
}
catch (Exception e)
{
Console.WriteLine(e.Message + e.StackTrace);
}
if (SuppressIfZero && !(Convert.ToDecimal(column_val) > 0))
{
column_val = String.Empty;
}
else
{
if (dbtype == EbDbTypes.Decimal)
{
column_val = FormatDecimals(column_val, AmountInWords, DecimalPlaces, Rep.CultureInfo?.NumberFormat, FormatUsingCulture);
}
if (Prefix != "" || Suffix != "")
{
column_val = Prefix + " " + column_val + " " + Suffix;
}
}
Phrase phrase = GetPhrase(column_val, (DbType)DbType, Rep.Font);
if (!string.IsNullOrEmpty(LinkRefId))
{
Anchor a = CreateLink(phrase, LinkRefId, Rep.Doc, Params);
Paragraph p = new Paragraph {
a
};
p.Font = GetItextFont(this.Font, Rep.Font);
ct.AddText(p);
}
else
{
ct.AddText(phrase);
}
float ury = Rep.HeightPt - (printingTop + TopPt + Rep.detailprintingtop);
float lly = Rep.HeightPt - (printingTop + TopPt + HeightPt + Rep.detailprintingtop);
ct.SetSimpleColumn(Llx, lly, Urx, ury, Leading, (int)TextAlign);
ct.Go();
}
