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; } }