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