public static User LoginKontrol(int tip, string sirketKod, string userName, string password) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.DeferredLoadingEnabled = false; if (Context.Users.Any(x => x.Kod == userName)) { User user = Context.Users.Where(x => x.Kod == userName && x.Tip == tip && x.Sirket == sirketKod).FirstOrDefault(); if (user.IsNotNull()) { if (Sifreleme.Cozumle(user.Sifre) == password) { return(user); } else { return(null); } } else { return(null); } } else { return(null); } } }
public static bool InsertUpdateUserPerm(string rolName, string userName, List <PermEx> rolePermList, string userID = "") { using (TransactionScope Scope = new TransactionScope()) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { if (rolName.IsNullEmpty()) { Context.ExecuteCommand("UPDATE usr.Users SET RoleName=null WHERE Kod={0}", userName); } else { Context.ExecuteCommand("UPDATE usr.Users SET RoleName={0} WHERE Kod={1}", rolName, userName); } foreach (PermEx rPerm in rolePermList) { Context.ExecuteCommand(@" IF (SELECT COUNT(UserName) FROM usr.UserPerm(Nolock) WHERE UserName={0} AND PermName={1})=0 INSERT INTO usr.UserPerm (UserName, PermName, Reading, Writing, Updating, Deleting, RecordUser, ModifiedUser) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {6}) ELSE UPDATE usr.UserPerm SET Reading={2}, Writing={3}, Updating={4}, Deleting={5}, ModifiedDate=GETDATE(), ModifiedUser={6} WHERE UserName={0} AND PermName={1}", userName, rPerm.PermName, rPerm.Reading, rPerm.Writing, rPerm.Updating, rPerm.Deleting, userID); } } Scope.Complete(); } return(true); }
public static List <Role> GetRoles() { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.DeferredLoadingEnabled = false; return(Context.Roles.ToList()); } }
public static bool UpdateRoles(string eskiRolAdi, string yeniRolAdi) { if (eskiRolAdi.IsNullEmpty() || yeniRolAdi.IsNullEmpty()) { Mesaj.Uyari("Rol adı boş yada geçersiz olamaz !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand("UPDATE usr.Roles SET RoleName={0} WHERE RoleName={1}", yeniRolAdi, eskiRolAdi); } return(true); }
public static List <PermEx> GetRolePerms(string RoleName) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.DeferredLoadingEnabled = false; return(Context.ExecuteQuery <PermEx>(@"SELECT P.PermName, ISNULL(RP.Reading,0) Reading, ISNULL(RP.Writing,0) as Writing, ISNULL(RP.Updating,0) as Updating, ISNULL(RP.Deleting,0) as Deleting, P.[Group], CASE P.[Type] WHEN 0 THEN 'Form' WHEN 1 THEN 'Kontrol' ELSE 'None' END as Tip FROM usr.Perm(nolock) P LEFT JOIN usr.RolePerm(nolock) RP ON P.PermName=RP.PermName AND RP.RoleName={0} WHERE P.Active=1", RoleName).ToList()); } }
public static bool AddRoles(Role role) { if (role.RoleName.IsNullEmpty()) { Mesaj.Uyari("Rol adı boş geçilemez !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.Roles.InsertOnSubmit(role); Context.SubmitChanges(); } return(true); }
public static bool AddUser(List <User> kullanicilar) { if (kullanicilar[0].Kod.IsNullEmpty()) { Mesaj.Uyari("Kullanıcı adı boş geçilemez !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.Users.InsertAllOnSubmit(kullanicilar); Context.SubmitChanges(); } return(true); }
public static bool UpdatePerm(string permNameKey, Perm mIzin) { if (permNameKey.IsNullEmpty() || mIzin.PermName.IsNullEmpty()) { Mesaj.Uyari("İzin form adı boş yada geçersiz olamaz !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand("UPDATE usr.Perm SET PermName={0}, Active={1}, Type={2}, [Group]={3} WHERE PermName={4}", mIzin.PermName, mIzin.Active, mIzin.Type, mIzin.Group, permNameKey); } return(true); }
public static bool AddPerm(Perm izin) { if (izin.PermName.IsNullEmpty()) { Mesaj.Uyari("İzin form adı boş geçilemez !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.Perms.InsertOnSubmit(izin); Context.SubmitChanges(); } return(true); }
public static bool UpdateUser(User eskiKul, User yeniKul) { if (eskiKul.Kod.IsNullEmpty() || yeniKul.Kod.IsNullEmpty()) { Mesaj.Uyari("Kullanıcı adı boş yada geçersiz olamaz !"); return(false); } using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand(@"UPDATE BIRIKIM.usr.Users SET Kod={0}, Sifre={1}, AdSoyad={2}, EMail={3}, Aktif={4}, Admin={5}, Sirket={6} WHERE Kod={7} AND Tip={8} AND Sirket={9}", yeniKul.Kod, yeniKul.Sifre, yeniKul.AdSoyad, yeniKul.Email, yeniKul.Aktif, yeniKul.Admin, yeniKul.Sirket, eskiKul.Kod, eskiKul.Tip, eskiKul.Sirket); } return(true); }
public static bool DeleteRoles(string rolAdi) { if (rolAdi.IsNullEmpty()) { Mesaj.Uyari("Rol adı boş yada geçersiz olamaz !"); return(false); } if (DialogResult.Yes == Mesaj.Onay(string.Format("[{0}] adlı rolü silmek istediğinize emin misiniz ?", rolAdi))) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand("DELETE usr.Roles WHERE RoleName={0}", rolAdi); } return(true); } else { return(false); } }
public static bool DeleteUser(string userName) { if (userName.IsNullEmpty()) { Mesaj.Uyari("Kullanıcı adı boş yada geçersiz olamaz !"); return(false); } if (DialogResult.Yes == Mesaj.Onay(string.Format("[{0}] adlı kullanıcıyı silmek istediğinize emin misiniz ?", userName))) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand("DELETE BIRIKIM.usr.Users WHERE Kod={0}", userName); } return(true); } else { return(false); } }
public static bool DeletePerm(string permNameKey) { if (permNameKey.IsNullEmpty()) { Mesaj.Uyari("İzin form adı boş olamaz !"); return(false); } if (DialogResult.Yes == Mesaj.Onay(string.Format("[{0}] adlı izin formu silmek istediğinize emin misiniz ?", permNameKey))) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.ExecuteCommand("DELETE usr.Perm WHERE PermName={0}", permNameKey); } return(true); } else { return(false); } }
public static bool InsertUpdateRolePerm(string rolName, List <PermEx> rolePermList, string userID = "") { using (TransactionScope Scope = new TransactionScope()) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { List <MUser> UserList = Context.ExecuteQuery <MUser>("SELECT Kod FROM usr.Users(Nolock) WHERE RoleName={0} AND Admin=0", rolName).ToList(); foreach (PermEx rPerm in rolePermList) { Context.ExecuteCommand(@"IF (SELECT COUNT(ID) FROM usr.RolePerm (Nolock) WHERE RoleName={0} AND PermName={1})=0 INSERT INTO usr.RolePerm (RoleName, PermName, Reading, Writing, Updating, Deleting, RecordUser, ModifiedUser) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {6}) ELSE UPDATE usr.RolePerm SET Reading={2}, Writing={3}, Updating={4}, Deleting={5}, ModifiedDate=Getdate(), ModifiedUser={6} WHERE RoleName={0} AND PermName={1}" , rolName, rPerm.PermName, rPerm.Reading, rPerm.Writing, rPerm.Updating, rPerm.Deleting, userID); foreach (var user in UserList) { Context.ExecuteCommand(@"IF (SELECT COUNT(UserName) FROM usr.UserPerm(Nolock) WHERE UserName={0} AND PermName={1})=0 INSERT INTO usr.UserPerm (UserName, PermName, Reading, Writing, Updating, Deleting, RecordUser, ModifiedUser) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {6}) ELSE UPDATE usr.UserPerm SET Reading={2}, Writing={3}, Updating={4}, Deleting={5}, ModifiedDate=GetDate(), ModifiedUser={6} WHERE UserName={0} AND PermName={1}" , user.Kod, rPerm.PermName, rPerm.Reading, rPerm.Writing, rPerm.Updating, rPerm.Deleting, userID); } } } Scope.Complete(); } return(true); }
public static List <UserPerm> LoginYetkileriniGetir(int tip, string sirketKodu, string userName) { using (UserRoleDBDataContext Context = new UserRoleDBDataContext(ConStr)) { Context.DeferredLoadingEnabled = false; //return Context.UserPerms.Where(x=> x.UserName == userName).ToList(); return(Context.ExecuteQuery <UserPerm>(@" SELECT {0} as UserName, P.PermName, CASE WHEN (Select Admin From usr.Users(Nolock) Where Kod={0} AND Sirket={1} AND Tip={2})=1 THEN Cast(1 as Bit) ELSE ISNULL(UP.Reading,0) END Reading, CASE WHEN (Select Admin From usr.Users(Nolock) Where Kod={0} AND Sirket={1} AND Tip={2})=1 THEN Cast(1 as Bit) ELSE ISNULL(UP.Writing,0) END Writing, CASE WHEN (Select Admin From usr.Users(Nolock) Where Kod={0} AND Sirket={1} AND Tip={2})=1 THEN Cast(1 as Bit) ELSE ISNULL(UP.Updating,0) END Updating, CASE WHEN (Select Admin From usr.Users(Nolock) Where Kod={0} AND Sirket={1} AND Tip={2})=1 THEN Cast(1 as Bit) ELSE ISNULL(UP.Deleting,0) END Deleting FROM usr.Perm (Nolock) P LEFT JOIN usr.UserPerm (Nolock) UP ON P.PermName=UP.PermName AND UP.UserName={0}" , userName, sirketKodu, tip).ToList()); } }