public async Task <List <RoleMenuDetail> > GetDetailById(string Id)
{
List <RoleMenuDetail> Result = new List <RoleMenuDetail>();
try
{
string Query = "GetRoleMenuDetail";
DataTable dt = new DataTable();
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[1];
pParam[0] = new SqlParameter("@RoleID", SqlDbType.Int);
pParam[0].Value = Id;
dt = await dbAccess.GetDataTableByCommand_Async(Query, pParam);
foreach (DataRow dr in dt.Rows)
{
Result.Add(
new RoleMenuDetail
{
MenuID = Convert.ToString(dr["MenuID"]),
MenuName = Convert.ToString(dr["MenuName"]),
Active = Convert.ToString(dr["Active"]),
Create = Convert.ToString(dr["Create"]),
Update = Convert.ToString(dr["Update"]),
Delete = Convert.ToString(dr["Delete"]),
});
}
return(Result);
}
catch (Exception e)
{
throw;
}
}
public async Task <List <MasterOperator> > GetOperator(string PulsaID)
{
List <MasterOperator> Result = new List <MasterOperator>();
try
{
string Query = "GetOperator";
DataTable dt = new DataTable();
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[1];
pParam[0] = new SqlParameter("@PulsaID", SqlDbType.VarChar);
pParam[0].Value = PulsaID;
dt = await dbAccess.GetDataTableByCommand_Async(Query, pParam);
foreach (DataRow dr in dt.Rows)
{
Result.Add(
new MasterOperator
{
OperatorId = Convert.ToString(dr["OperatorId"]),
PulsaId = Convert.ToString(dr["PulsaId"]),
NamaOperator = Convert.ToString(dr["Nama"]),
});
}
return(Result);
}
catch (Exception e)
{
throw;
}
}
public async Task <Boolean> GetUserLogin(string Email, string Password)
{
Boolean Res;
string conn = ConfigurationManager.ConnectionStrings["GetConn"].ConnectionString;
string Query = "GetUserLogin";
DataTable dt = new DataTable();
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[2];
pParam[0] = new SqlParameter("@Email", SqlDbType.VarChar);
pParam[0].Value = Email;
pParam[1] = new SqlParameter("@Password", SqlDbType.VarChar);
pParam[1].Value = Password;
dt = await dbAccess.GetDataTableByCommand_Async(Query, pParam);
if (dt.Rows.Count > 0)
{
Res = true;
}
else
{
Res = false;
}
return(Res);
}
