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
}
