public static bool PrepareInsertReqOutParams(ref IDbCommand command, List <IDbDataParameter> outParamList, DbEngine dbEngine = DbEngine.MSSQLServer,
DbConnectivity connectivity = DbConnectivity.AdoDotNet)
{
int _rowsCount = command.Parameters != null ? command.Parameters.Count : 0;
foreach (IDbDataParameter param in outParamList)
{
command.Parameters.Add(param);
}
return(command.Parameters.Count == outParamList.Count + _rowsCount);
}
static void Main(string[] args)
{
try
{
DbConnectivity connect = new DbConnectivity();
connect.connection();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("1.Add Account\n2.View Account Details\n3.Withdrawl Amount\n4.Deposite Amount\nEnter the choice:");
int ch = int.Parse(Console.ReadLine());
switch (ch)
{
case 1:
BankOperation add = new BankOperation();
add.AddAcount();
break;
case 2:
BankOperation details = new BankOperation();
details.AccountDetails();
break;
case 3:
BankOperation withdraw = new BankOperation();
withdraw.Withdraw();
break;
case 4:
BankOperation deposite = new BankOperation();
deposite.Deposite();
break;
default:
Console.WriteLine("Wrong Choice:");
break;
}
}
public static IDbCommand CreateCommandObject(DbEngine dbEngine = DbEngine.MSSQLServer,
DbConnectivity connectivity = DbConnectivity.AdoDotNet)
{
switch (connectivity)
{
case DbConnectivity.Odbc:
return((IDbCommand)CreateObject <System.Data.Odbc.OdbcCommand>());
case DbConnectivity.OleDb:
return((IDbCommand)CreateObject <System.Data.OleDb.OleDbCommand>());
case DbConnectivity.AdoDotNet:
return(CreateCommandObject(dbEngine));
default:
error.ErrorCode = ErrorCode.AppError_InvalidDbConnectivity;
error.ErrorType = ErrorType.AppError;
throw new GenericFrameworkException(error);
}
}
public static IDbDataParameter CreateParameterObject(DbEngine dbEngine = DbEngine.MSSQLServer,
DbConnectivity connectivity = DbConnectivity.AdoDotNet)
{
switch (connectivity)
{
case DbConnectivity.Odbc:
return(CreateParameterObject(dbEngine));
case DbConnectivity.OleDb:
return(CreateParameterObject(dbEngine));
case DbConnectivity.AdoDotNet:
return(CreateParameterObject(dbEngine));
default:
error.ErrorCode = ErrorCode.AppError_InvalidDbConnectivity;
error.ErrorType = ErrorType.AppError;
throw new GenericFrameworkException(error);
}
}
public static List <System.Data.IDbDataParameter> CreateParameterList(DbEngine dbEngine = DbEngine.MSSQLServer, DbConnectivity connectivity = DbConnectivity.AdoDotNet)
{
switch (connectivity)
{
case DbConnectivity.Odbc:
return(new List <System.Data.Odbc.OdbcParameter>().Cast <System.Data.IDbDataParameter>().ToList());
case DbConnectivity.OleDb:
return(new List <System.Data.OleDb.OleDbParameter>().Cast <System.Data.IDbDataParameter>().ToList());
case DbConnectivity.AdoDotNet:
return(new List <System.Data.SqlClient.SqlParameter>().Cast <System.Data.IDbDataParameter>().ToList());
default:
error.ErrorCode = ErrorCode.AppError_InvalidDbConnectivity;
error.ErrorType = ErrorType.AppError;
throw new GenericFrameworkException(error);
}
}
public static System.Data.IDbDataParameter CreateParameterObject(string paramName, System.Data.ParameterDirection paramDirection,
DbType dbType, object paramValue, int Size, DbEngine dbEngine = DbEngine.MSSQLServer, DbConnectivity connectivity = DbConnectivity.AdoDotNet)
{
System.Data.IDbDataParameter param = CreateParameterObject(dbEngine, connectivity);
param.ParameterName = paramName;
param.Direction = paramDirection;
param.Value = paramValue;
param.DbType = dbType;
param.Size = Size;
return(param);
}
