// ----------------------------------------------------- // List clients // ----------------------------------------------------- public static List <Client> List(HeaderInfo _headerInfo) { var clientList = new List <Client>(); using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + ClientFieldString() + " FROM Client " + " WHERE IsVoid = 'N' " + " ORDER BY UID ASC " ); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); try { using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { var client = new Client(_headerInfo); RepClient.LoadClientObject(reader, client); // Retrieve status of the logo. Enabled or disabled // // 26.01.2013 // The attribute is now stored on the Client Table // //var rmd = new ReportMetadata(); //rmd.Read(client.UID, ReportMetadata.MetadataFieldCode.COMPANYLOGO); //client.DisplayLogo = rmd.Enabled; clientList.Add(client); } } } catch (Exception ex) { string error = ex.ToString(); LogFile.WriteToTodaysLogFile(ex.ToString(), _headerInfo.UserID, "", "Client.cs"); } } } return(clientList); }
/// <summary> /// Get Logo location for a client. /// </summary> /// <param name="clientUID"></param> /// <param name="curEnvironment"> </param> /// <returns></returns> public static string GetClientLogoLocation(int clientUID, HeaderInfo headerInfo, string curEnvironment = MackkadoITFramework.Helper.Utils.EnvironmentList.LOCAL) { string logoPath = ""; string logoName = ""; string logoPathName = ""; Utils.FCMenvironment = curEnvironment; // Get Company Logo // //ReportMetadata rmd = new ReportMetadata(); //rmd.ClientUID = clientUID; //rmd.RecordType = Utils.MetadataRecordType.CLIENT; //rmd.FieldCode = "COMPANYLOGO"; //rmd.Read(clientUID: clientUID, fieldCode: "COMPANYLOGO"); //Client client = new Client(headerInfo); //client.UID = clientUID; //client.Read(); var resp = RepClient.Read(clientUID); Client client = new Client(); client = resp.client; // Set no icon image if necessary // logoPath = FCMConstant.SYSFOLDER.LOGOFOLDER; logoName = "imgNoImage.jpg"; if (client.Logo1Location != null) { logoName = client.Logo1Location.Replace(FCMConstant.SYSFOLDER.LOGOFOLDER, string.Empty); } logoPathName = Utils.getFilePathName(logoPath, logoName); return(logoPathName); }