public List <Organization> GetOrganizationFromDb() { SqlConnection conn = DatabaseSql.GetConnection(); SqlCommand cmd = DatabaseSql.GetCommand(); try { conn.Open(); cmd.Connection = conn; cmd.CommandText = "SELECT * FROM bioumum.V_ORGANIZATION_STRUCTURE;"; SqlDataReader reader = DatabaseSql.GetDataReader(cmd); while (reader.Read()) { Organization m = new Organization(); m.Id = Convert.ToInt16(reader["ORGID"]); m.OrganizationName = Convert.ToString(reader["ORGNM"]); //If the Parent ID [PRRID] in database == Null, then it was the first level (root) if (reader["PRTID"] != DBNull.Value) { m.Parent = new Organization(); m.Parent.Id = Convert.ToInt16(reader["PRTID"]); } listOrganization.Add(m); } } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } return(listOrganization); }
public void SetAuditTrailApplicationLogin(string personalNumber, string userName, string loginStatus) { SqlConnection conn = DatabaseSql.GetConnectionMaster(); SqlCommand cmd = DatabaseSql.GetCommand(); try { conn.Open(); cmd.Connection = conn; cmd.CommandText = @"bioumum.usp_Set_AuditTrailApplicationLogin"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pPERNR", SqlDbType.VarChar, 15).Value = personalNumber; cmd.Parameters.Add("@pUSRNM", SqlDbType.VarChar, 30).Value = userName; cmd.Parameters.Add("@pAPPCD", SqlDbType.VarChar, 5).Value = ConfigurationManager.AppSettings["ApplicationCode"]; cmd.Parameters.Add("@pAPPST", SqlDbType.VarChar, 51).Value = loginStatus; cmd.ExecuteNonQuery(); } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public static Boolean SignatureAuthentication(string username, string password) { SqlConnection conn = DatabaseSql.GetConnectionMaster(); SqlCommand cmd = DatabaseSql.GetCommand(); Boolean result = false; try { conn.Open(); cmd.Connection = conn; cmd.CommandText = @"bioumum.sp_AUTHENTICATION_SIGNATURE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pUSRNM", SqlDbType.VarChar, 15).Value = username; cmd.Parameters.Add("@pPASWD", SqlDbType.VarChar, 50).Value = password; cmd.Parameters.Add("@pUSRDT", SqlDbType.VarChar, 50).Value = "K815";//HttpContext.Current.Session["biofarma_userid"]; cmd.Parameters.Add("@pRESULT", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); result = Convert.ToBoolean(cmd.Parameters["@pRESULT"].Value); } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } return(result); }
public User SingleSignOnUserAuthentication(string personalNumber, string hostname, string hostip) { SqlConnection conn = DatabaseSql.GetConnectionMaster(); SqlCommand cmd = DatabaseSql.GetCommand(); try { conn.Open(); cmd.Connection = conn; cmd.CommandText = "EXEC bioumum.sp_AUTHENTICATION_LOGIN_CTI @userNik, @applicationCode;"; cmd.Parameters.Add("@userNik", SqlDbType.NVarChar, 100); cmd.Parameters["@userNik"].Direction = ParameterDirection.Input; cmd.Parameters.Add("@applicationCode", SqlDbType.NVarChar, 100); cmd.Parameters["@applicationCode"].Direction = ParameterDirection.Input; cmd.Parameters["@userNik"].Value = personalNumber; cmd.Parameters["@applicationCode"].Value = ConfigurationManager.AppSettings["ApplicationCode"]; SqlDataReader reader = DatabaseSql.GetDataReader(cmd); { while (reader.Read()) { string nik = Convert.ToString(reader["userid"]); // PERNR string userName = Convert.ToString(reader["username"]); // CNAME string posid = Convert.ToString(reader["posid"]); // POSID string posName = Convert.ToString(reader["posname"]); // PRPOS string unitCode = Convert.ToString(reader["unitCode"]); // COCTR string unitName = Convert.ToString(reader["unitname"]); // PRORG string roleId = Convert.ToString(reader["roleid"]); // ROLID string roleName = Convert.ToString(reader["rolename"]); // ROLNM string grade = Convert.ToString(reader["grade"]); // PSGRP string email = Convert.ToString(reader["usermail"]); string organizationCode = Convert.ToString(reader["organizationcode"]); //ORGCD _user = new User(nik, posid, userName, posName, unitCode, unitName, roleId, roleName, grade, hostname, hostip, email, organizationCode); } } } catch (Exception ex) { IsError = true; ErrorMessage = ex.Message; throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } return(_user); }
public List <Menu> GetMenuFromDb() { string roleId = HttpContext.Current.Session["biofarma_roleid"].ToString(); string applicationCode = ConfigurationManager.AppSettings["ApplicationCode"]; SqlConnection conn = DatabaseSql.GetConnectionMaster(); SqlCommand cmd = DatabaseSql.GetCommand(); try { conn.Open(); cmd.Connection = conn; cmd.CommandText = "EXEC bioumum.sp_ROLE_MODUL_GET @appid, @roleid;"; cmd.Parameters.AddWithValue("@roleid", roleId); cmd.Parameters.AddWithValue("@appid", applicationCode); //cmd.Parameters.Add("@roleid", SqlDbType.NVarChar, 30); //cmd.Parameters["@roleid"].Direction = ParameterDirection.Input; //cmd.Parameters["@roleid"].Value = "00"; SqlDataReader reader = DatabaseSql.GetDataReader(cmd); while (reader.Read()) { Menu m = new Menu(); m.Id = Convert.ToInt16(reader["MODID"]); m.MenuName = Convert.ToString(reader["MODUL"]); //m.NavUrl = HttpContext.Current.Server.MapPath(Convert.ToString(reader["NVURL"])); //Converting server path (~) into computer physical path (H:\) m.NavUrl = VirtualPathUtility.ToAbsolute(Convert.ToString(reader["NVURL"])); //Converting server path (~) into URL path (localhost/Default.aspx) m.IconClass = Convert.ToString(reader["ICONM"]); //If the Parent ID [PARID] in database == Null, then it was first level Menu (root) if (reader["PARID"] != DBNull.Value) { m.Parent = new Menu(); m.Parent.Id = Convert.ToInt16(reader["PARID"]); } listMenu.Add(m); } } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } return(listMenu); }