private void SearchProfileParameters1L()
{
star1Info = ucProfileSearch.star1Info;
ObjStar1Dfup = new Star1Details();
ObjStar1Dfup.Id = null;
foreach (Star1stLevelInfo lines in ucProfileSearch.star1Info)
{
ObjStar1Dfup.ProfileName = lines.Level1;
ObjStar1Dfup.Pcc = lines.Pccid;
try
{
if (lines.Type == "A" && Regex.IsMatch(lines.Text, "^DK[A-Z]{3}[0-9]{3}$", RegexOptions.IgnoreCase))
{
ObjStar1Dfup.CustomerDk = lines.Text.Substring(2);
}
if (lines.Type == "A" && Regex.IsMatch(lines.Text, "^5CONTACTO-", RegexOptions.IgnoreCase))
{
ObjStar1Dfup.ContactCompany = lines.Text.Substring(10);
}
if (lines.Type == "N" && Regex.IsMatch(lines.Text, "^5PASSWORD*", RegexOptions.IgnoreCase))
{
ObjStar1Dfup.Password = lines.Text.Substring(10);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), @"Error");
}
}
}
public void AddStar1Details(Star1Details objS1Details, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbcomand = db.GetStoredProcCommand(Resources.SetStar1Details.SP_SetStar1Details);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_ProfileName, DbType.String, objS1Details.ProfileName);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_CustomerDK, DbType.String, objS1Details.CustomerDk);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_PCC, DbType.String, objS1Details.Pcc);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_CompanyName, DbType.String, objS1Details.CompanyName);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Telephone, DbType.String, objS1Details.Phone);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Ext, DbType.String, objS1Details.Ext);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_TravelPolicies, DbType.String, objS1Details.TravelPolicies);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_SocialReason, DbType.String, objS1Details.SocialReason);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Street, DbType.String, objS1Details.Street);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_OutsideNumber, DbType.String, objS1Details.OutsideNumber);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_InternalNumber, DbType.String, objS1Details.InternalNumber);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Colony, DbType.String, objS1Details.Colony);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Municipality, DbType.String, objS1Details.Municipality);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_PostalCode, DbType.String, objS1Details.PostalCode);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_City, DbType.String, objS1Details.City);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_State, DbType.String, objS1Details.State);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_RFC, DbType.String, objS1Details.Rfc);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_CreditCard, DbType.String, objS1Details.CreditCard);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_ExpiratioDate, DbType.String, objS1Details.ExpirationDate);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_ContactCompany, DbType.String, objS1Details.ContactCompany);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Email, DbType.String, objS1Details.Email);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Comments, DbType.String, objS1Details.Comments);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_CreatedBy, DbType.String, objS1Details.CreatedBy);
db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_Password, DbType.String, objS1Details.Password);
//db.AddInParameter(dbcomand, Resources.SetStar1Details.PARAM_ExtraData, DbType.String, extraData);
db.ExecuteNonQuery(dbcomand);
}
private Star1Details Getprofile1Level(String pcc, string level1)
{
var s1 = new Star1Details();
var fd = new FieldsDynamicsBL();
listFields = fd.GetStar1Details(pcc, level1);
s1.ProfileName = GetDynamicProperties("ProfileName");
s1.Pcc = GetDynamicProperties("PCC");
s1.CustomerDk = GetDynamicProperties("CustomerDK");
s1.CompanyName = GetDynamicProperties("CompanyName");
s1.Phone = GetDynamicProperties("Telephone");
s1.Ext = GetDynamicProperties("Ext");
s1.TravelPolicies = GetDynamicProperties("TravelPolicies");
s1.SocialReason = GetDynamicProperties("SocialReason");
s1.Street = GetDynamicProperties("Street");
s1.OutsideNumber = GetDynamicProperties("OutsideNumber");
s1.InternalNumber = GetDynamicProperties("InternalNumber");
s1.Colony = GetDynamicProperties("Colony");
s1.Municipality = GetDynamicProperties("Municipality");
s1.PostalCode = GetDynamicProperties("PostalCode");
s1.City = GetDynamicProperties("City");
s1.State = GetDynamicProperties("State");
s1.Rfc = GetDynamicProperties("RFC");
s1.CreditCard = GetDynamicProperties("CreditCard");
s1.CVV1 = GetDynamicProperties("CVV1");
s1.ExpirationDate = GetDynamicProperties("ExpirationDate");
s1.ContactCompany = GetDynamicProperties("ContactCompany");
s1.Email = GetDynamicProperties("Email");
s1.Comments = GetDynamicProperties("Comments");
s1.CreatedBy = GetDynamicProperties("CreatedBy");
s1.Password = GetDynamicProperties("Password");
s1.Id = GetDynamicProperties("Id");
s1.Osi = GetDynamicProperties("Osi");
s1.Remarks = GetDynamicProperties("Remarks");
s1.AlternativeEmail = GetDynamicProperties("AlternativeEmail");
s1.SabreFormats = GetDynamicProperties("SabreFormats");
s1.CreditCard2 = GetDynamicProperties("CreditCard2");
s1.CVV2 = GetDynamicProperties("CVV2");
s1.ExpirationDate2 = GetDynamicProperties("ExpirationDate2");
s1.CreditCard3 = GetDynamicProperties("CreditCard3");
s1.CVV3 = GetDynamicProperties("CVV3");
s1.ExpirationDate3 = GetDynamicProperties("ExpirationDate3");
s1.CreditCard4 = GetDynamicProperties("CreditCard4");
s1.ExpirationDate4 = GetDynamicProperties("ExpirationDate4");
s1.CreditCard5 = GetDynamicProperties("CreditCard5");
s1.ExpirationDate5 = GetDynamicProperties("ExpirationDate5");
s1.SyncStatus = GetDynamicProperties("SyncStatus");
return(s1);
}
public static void AddStars1Details(Star1Details s1Details)
{
var objSetStar1DetailsDAL = new SetStar1DetailsDAL();
try
{
try
{
objSetStar1DetailsDAL.AddStar1Details(s1Details, CommonENT.MYCTSDBPROFILES_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
objSetStar1DetailsDAL.AddStar1Details(s1Details, CommonENT.MYCTSDBPROFILESBACKUP_CONNECTION);
}
}
catch { }
}
public static void UpdateStar1Details(Star1Details objStar1Details)
{
var objUpdateStar1Details = new UpdateStar1DetailsDAL();
try
{
try
{
objUpdateStar1Details.UpdateS1Details(objStar1Details, CommonENT.MYCTSDBPROFILES_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
objUpdateStar1Details.UpdateS1Details(objStar1Details, CommonENT.MYCTSDBPROFILESBACKUP_CONNECTION);
}
}
catch
{
}
}
public Star1Details GetStar1Details(string pcc, string profileName)
{
var listStar1Details = new Star1Details();
var objStar1Details = new GetStar1DetailsDAL();
try
{
try
{
listStar1Details = objStar1Details.ObjGetStar1Details(pcc, profileName, CommonENT.MYCTSDBPROFILES_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
listStar1Details = objStar1Details.ObjGetStar1Details(pcc, profileName, CommonENT.MYCTSDBPROFILESBACKUP_CONNECTION);
}
}
catch { }
return(listStar1Details);
}
public Star1Details ObjGetStar1Details(string pcc, string profileName, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.GetStar1DetailsResources.SP_GetStar1Details);
db.AddInParameter(dbCommand, Resources.GetStar1DetailsResources.PARAM_PCC, DbType.String, pcc);
db.AddInParameter(dbCommand, Resources.GetStar1DetailsResources.PARAM_ProfileName, DbType.String, profileName);
var item = new Star1Details();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _id = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Id);
int _city = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_City);
int _colony = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Colony);
int _comments = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Comments);
int _companyName = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_CompanyName);
int _contactCompany = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_ContactCompany);
int _createdBy = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_CreatedBy);
int _creditCard = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_CreditCard);
int _customerDK = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_CustomerDK);
int _email = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Email);
int _expiratioDate = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_ExpiratioDate);
int _ext = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Ext);
//int _extraData = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_ExtraData);
int _internalNumber = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_InternalNumber);
int _municipality = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Municipality);
int _0utsideNumber = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_OutsideNumber);
int _password = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Password);
int _pcc = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_PCC);
int _postalCode = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_PostalCode);
int _profileName = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_ProfileName);
int _rfc = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_RFC);
int _socialReason = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_SocialReason);
int _state = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_State);
int _street = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Street);
int _phone = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_Telephone);
int _travelPolicies = dr.GetOrdinal(Resources.GetStar1DetailsResources.PARAM_TravelPolicies);
while (dr.Read())
{
item.Id = (dr[_id] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_id).ToString();
item.City = (dr[_city] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_city);
item.Colony = (dr[_colony] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_colony);
item.Comments = (dr[_comments] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_comments);
item.CompanyName = (dr[_companyName] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_companyName);
item.ContactCompany = (dr[_contactCompany] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_contactCompany);
item.CreatedBy = (dr[_createdBy] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_createdBy);
item.CreditCard = (dr[_creditCard] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_creditCard);
item.CustomerDk = (dr[_customerDK] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_customerDK);
item.Email = (dr[_email] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_email);
item.ExpirationDate = (dr[_expiratioDate] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_expiratioDate);
item.Ext = (dr[_ext] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_ext);
item.InternalNumber = (dr[_internalNumber] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_internalNumber);
item.Municipality = (dr[_municipality] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_municipality);
item.OutsideNumber = (dr[_0utsideNumber] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_0utsideNumber);
item.Password = (dr[_password] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_password);
item.Pcc = (dr[_pcc] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_pcc);
item.PostalCode = (dr[_postalCode] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_postalCode);
item.ProfileName = (dr[_profileName] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_profileName);
item.Rfc = (dr[_rfc] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_rfc);
item.SocialReason = (dr[_socialReason] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_socialReason);
item.State = (dr[_state] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_state);
item.Street = (dr[_street] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_street);
item.Phone = (dr[_phone] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_phone);
item.TravelPolicies = (dr[_travelPolicies] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_travelPolicies);
}
}
return(item);
}
/// <summary>
/// Carga informacion de perfil elegido por el usuario
/// </summary>
private void SetProfileInfo()
{
int indexProfile = 0;
if (listViewProfiles.SelectedIndices.Count > 0)
{
indexProfile = listViewProfiles.SelectedIndices[0];
}
var objGetStar1DetailsBL = new GetStar1DetailsBL();
// Swhichea entre el obtener el perfil en el esquema anterior y el nuevo
if (StarsList[indexProfile].Level.Equals(Resources.Profiles.Constants.STAR_LEVEL_ONE))
{
if (StarsList[indexProfile].IsNew)
{
_objStar1Details = Getprofile1Level(StarsList[indexProfile].PccId, StarsList[indexProfile].StarName);
star1Info = objProfilesMethods.FormatSabreProfile1L(_objStar1Details);
AccessProfile(star1Info[0].Level1);
}
else
{
star1Info = Star1stLevelInfoBL.GetStar1stLevelInfo(StarsList[indexProfile].PccId, StarsList[indexProfile].StarName);
DialogResult result = MessageBox.Show("Para usar este perfil es necesario actualizarlo al nuevo módulo de perfiles \n¿Desea continuar?",
@"Actualizacion de perfil", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
isMessageUpdateShow = true;
newFormat = true;
if (AccessProfile(star1Info[0].Level1))
{
var uProfiles = new frmUpdateProfiles(this.ParentForm, "First");
uProfiles.ShowDialog();
}
return;
}
}
}
else if (StarsList[indexProfile].Level.Equals(Resources.Profiles.Constants.STAR_LEVEL_TWO))
{
_objStar1Details = Getprofile1Level(StarsList[indexProfile].PccId, StarsList[indexProfile].Star1Ref);
star1Info = objProfilesMethods.FormatSabreProfile1L(_objStar1Details);
if (StarsList[indexProfile].IsNew)
{
_star2D = Getprofile2Level(StarsList[indexProfile].PccId, StarsList[indexProfile].Star1Ref, StarsList[indexProfile].StarName, StarsList[indexProfile].DK);
//_star2D = Getprofile2Level(StarsList[indexProfile].Email, StarsList[indexProfile].DK);
ObjStar2Details = _star2D;
star2Info = objProfilesMethods.FormatSabreProfile2L(_star2D);
AccessProfile(star2Info[0].Level2);
}
else
{
if (!GetStar1stLevelByStar2LevelBL.GetStar1stLevelByStar2Level(StarsList[indexProfile].Star1Ref, StarsList[indexProfile].PccId))
{
MessageBox.Show("No es posible actualizar este perfil ya que el perfil de primer nivel al que pertenece " + StarsList[indexProfile].Star1Ref + " aún no está actualizado", "No es posible Actualizar", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
star2Info = Star2ndLevelInfoBL.GetStar2ndLevelInfo(StarsList[indexProfile].PccId, StarsList[indexProfile].Star1Ref, StarsList[indexProfile].StarName);
DialogResult result = MessageBox.Show("Para usar este perfil es necesario actualizarlo al nuevo módulo de perfiles \n¿Desea continuar?",
@"Actualizacion de perfil", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
newFormat = true;
isMessageUpdateShow = true;
if (AccessProfile(star2Info[0].Level2))
{
var frm = this.ParentForm as frmProfiles;
newFormat = true;
var fe = new frmUpdateProfiles(this.ParentForm, "Second");
fe.ShowDialog();
}
return;
}
}
}
}
}
