public String PrintAvailableSeats(String delimeter)
{
if (MaxUsersWithDefaultRole <= 0)
{
return("");
}
else
{
return(EnrolledUsers.ToString() + delimeter + MaxUsersWithDefaultRole.ToString());
}
}
public List <EnrolledUsers> UserList(int EnrollmentID)
{
List <EnrolledUsers> List = new List <EnrolledUsers>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[ReadEnrolledUsers]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter pEnrollmentID = new SqlParameter
{
ParameterName = "@EnrollmentID",
SqlDbType = SqlDbType.Int,
Value = EnrollmentID
};
SqlCmd.Parameters.Add(pEnrollmentID);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new EnrolledUsers
{
RegisterID = Convert.ToInt32(dr["RegisterID"]),
UserID = Convert.ToInt32(dr["UserID"]),
EnrollmentID = EnrollmentID,
FullName = dr["FullName"].ToString(),
PhoneNumber = dr["PhoneNumber"].ToString(),
ApprovalFlag = Convert.ToBoolean(dr["ApprovalFlag"])
};
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
public bool AddUser(EnrolledUsers Detail, string InsertUser)
{
return(EDAL.AddUser(Detail, InsertUser));
}
public bool AddUser(EnrolledUsers Detail, string InsertUser)
{
bool rpta = false;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspAddRegistration]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter pUserID = new SqlParameter
{
ParameterName = "@UserID",
SqlDbType = SqlDbType.Int,
Value = Detail.UserID
};
SqlCmd.Parameters.Add(pUserID);
SqlParameter pEnrollmentID = new SqlParameter
{
ParameterName = "@EnrollmentID",
SqlDbType = SqlDbType.Int,
Value = Detail.EnrollmentID
};
SqlCmd.Parameters.Add(pEnrollmentID);
SqlParameter pFullName = new SqlParameter
{
ParameterName = "@FullName",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = Detail.FullName
};
SqlCmd.Parameters.Add(pFullName);
SqlParameter pPhoneNumber = new SqlParameter
{
ParameterName = "@PhoneNumber",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = Detail.PhoneNumber
};
SqlCmd.Parameters.Add(pPhoneNumber);
SqlParameter ParInsertUser = new SqlParameter
{
ParameterName = "@InsertUser",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = InsertUser
};
SqlCmd.Parameters.Add(ParInsertUser);
//Exec Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
