private SqlCommand GetInsertCommand(String PCommandText, List <JkFormParameter> PParams)
{
SqlCommand Command = new SqlCommand();
SqlDataAdapter Adapter = new SqlDataAdapter(PCommandText, VConnectionString);
SqlCommandBuilder CommandBuilder = new SqlCommandBuilder();
if (PParams != null)
{
for (int i = 0; i <= PParams.Count - 1; i++)
{
if (String.IsNullOrWhiteSpace(PParams[i].Value))
{
Adapter.SelectCommand.Parameters.AddWithValue("@" + PParams[i].Name, 0);
}
else
{
Adapter.SelectCommand.Parameters.AddWithValue("@" + PParams[i].Name, IAppHandler.ConvertMaskValue(PParams[i].Value));
}
}
}
CommandBuilder.DataAdapter = Adapter;
Command = CommandBuilder.GetInsertCommand();
return(Command);
}
public DataTable LoadData(String PCommandText, List <JkFormParameter> PParamList, String CustomConnectionString = null)
{
DataTable PDataTable = new DataTable();
SqlDataAdapter DataAdapter = new SqlDataAdapter(PCommandText, CustomConnectionString ?? VConnectionString);
String TableName = ExtractTableName(PCommandText);
try
{
try
{
if (PParamList != null)
{
for (int i = 0; i <= PParamList.Count - 1; i++)
{
if (String.IsNullOrWhiteSpace(PParamList[i].Value))
{
DataAdapter.SelectCommand.Parameters.AddWithValue("@" + PParamList[i].Name, 0);
}
else
{
DataAdapter.SelectCommand.Parameters.AddWithValue("@" + PParamList[i].Name, IAppHandler.ConvertMaskValue(PParamList[i].Value));
}
}
}
DataAdapter.FillSchema(VDataset, SchemaType.Source, TableName);
DataAdapter.Fill(VDataset, TableName);
PDataTable = VDataset.Tables[TableName];
}
catch (Exception err)
{
IMessageHandler.ShowError(ISystemMessages.LoadDataError + err.Message);
}
}
finally
{
DataAdapter.SelectCommand.Connection.Close();
DataAdapter.Dispose();
}
return(PDataTable);
}
