public System.Data.DataTable selectAll(OBALog.Model.ML_User user) { var para = new MySqlParameter[1]; para[0] = new MySqlParameter("@Key", user.Key); return(MySQLHelper.ExecuteDataTable(DBConnection.connectionString, System.Data.CommandType.Text, "SELECT `Key`, LoginId, Name, NIC, UserAccessTypeKey, UserKey, UpdatedDate FROM stc_oba.user WHERE `Key` = COALESCE(@Key,`Key`) AND Deleted = 0", para)); }
public System.Data.DataSet checkLogin(OBALog.Model.ML_User user) { var para = new MySqlParameter[2]; para[0] = new MySqlParameter("@LoginId", user.LoginId); para[1] = new MySqlParameter("@Password", DataHelper.CreateSHA1(user.Password)); return(MySQLHelper.ExecuteDataSet(DBConnection.connectionString, System.Data.CommandType.Text, "SELECT usr.`Key`, usr.`LoginId`, usr.`Name`, usr.`NIC`, usr.`UserAccessTypeKey`, u.AccessTypeName FROM `user` usr JOIN useraccesstype u ON usr.UserAccessTypeKey = u.`Key` AND usr.Deleted = FALSE WHERE usr.`LoginId` = @LoginId AND usr.`Password` = @Password AND usr.`Deleted` = FALSE; SELECT p.`Key`, REPLACE(p.Privilege,'.','_') AS Privilege, up.Allowed FROM stc_oba.useraccessprivilege up JOIN `user` u ON up.`UserAccessTypeKey` = u.`UserAccessTypeKey` AND u.LoginId = @LoginId AND u.`LoginId` = LoginId AND u.`Deleted` = FALSE JOIN privilege p ON p.`Key` = up.`PrivilegeKey`; SELECT ConfigurationName, ConfigurationValue FROM configurations;", para)); }
public System.Data.DataTable selectUsage(OBALog.Model.ML_User user) { var para = new MySqlParameter[2]; para[0] = new MySqlParameter("@Key", user.Key); para[1] = new MySqlParameter("@LoginId", user.LoginId); return(MySQLHelper.ExecuteDataTable(DBConnection.connectionString, System.Data.CommandType.Text, "SELECT `Key`, LoginId, Name, NIC, UserAccessTypeKey, UserKey, UpdatedDate FROM stc_oba.user WHERE `Key` = @Key OR `LoginId` = @LoginId", para)); }
public bool delete(OBALog.Model.ML_User user) { var para = new MySqlParameter[1]; para[0] = new MySqlParameter("@Key", user.Key); MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, System.Data.CommandType.Text, "UPDATE stc_oba.user SET `Deleted` = True WHERE `Key` = @Key", para); return(true); }
public bool resetPassword(OBALog.Model.ML_User user) { var para = new MySqlParameter[4]; para[0] = new MySqlParameter("@LoginId", user.LoginId); para[1] = new MySqlParameter("@Password", DataHelper.CreateSHA1(user.Password)); para[2] = new MySqlParameter("@UpdatedDate", user.UpdatedDate); para[3] = new MySqlParameter("@Key", user.Key); MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, System.Data.CommandType.Text, "UPDATE stc_oba.user SET Password = COALESCE(@Password, Password), UpdatedDate = @UpdatedDate WHERE `Key` = @Key AND `LoginId`= COALESCE(@LoginId, LoginId)", para); return(true); }
public int insert(OBALog.Model.ML_User user) { var para = new MySqlParameter[7]; para[0] = new MySqlParameter("@LoginId", user.LoginId); para[1] = new MySqlParameter("@Name", user.Name); para[2] = new MySqlParameter("@NIC", user.NIC); para[3] = new MySqlParameter("@Password", DataHelper.CreateSHA1(user.Password)); para[4] = new MySqlParameter("@UpdatedDate", user.UpdatedDate); para[5] = new MySqlParameter("@UserAccessTypeKey", user.UserAccessTypeKey); para[6] = new MySqlParameter("@UserKey", user.UserKey); return(Convert.ToInt32(MySQLHelper.ExecuteScalar(DBConnection.connectionString, System.Data.CommandType.Text, "INSERT INTO stc_oba.user ( LoginId ,Password ,Name ,NIC ,UserAccessTypeKey ,UserKey, UpdatedDate) VALUES ( @LoginId ,@Password ,@Name ,@NIC ,@UserAccessTypeKey ,@UserKey, @UpdatedDate); SELECT @@identity", para))); }
public bool update(OBALog.Model.ML_User user) { var para = new MySqlParameter[8]; para[0] = new MySqlParameter("@LoginId", user.LoginId); para[1] = new MySqlParameter("@Name", user.Name); para[2] = new MySqlParameter("@NIC", user.NIC); para[3] = new MySqlParameter("@Password", DataHelper.CreateSHA1(user.Password)); para[4] = new MySqlParameter("@UpdatedDate", user.UpdatedDate); para[5] = new MySqlParameter("@UserAccessTypeKey", user.UserAccessTypeKey); para[6] = new MySqlParameter("@UserKey", user.UserKey); para[7] = new MySqlParameter("@Key", user.Key); MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, System.Data.CommandType.Text, "UPDATE stc_oba.user SET LoginId = @LoginId ,Password = COALESCE(@Password, Password) ,Name = @Name ,NIC = @NIC ,UserAccessTypeKey = @UserAccessTypeKey ,UserKey = @UserKey ,UpdatedDate = @UpdatedDate WHERE `Key` = @Key", para); return(true); }
public bool update(OBALog.Model.ML_User user) { return(new OBALog.Data.DL_User().update(user)); }
public int insert(OBALog.Model.ML_User user) { return(new OBALog.Data.DL_User().insert(user)); }
public System.Data.DataSet checkLogin(OBALog.Model.ML_User user) { return(new OBALog.Data.DL_User().checkLogin(user)); }
public System.Data.DataTable selectUsage(OBALog.Model.ML_User user) { return(new OBALog.Data.DL_User().selectUsage(user)); }
public bool resetPassword(OBALog.Model.ML_User user) { return(new OBALog.Data.DL_User().resetPassword(user)); }