public QCCustomRemarks GetQCCustomRemarks(string Attribute1, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.QCCustomRemarksResources.SP_GetQCCustomRemarks);
db.AddInParameter(dbCommand, Resources.QCCustomRemarksResources.PARAM_ATTRIBUTE1, DbType.String, Attribute1);
QCCustomRemarks item = new QCCustomRemarks();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _rmrktype = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKTYPE);
int _rmrkinitiallabel = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKINITIALLABEL);
int _rmrkidentyfier = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKIDENTYFIER);
int _rmrkpaxidentyfier = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKPAXIDENTYFIER);
int _rmrkvalueidentyfier = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKVALUEIDENTYFIER);
int _rmrkfinallabel = dr.GetOrdinal(Resources.QCCustomRemarksResources.FIELD_RMRKFINALLABEL);
if (dr.Read())
{
item.RmrkType = (dr[_rmrktype] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrktype);
item.RmrkInitialLabel = (dr[_rmrkinitiallabel] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrkinitiallabel);
item.RmrkIdentyfier = (dr[_rmrkidentyfier] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrkidentyfier);
item.RmrkPaxIdentyfier = (dr[_rmrkpaxidentyfier] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrkpaxidentyfier);
item.RmrkValueIdentyfier = (dr[_rmrkvalueidentyfier] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrkvalueidentyfier);
item.RmrkFinalLabel = (dr[_rmrkfinallabel] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rmrkfinallabel);
}
}
return(item);
}
private void SetClientRemarks()
{
dinamicQualityControlsList = QCControlsClientsBL.GetQCControls(Attribute1, Login.Firm, Login.PCC, Login.Agent);
if (dinamicQualityControlsList.Count > 0)
{
if (!string.IsNullOrEmpty(dinamicQualityControlsList[28].CtrlDescription) &&
dinamicQualityControlsList[28].CtrlDescription != Login.Mail)
{
dinamicQualityControlsList[28].CtrlDescription = Login.Mail;
}
foreach (QCControlsClients qualityControls in dinamicQualityControlsList)
{
string[] QCValue = qualityControls.ActiveQCClient.Split(new char[] { '|' });
int index = 0;
if (QCValue.Length > 1)
{
index = 1;
}
if (!QCValue[index].Equals(Resources.TicketEmission.Constants.INACTIVE))
{
ListItem item = new ListItem();
item.Value = QCValue[0];
item.Text = qualityControls.CtrlName;
item.Text2 = qualityControls.ReservationCtrlType;
ClientRemarkNumber.Add(item);
}
}
}
customRemark = QCCustomRemarksBL.GetQCustomRemarks(Attribute1);
}
public static QCCustomRemarks GetQCustomRemarks(string Attribute1)
{
QCCustomRemarks CustomRemarks = new QCCustomRemarks();
QCCustomRemarksDAL objQCCustomRemarks = new QCCustomRemarksDAL();
try
{
try
{
CustomRemarks = objQCCustomRemarks.GetQCCustomRemarks(Attribute1, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
CustomRemarks = objQCCustomRemarks.GetQCCustomRemarks(Attribute1, CommonENT.MYCTSDBBACKUP_CONNECTION);
}
}
catch
{ }
return(CustomRemarks);
}
