public static SqlConnection GetConnection() { SqlConnection con = ConnectionGetway.GetConnection(); if (con.State == ConnectionState.Closed) { con.Open(); } return(con); }
public bool ProcessSalary(string companyCode, string month) { using (var con = ConnectionGetway.GetConnection()) { con.Open(); using (var tran = con.BeginTransaction()) { try { var topLevelSalesman = _salesman.GetAssociates(companyCode, companyCode); _salary.CreateNewSalaryAcc(con, tran, companyCode, month); ProcessOrdinalCommission(con, tran, companyCode); ProcessSalesBoundGbCommission(con, tran, topLevelSalesman); tran.Commit(); return(true); } catch (Exception err) { tran.Rollback(); throw (err); } } } }
public static void Initialize(string server, string database, string userId, string password) { ConnectionGetway.Initialize(server, database, userId, password); }
public static void Initialize(string server, string database) { ConnectionGetway.Initialize(server, database); }