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