public List <BusinessEmployeeAccess> SelectAllByBusinessId(string businessId)
{
List <BusinessEmployeeAccess> employees = new List <BusinessEmployeeAccess>();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString))
{
using (SqlDataAdapter sda = new SqlDataAdapter(
"SELECT [dbo].[BusinessEmployeeAccess].*, " +
"[dbo].[BusinessUser].[id] userId, " +
"[dbo].[BusinessUser].[name] userName, " +
"[dbo].[BusinessUser].[email] userEmail, " +
"[dbo].[BusinessUser].[phone] userPhone " +
"FROM [dbo].[BusinessEmployeeAccess] " +
"INNER JOIN [dbo].[BusinessUser] " +
"ON [dbo].[BusinessEmployeeAccess].[userId] = dbo.BusinessUser.id " +
"WHERE [businessId] = @BusinessId;", con))
{
sda.SelectCommand.Parameters.AddWithValue("@BusinessId", businessId.Trim());
DataSet ds = new DataSet();
sda.Fill(ds);
int rec_cnt = ds.Tables[0].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
string id = row["id"].ToString();
string userId = row["userId"].ToString();
string roleId = row["roleId"].ToString();
bool rApp = Convert.ToBoolean(row["readAppointment"]);
bool wApp = Convert.ToBoolean(row["writeAppointment"]);
bool rCC = Convert.ToBoolean(row["readCustomerChat"]);
bool wCC = Convert.ToBoolean(row["writeCustomerChat"]);
bool accepted = Convert.ToBoolean(row["accepted"]);
string eId = row["userId"].ToString();
string eName = row["userName"].ToString();
string eEmail = row["userEmail"].ToString();
string ePhone = row["userPhone"].ToString();
BusinessEmployeeAccess bea = new BusinessEmployeeAccess(id, userId, businessId, roleId, rApp, wApp, rCC, wCC, accepted, new BusinessUser(eName, eEmail, "bruhbruhbruh", ePhone));
employees.Add(bea);
}
}
}
}
return(employees);
}
public List <BusinessEmployeeAccess> SelectAcceptedByUserId(string userId)
{
List <BusinessEmployeeAccess> employeeBeas = new List <BusinessEmployeeAccess>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString))
{
using (SqlDataAdapter sda = new SqlDataAdapter(
"SELECT * " +
"FROM BusinessEmployeeAccess " +
"WHERE [userId] = @UserId AND [accepted] = 1;", con))
{
sda.SelectCommand.Parameters.AddWithValue("@UserId", userId);
DataSet ds = new DataSet();
sda.Fill(ds);
int rec_cnt = ds.Tables[0].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
string businessId = row["businessId"].ToString();
string id = row["id"].ToString();
string roleId = row["roleId"].ToString();
bool rApp = Convert.ToBoolean(row["readAppointment"]);
bool wApp = Convert.ToBoolean(row["writeAppointment"]);
bool rCC = Convert.ToBoolean(row["readCustomerChat"]);
bool wCC = Convert.ToBoolean(row["writeCustomerChat"]);
bool accepted = Convert.ToBoolean(row["accepted"]);
BusinessEmployeeAccess bea = new BusinessEmployeeAccess(new Business().SelectOne(businessId), id, roleId, rApp, wApp, rCC, wCC, accepted);
employeeBeas.Add(bea);
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error in BusinessEmployeeAccess SelectAcceptedByUserId - " + ex.Message + " " + ex.ToString());
}
return(employeeBeas);
}
public BusinessEmployeeAccess SelectOne(string beaId)
{
BusinessEmployeeAccess bea;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString))
{
using (SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM [dbo].[BusinessEmployeeAccess] WHERE [id] = @BeaId;", con))
{
sda.SelectCommand.Parameters.AddWithValue("@BeaId", beaId);
DataSet ds = new DataSet();
sda.Fill(ds);
int rec_cnt = ds.Tables[0].Rows.Count;
if (rec_cnt == 0)
{
bea = null;
}
else
{
DataRow row = ds.Tables[0].Rows[0];
string id = row["id"].ToString();
string userId = row["userId"].ToString();
string businessId = row["businessId"].ToString();
string roleId = row["roleId"].ToString();
bool readAppointment = Convert.ToBoolean(row["readAppointment"]);
bool writeAppointment = Convert.ToBoolean(row["writeAppointment"]);
bool readCustomerChat = Convert.ToBoolean(row["readCustomerChat"]);
bool writeCustomerChat = Convert.ToBoolean(row["writeCustomerChat"]);
bool accepted = Convert.ToBoolean(row["accepted"]);
bea = new BusinessEmployeeAccess(id, userId, businessId, roleId, readAppointment, writeAppointment, readCustomerChat, writeCustomerChat, accepted);
}
}
}
return(bea);
}