public async Task <Boolean> CreateUser(string Nama, string User)
{
Boolean Result = false;
try
{
string Query = "CreateUser";
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[2];
pParam[0] = new SqlParameter("@Nama", SqlDbType.VarChar);
pParam[0].Value = Nama;
pParam[1] = new SqlParameter("@User", SqlDbType.VarChar);
pParam[1].Value = User;
int res = await dbAccess.ExecQueryByCommand(Query, pParam);
if (res == 1)
{
Result = true;
}
else
{
Result = false;
}
}
catch (Exception ex)
{
Result = false;
throw;
}
return(Result);
}
public async Task <Boolean> CreateTypeBPJS(string BPJSId, string Deskripsi, string User)
{
Boolean Result = false;
try
{
string Query = "CreateTypeBPJS";
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[3];
pParam[0] = new SqlParameter("@BPJSId", SqlDbType.VarChar);
pParam[0].Value = BPJSId;
pParam[1] = new SqlParameter("@Deskripsi", SqlDbType.VarChar);
pParam[1].Value = Deskripsi;
pParam[2] = new SqlParameter("@User", SqlDbType.VarChar);
pParam[2].Value = User;
int res = await dbAccess.ExecQueryByCommand(Query, pParam);
if (res == 1)
{
Result = true;
}
else
{
Result = false;
}
}
catch (Exception ex)
{
Result = false;
throw;
}
return(Result);
}
public async Task <Boolean> CreateMasterMenu(string MenuName, string MenuURL, string MenuIcon, string MenuParentId, string User)
{
Boolean Result = false;
if (MenuIcon == null)
{
MenuIcon = "";
}
if (MenuParentId == null)
{
MenuParentId = "";
}
try
{
string Query = "CreateMasterMenu";
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[5];
pParam[0] = new SqlParameter("@MenuName", SqlDbType.VarChar);
pParam[0].Value = MenuName;
pParam[1] = new SqlParameter("@MenuURL", SqlDbType.VarChar);
pParam[1].Value = MenuURL;
pParam[2] = new SqlParameter("@MenuIcon", SqlDbType.VarChar);
pParam[2].Value = MenuIcon;
pParam[3] = new SqlParameter("@MenuParentId", SqlDbType.VarChar);
pParam[3].Value = MenuParentId;
pParam[4] = new SqlParameter("@User", SqlDbType.VarChar);
pParam[4].Value = User;
int res = await dbAccess.ExecQueryByCommand(Query, pParam);
if (res == 1)
{
Result = true;
}
else
{
Result = false;
}
}
catch (Exception ex)
{
Result = false;
throw;
}
return(Result);
}
public async Task <Boolean> CreateSlider(string Photo, string Judul, string DesSingkat, string DesPanjang, string User)
{
Boolean Result = false;
try
{
string Query = "CreateSlider";
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[5];
pParam[0] = new SqlParameter("@Photo", SqlDbType.VarChar);
pParam[0].Value = Photo;
pParam[1] = new SqlParameter("@Judul", SqlDbType.VarChar);
pParam[1].Value = Judul;
pParam[2] = new SqlParameter("@DesSingkat", SqlDbType.VarChar);
pParam[2].Value = DesSingkat;
pParam[3] = new SqlParameter("@DesPanjang", SqlDbType.VarChar);
pParam[3].Value = DesPanjang;
pParam[4] = new SqlParameter("@User", SqlDbType.VarChar);
pParam[4].Value = User;
int res = await dbAccess.ExecQueryByCommand(Query, pParam);
if (res == 1)
{
Result = true;
}
else
{
Result = false;
}
}
catch (Exception ex)
{
Result = false;
throw;
}
return(Result);
}
public async Task <Boolean> Setting(string RoleId, string MenuIds, string Actives, string Creates, string Updates, string Deletes, string User)
{
Boolean Result = false;
var MenuId = "";
var Active = "";
var Create = "";
var Update = "";
var Delete = "";
var Sparator = ";";
try
{
string Query = "DelteRoleMenuMapping";
dbAccess.strConn = conn;
SqlParameter[] pParam = new SqlParameter[1];
pParam[0] = new SqlParameter("@RoleId", SqlDbType.VarChar);
pParam[0].Value = RoleId;
int res = await dbAccess.ExecQueryByCommand(Query, pParam);
if (res != -1)
{
if (MenuIds != "")
{
int Count = MenuIds.Split(new string[] { Sparator }, StringSplitOptions.None).Length;
for (int i = 0; i < Count; i++)
{
MenuId = MenuIds.Split(new string[] { Sparator }, StringSplitOptions.None)[i];
Active = Actives.Split(new string[] { Sparator }, StringSplitOptions.None)[i];
Create = Creates.Split(new string[] { Sparator }, StringSplitOptions.None)[i];
Update = Updates.Split(new string[] { Sparator }, StringSplitOptions.None)[i];
Delete = Deletes.Split(new string[] { Sparator }, StringSplitOptions.None)[i];
string sql = "CreateRoleMenuMepping";
dbAccess.strConn = conn;
SqlParameter[] Param = new SqlParameter[7];
Param[0] = new SqlParameter("@RoleId", SqlDbType.VarChar);
Param[0].Value = RoleId;
Param[1] = new SqlParameter("@MenuId", SqlDbType.VarChar);
Param[1].Value = MenuId;
Param[2] = new SqlParameter("@Active", SqlDbType.VarChar);
Param[2].Value = Active;
Param[3] = new SqlParameter("@Create", SqlDbType.VarChar);
Param[3].Value = Create;
Param[4] = new SqlParameter("@Update", SqlDbType.VarChar);
Param[4].Value = Update;
Param[5] = new SqlParameter("@Delete", SqlDbType.VarChar);
Param[5].Value = Delete;
Param[6] = new SqlParameter("@User", SqlDbType.VarChar);
Param[6].Value = User;
await dbAccess.ExecQueryByCommand(sql, Param);
}
}
Result = true;
}
else
{
Result = false;
}
}
catch (Exception ex)
{
Result = false;
throw;
}
return(Result);
}