public static bool ShowHide(People p) { string Sql = "Userid=" + GLOBALVARS.MyUser.ID + " AND ALLOWID=" + p.ID; if (DBFunction.CheckExist(Sql, "LimitedAllow")) { return(true); } return(false); }
private void Add() { int level = 0; if (DBFunction.CheckExist(txtusername.Text, "USERS", "username")) { MessageBox.Show("המשתמש קיים כבר במערכת", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (GLOBALVARS.MyUser.Control == User.TypeControl.Admin) { level = txttype.SelectedIndex; } string sector = SetSector(); SqlParameter[] prms = new SqlParameter[10]; string pass = User.SetPassword(txtpassword.Text); string sql = "insert into users(username,password,control,email,dateadded,name,tel,TempPersonal,TempGeneral,Sector) values(" + BuildSql.InsertSql(out prms[0], txtusername.Text) + BuildSql.InsertSql(out prms[1], pass) + BuildSql.InsertSql(out prms[2], level) + BuildSql.InsertSql(out prms[3], txtmail.Text) + BuildSql.InsertSql(out prms[4], DateTime.Now) + BuildSql.InsertSql(out prms[5], txtname.Text) + BuildSql.InsertSql(out prms[6], txttel.Text) + BuildSql.InsertSql(out prms[7], txtTempPersonal.SelectedIndex) + BuildSql.InsertSql(out prms[8], txtTempGeneral.SelectedIndex) + BuildSql.InsertSql(out prms[9], sector, true) + ");"; if (DBFunction.Execute(sql, prms)) { MessageBox.Show("נוסף בהצלחה", "", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("אירעה שגיאה", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }