public static GetAttribute1 GetAttribute(string Location, int orgId) { GetAttribute1 listAttribute = new GetAttribute1(); GetAttribute1DAL objAttribute = new GetAttribute1DAL(); try { try { listAttribute = objAttribute.GetAttribute(Location, orgId, CommonENT.MYCTSDB_CONNECTION); } catch (Exception ex) { new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos); listAttribute = objAttribute.GetAttribute(Location, orgId, CommonENT.MYCTSDBBACKUP_CONNECTION); } } catch { } return(listAttribute); }
public GetAttribute1 GetAttribute(string Location, int orgId, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbCommand = db.GetStoredProcCommand(Resources.GetAttribute1Resources.SP_GetAttribute1); db.AddInParameter(dbCommand, Resources.GetAttribute1Resources.PARAM_QUERY, DbType.String, Location); db.AddInParameter(dbCommand, Resources.GetAttribute1Resources.PARAM_ORG_ID, DbType.Int32, orgId); GetAttribute1 AttributeList = new GetAttribute1(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { int _attribute = dr.GetOrdinal(Resources.GetAttribute1Resources.ATTRIBUTE1); while (dr.Read()) { GetAttribute1 item = new GetAttribute1(); item.Attribute1 = dr.GetString(_attribute); AttributeList = item; } } return(AttributeList); }
public static void CreateFilesPDF(List <string> tickets) { Parameter mailToSend = ParameterBL.GetParameterValue("MailThatSendFeeRule"); Parameter mailPassword = ParameterBL.GetParameterValue("PasswordThatMailToSend"); Parameter displyName = ParameterBL.GetParameterValue("NameSendEmail"); string[] tiketsArray = new string[tickets.Count]; string[] virtuallyThere = new string[tickets.Count]; List <GetLinkByTkt> indexList = null; for (int j = 0; j < tickets.Count; j++) { tiketsArray[j] = tickets[j]; indexList = new List <GetLinkByTkt>(); indexList = GetLinkByTktBL.GetLinkByTkt(tickets[j].Substring(3, 10), Login.OrgId); if (indexList.Count > 0) { virtuallyThere[j] = indexList[0].LinkVirtuallyThere; } else { virtuallyThere[j] = "http://www.google.com.mx"; } } if (tickets.Count > 0) { try { string mail = Login.Mail; if (!string.IsNullOrEmpty(ucSendTicketPrinter.TempCCMail)) { mail = string.Concat(mail, ";", ucSendTicketPrinter.TempCCMail); ucSendTicketPrinter.TempCCMail = string.Empty; } if (ucFirstValidations.Attribute1 != null) { if (ucFirstValidations.Attribute1.Equals(Resources.TicketEmission.Constants.ATTRIBUTE1_CFE100)) { BuildElectronicTicketCFEContract ws = new BuildElectronicTicketCFEContract(); ws.SendInfoToBuilPDF(tiketsArray, virtuallyThere, ucTicketsEmissionInstructions.Airline, mailToSend.Values, mailPassword.Values, mail, displyName.Values); } else { BuildElectronicTicketContract ws = new BuildElectronicTicketContract(); ws.SendInfoToBuilPDF(tiketsArray, virtuallyThere, ucTicketsEmissionInstructions.Airline, mailToSend.Values, mailPassword.Values, mail, displyName.Values); } } else { if (!string.IsNullOrEmpty(ucSendTicketPrinter.DK)) { GetAttribute1 attribute1 = GetAttribute1BL.GetAttribute(ucSendTicketPrinter.DK, Login.OrgId); if (attribute1.Attribute1.Equals(Resources.TicketEmission.Constants.ATTRIBUTE1_CFE100)) { BuildElectronicTicketCFEContract ws = new BuildElectronicTicketCFEContract(); ws.SendInfoToBuilPDF(tiketsArray, virtuallyThere, ucTicketsEmissionInstructions.Airline, mailToSend.Values, mailPassword.Values, mail, displyName.Values); } else { BuildElectronicTicketContract ws = new BuildElectronicTicketContract(); ws.SendInfoToBuilPDF(tiketsArray, virtuallyThere, ucTicketsEmissionInstructions.Airline, mailToSend.Values, mailPassword.Values, mail, displyName.Values); } ucSendTicketPrinter.DK = string.Empty; } else { BuildElectronicTicketContract ws = new BuildElectronicTicketContract(); ws.SendInfoToBuilPDF(tiketsArray, virtuallyThere, ucTicketsEmissionInstructions.Airline, mailToSend.Values, mailPassword.Values, mail, displyName.Values); } } } catch { } } }