public string UpdateCustomerPoints(string custno, decimal points, string sqlsync) { string retval = "1"; SqlTransaction tran = null; try { var cn = new SqlConnection(sqlsync); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ta = new DsMasterTableAdapters.CUSTOMERTableAdapter(); ta.AssignConnection(cn, tran); ta.UpdateCustomerPoints(points, custno); tran.Commit(); } catch (Exception ex) { if (tran != null) tran.Rollback(); retval = ex.ToString(); } return retval; }
// new BLSales().GetShiftCode("POINTS") public void UpdateCustomerPoints(string custid, decimal points, bool usenewcon = false, string newcon = "p") { var ta = new DsMasterTableAdapters.CUSTOMERTableAdapter { Connection = { ConnectionString = usenewcon ? newcon : _constr } }; ta.UpdateCustomerPoints(points, custid); // CUSTOMERPOINT }