public static bool EditPeremission(UserPermession tb) { db = new UcasProEntities(); try { var q = db.UserPermessions.Where(g => g.UserID == tb.UserID).Single(); if (q.ID != 0 && q.UserID != 0) { q.PermessionValue = tb.PermessionValue; db.SaveChanges(); return true; } else { return false; } } catch (Exception) { throw; } }
public static List<UserPermession> GetAllUserPeremissionsByID(int XID) { db = new UcasProEntities(); var LST = (from u in db.UserPermessions where u.UserID == XID select u).ToList(); return LST; }
public static bool AddPeremission(UserPermession tb) { db = new UcasProEntities(); db.UserPermessions.Add(tb); db.SaveChanges(); return true; }
private void Loader() { radWaitingBar1.Invoke((MethodInvoker)delegate { radWaitingBar1.StartWaiting(); }); rpt = new ReportDataSource(); UcasProEntities db = new UcasProEntities(); db.Database.Connection.Open(); db.Database.Connection.Close(); var q = (from i in db.ProjectProfiles select i); var q1 = (from i in db.ProjectActivities select i); var q2 = (from i in db.ProjectSubActivities select i); var q3 = (from i in db.Contracts select i); var q4 = (from i in db.Employees select i); var q5 = (from i in db.TheDonors select i); var q6 = (from i in db.Suppliers select i); var q7 = (from i in db.ProjectSubActivities select i); var q8 = (from i in db.ProjectExpenses select i); var q9 = (from i in db.Monthlysalaries select i); var q10 = (from i in db.TheDonorsProjects select i); var q11= (from i in db.AmountsReceiveds select i); var q12 = (from i in db.UserTbs select i); radWaitingBar1.Invoke((MethodInvoker)delegate { FrmLogin frmx = new FrmLogin(); frmx.Show(); GC.SuppressFinalize(th); GC.Collect(); GC.WaitForFullGCComplete(); GC.WaitForPendingFinalizers(); this.Hide(); }); th.Abort(); }
private void EnterBtn_Click(object sender, EventArgs e) { #region " CheckFillTextBox " if (UserNameTextBox.Text == "") { UserNameTextBox.TextBoxElement.Fill.BackColor = Color.OrangeRed; errorProvider1.SetError(this.UserNameTextBox, "من فضلك ادخل كلمة المرور"); UserNameTextBox.Focus(); return; } else { UserNameTextBox.TextBoxElement.Fill.BackColor = Color.White; errorProvider1.Clear(); } if (PasswordTextBox.Text == "") { PasswordTextBox.TextBoxElement.Fill.BackColor = Color.OrangeRed; errorProvider1.SetError(this.PasswordTextBox, "من فضلك ادخل كلمة المرور"); PasswordTextBox.Focus(); return; } else { PasswordTextBox.TextBoxElement.Fill.BackColor = Color.White; errorProvider1.Clear(); } #endregion Operation.BeginOperation(this); var q = UsersCmd.Login(UserNameTextBox.Text.ToString(), PasswordTextBox.Text.ToString()); cmd = new UcasProEntities(); if (q != null) { InformationsClass.xCurrentUserID = q.ID; InformationsClass.xCurrentUserName = q.UserName; InformationsClass.xCurrentUserPass = q.Password; InformationsClass.XUserType = q.TypeUser; //============================================== if (InformationsClass.XUserType == "غير فعال") { RadMessageBox.Show("غير مصرح لك بالدخول"); Operation.EndOperation(this); Application.Exit(); } else { FrmAdmin frm = new FrmAdmin(); frm.Show(); } Operation.EndOperation(this); this.Hide(); FrmLogin_Load(null, null); } else { Operation.EndOperation(this); RadMessageBox.Show("خطأ في اسم المستخدم وكلمة المرور ","",MessageBoxButtons.OK,RadMessageIcon.Error);//Load msg from Opertation Class } }