public void Delete(bll_CreateUser bllCreateUser)
{
try
{
cmd = "EXEC Delete_userList '" + bllCreateUser.USERID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
//Use label to print an error >> lbl.text = e.Message;
}
}
public void Insert(bll_CreateUser bllCreateUser)
{
try
{
cmd = "EXEC Insert_userList '"
+ bllCreateUser.FULLNAME + "','"
+ bllCreateUser.USERDESIGNATION + "','"
+ bllCreateUser.GROUPID + "','"
+ bllCreateUser.USERMOBILE + "','"
+ bllCreateUser.USEREMAIL + "','"
+ bllCreateUser.USERNAME + "','"
+ bllCreateUser.USERPASSWORD + "','"
+ bllCreateUser.CREATEDATE + "','"
+ bllCreateUser.AUDUSER + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void Update(bll_CreateUser bllCreateUser)
{
try
{
cmd = "EXEC Update_userList '"
+ bllCreateUser.USERID + "','"
+ bllCreateUser.FULLNAME + "','"
+ bllCreateUser.USERDESIGNATION + "','"
+ bllCreateUser.GROUPID + "','"
+ bllCreateUser.USERMOBILE + "','"
+ bllCreateUser.USEREMAIL + "','"
+ bllCreateUser.USERNAME + "','"
+ bllCreateUser.USERPASSWORD + "','"
+ bllCreateUser.CREATEDATE + "','"
+ bllCreateUser.AUDUSER + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
//Use label to print an error >> lbl.text = e.Message;
}
}
