private void SetDeleteCompanies(string VndNbr, string AcctID) { using (var conn = new SqlConnection(SQL_CONNECTION_STRING)) using (var command = new SqlCommand("s_DeleteCompanyAccount", conn) { CommandType = System.Data.CommandType.StoredProcedure }) { MyListAccount mla = new MyListAccount(); command.Parameters.AddWithValue("@VndNbr", VndNbr); command.Parameters.AddWithValue("@AcctID", AcctID); conn.Open(); var adapter = new SqlDataAdapter(command); var ds = new DataSet(); adapter.Fill(ds); } }
private void SetInsertUser(string AccountID, string userID) { using (var conn = new SqlConnection(SQL_CONNECTION_STRING)) using (var command = new SqlCommand("s_InsertUserAccount", conn) { CommandType = System.Data.CommandType.StoredProcedure }) { MyListAccount mla = new MyListAccount(); command.Parameters.AddWithValue("@PersonNbr", userID); command.Parameters.AddWithValue("@AcctID", AccountID); conn.Open(); var adapter = new SqlDataAdapter(command); var ds = new DataSet(); adapter.Fill(ds); } }
public MyListAccount SearchUser(int id, string appcode) { using (var conn = new SqlConnection(SQL_CONNECTION_STRING)) using (var command = new SqlCommand("s_GetUserAccounts", conn) { CommandType = System.Data.CommandType.StoredProcedure }) { MyListAccount mla = new MyListAccount(); command.Parameters.AddWithValue("@PersonNbr", id); command.Parameters.AddWithValue("@AcctTypeCode", appcode); conn.Open(); var adapter = new SqlDataAdapter(command); var ds = new DataSet(); adapter.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { mla.clientid = ds.Tables[0].Rows[0][2].ToString(); } return(mla); } }
private void AddAccount(string AccountTypCd, string AccountNbr, string Accountname, bool EnabledFlag) { using (var conn = new SqlConnection(SQL_CONNECTION_STRING)) using (var command = new SqlCommand("s_InsertAccount", conn) { CommandType = System.Data.CommandType.StoredProcedure }) { MyListAccount mla = new MyListAccount(); command.Parameters.AddWithValue("@AcctTypeCode", AccountTypCd); command.Parameters.AddWithValue("@AccountNbr", AccountNbr); command.Parameters.AddWithValue("@AccountName", Accountname); command.Parameters.AddWithValue("@EnabledFlag", EnabledFlag); conn.Open(); var adapter = new SqlDataAdapter(command); var ds = new DataSet(); adapter.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { mla.clientid = ds.Tables[0].Rows[0][2].ToString(); } } }