public void Update(Cardholder cardholder)
{
//Cardholder cardholderToUpdate = CardholderTable.Where(c => c.Firstname == cardholder.Firstname).FirstOrDefault();
//cardholderToUpdate = cardholder;
Contract.Requires(cardholder != null);
//Contract.Ensures(CardholderTable.Contains(cardholder));
using (ISession session = sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var cardholderorm = session.Query <CardholderOrm>().Where(a => a.Id == cardholder.Id.Value).FirstOrDefault();
cardholderorm.Firstname = cardholder.Firstname;
cardholderorm.Lastname = cardholder.Lastname;
cardholderorm.Birthday = cardholder.Birthday;
cardholderorm.Company = cardholder.Company;
//var cardholderOrm = new CardholderOrm()
//{
// Firstname = cardholder.Firstname,
// Lastname = cardholder.Lastname,
// Birthday= cardholder.Birthday,
// Company = cardholder.Company
//};
session.SaveOrUpdate(cardholderorm);
transaction.Commit();
//session.Save(cardholderOrm);
//transaction.Commit();
}
}
/// <summary>
/// Uses the cardholderbuilder to create a cardholder, and possibly a new person as well.
/// </summary>
/// <param name="builder"></param>
public void AddCardholderToDatabase(CardholderBuilder builder)
{
using (LibraryDBEntities context = new LibraryDBEntities())
{
//If this is a new person we will need to add them to the People table
if (builder.IsNewPerson)
{
Person p = new Person()
{
FirstName = builder.Cardholder.FirstName,
LastName = builder.Cardholder.LastName
};
context.People.Add(p);
context.SaveChanges();
//To add the cardholder we need the foreign key
Person person = (from x in context.People
where x.FirstName == builder.Cardholder.FirstName && x.LastName == builder.Cardholder.LastName
select x).FirstOrDefault();
builder.SetID(person.PersonID);
}
//Now the cardholder object is created and added to the Cardholders table
Cardholder c = new Cardholder()
{
ID = builder.Cardholder.ID,
Phone = builder.Cardholder.Phone,
LibraryCardID = builder.Cardholder.LibraryCardID
};
context.Cardholders.Add(c);
context.SaveChanges();
}
PopulatePeople();
}
public static Employee GenerateEmployee(Cardholder cardholder)
{
var testUsers = new Faker <Employee>()
.RuleFor(u => u.FirstName, cardholder.FirstName)
.RuleFor(u => u.LastName, cardholder.LastName)
.RuleFor(u => u.Address, cardholder.Address)
.RuleFor(u => u.City, cardholder.City)
.RuleFor(u => u.Country, cardholder.Country)
.RuleFor(u => u.Email, cardholder.Email)
.RuleFor(u => u.Nationality, cardholder.Nationality)
.RuleFor(u => u.DateOfBirth, cardholder.DateOfBirth)
.RuleFor(u => u.Gender, cardholder.Gender)
.RuleFor(u => u.IdentificationType, cardholder.IdentificationType)
.RuleFor(u => u.IdentificationNo, cardholder.IdentificationNo)
.RuleFor(u => u.Phone, cardholder.Phone)
.RuleFor(u => u.SmartCardId, cardholder.SmartCardId)
.RuleFor(u => u.State, cardholder.State)
.RuleFor(u => u.Status, cardholder.Status)
.RuleFor(u => u.UserType, SHCCardType.Employee)
.RuleFor(u => u.ID, cardholder.ID)
.RuleFor(u => u.Cards, cardholder.Cards)
.RuleFor(u => u.EmployeeId, f => f.Random.Uuid().ToString())
.RuleFor(U => U.ContractId, f => f.Random.Replace("#####-???-***"))
.RuleFor(u => u.Designation, f => f.Name.JobTitle())
.RuleFor(u => u.Company, Companies(1).FirstOrDefault())
.RuleFor(u => u.Buildings, cardholder.Buildings)
.RuleFor(u => u.CarParks, cardholder.CarParks)
.RuleFor(u => u.Vehicles, cardholder.Vehicles);
return(testUsers.Generate());
}
public static Tenant GenerateTenant(Cardholder cardholder)
{
var testUsers = new Faker <Tenant>()
.RuleFor(u => u.FirstName, cardholder.FirstName)
.RuleFor(u => u.LastName, cardholder.LastName)
.RuleFor(u => u.Address, cardholder.Address)
.RuleFor(u => u.City, cardholder.City)
.RuleFor(u => u.Country, cardholder.Country)
.RuleFor(u => u.Email, cardholder.Email)
.RuleFor(u => u.Nationality, cardholder.Nationality)
.RuleFor(u => u.DateOfBirth, cardholder.DateOfBirth)
.RuleFor(u => u.Gender, cardholder.Gender)
.RuleFor(u => u.IdentificationType, cardholder.IdentificationType)
.RuleFor(u => u.IdentificationNo, cardholder.IdentificationNo)
.RuleFor(u => u.Phone, cardholder.Phone)
.RuleFor(u => u.SmartCardId, cardholder.SmartCardId)
.RuleFor(u => u.State, cardholder.State)
.RuleFor(u => u.Status, cardholder.Status)
.RuleFor(u => u.UserType, SHCCardType.Tenant)
.RuleFor(u => u.ID, cardholder.ID)
.RuleFor(u => u.Cards, cardholder.Cards)
.RuleFor(u => u.SHCTenant, SHCTenants(1).FirstOrDefault())
.RuleFor(u => u.Buildings, cardholder.Buildings)
.RuleFor(u => u.CarParks, cardholder.CarParks)
.RuleFor(u => u.Vehicles, cardholder.Vehicles);
return(testUsers.Generate());
}
public static void InitializeDatabases(bool isApplicationStarting = true)
{
if (mEFERTDb != null)
{
mEFERTDb.Dispose();
}
mEFERTDb = new EFERTDbContext();
if (isApplicationStarting)
{
try
{
mCCFTCentral = new CCFTCentral();
Cardholder cardHolderByNic = (from pds in mCCFTCentral.PersonalDataStrings
where pds != null && pds.PersonalDataFieldID == 5051 && pds.Value != null && pds.Value == "12345-1234567-1"
select pds.Cardholder).FirstOrDefault();
}
catch (Exception e)
{
}
try
{
mVisitingLocations = (from visitLocation in mEFERTDb.VisitingLocations
where visitLocation != null
select visitLocation).ToList();
}
catch (Exception e)
{
}
}
}
public static bool IsAccountOverdue(Cardholder cardholder)
{
using (var db = new LibraryInfoEntities())
{
var dueDate = DateTime.Now.AddDays(-30);
return(db.CheckOutLogs.Where(c => c.CardholderID == cardholder.ID && c.CheckOutDate <= dueDate)
.Count() > 0);
}
}
public static List <CheckOutLog> GetCheckOutLogByCardholder(Cardholder cardholder)
{
using (var db = new LibraryInfoEntities())
{
return(db.CheckOutLogs.Include("Book")
.Where(c => c.CardholderID == cardholder.ID)
.OrderBy(b => b.Book.Title)
.ToList());
}
}
public static bool ImprimirCredencialVeiculo(ClasseVeiculosCredenciais.VeiculoCredencial veiculoCredencial)
{
try
{
//IEngine _sdk = Main.engine;
Workspace m_workspace = PagePrincipalView.Workspace;
bool _deletaCredencial = false;
Cardholder _cardholder = _sdk.GetEntity((Guid)veiculoCredencial.CardHolderGuid) as Cardholder;
if (_cardholder == null)
{
return(false);
}
Credential _credencial = _sdk.GetEntity((Guid)veiculoCredencial.CredencialGuid) as Credential;
if (_credencial == null)
{
_credencial = CriarCredencialProvisoria(_cardholder, veiculoCredencial.Validade, new Guid(veiculoCredencial.LayoutCrachaGUID));
_deletaCredencial = true;
}
Guid _CrachaGUID = new Guid(veiculoCredencial.LayoutCrachaGUID);
Guid _CHGUID = _credencial.CardholderGuid; // new Guid("227ee2c9-371f-408f-bf91-07cfb7ac8a74");
System.Windows.Application.Current.Dispatcher.Invoke(new Action(() =>
{
PrintQueue printQueue = GetPrintQueue();
if (printQueue != null)
{
IBadgeService badgeService = m_workspace.Services.Get <IBadgeService>();
if (badgeService != null)
{
BadgeInformation info = new BadgeInformation(_CrachaGUID, _credencial.Guid);
badgeService.BeginPrint(info, printQueue, OnBadgePrinted, null);
}
}
}));
if (_deletaCredencial)
{
_sdk.DeleteEntity(_credencial);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public IActionResult PostCardholder([FromBody] Cardholder cardholder)
{
if (cardholder == null)
{
return(BadRequest());
}
_db.CardHolders.Add(cardholder);
_db.SaveChanges();
return(Ok(cardholder));
}
public static void CheckOutBook(Book book, Cardholder cardholder)
{
using (var db = new LibraryInfoEntities())
{
CheckOutLog checkOutLog = new CheckOutLog
{
BookID = book.BookID,
CardholderID = cardholder.ID,
CheckOutDate = DateTime.Now
};
db.CheckOutLogs.Add(checkOutLog);
db.SaveChanges();
MessageBox.Show($"{cardholder.LibraryCardID} has checked out '{book.Title}'");
}
}
public CardholderDto(Cardholder cardholder)
{
if (cardholder == null)
{
return;
}
AccountInfo = new AccountInfoDto(cardholder.AccountInfo);
BillingAddress = new AddressDto(cardholder.BillingAddress);
Email = cardholder.Email.ToString();
FirstName = cardholder.FirstName;
HomePhoneNumber = cardholder.HomePhoneNumber.ToString();
LastName = cardholder.LastName;
Msisdn = cardholder.Msisdn.ToString();
Shippingaddress = new AddressDto(cardholder.Shippingaddress);
WorkPhoneNumber = cardholder.WorkPhoneNumber.ToString();
}
public static void CheckInBook(Book book, Cardholder cardholder)
{
using (var db = new LibraryInfoEntities())
{
CheckOutLog checkOutLog = db.CheckOutLogs.FirstOrDefault(c => c.BookID == book.BookID && c.CardholderID == cardholder.ID);
if (checkOutLog != null)
{
db.CheckOutLogs.Remove(checkOutLog);
db.SaveChanges();
MessageBox.Show($"{cardholder.LibraryCardID} has checked in '{book.Title}'");
}
else
{
MessageBox.Show($"{cardholder.LibraryCardID} and '{book.Title}' do not exist together in the checkout log.");
}
}
}
private static Credential CriarCredencialProvisoria(Cardholder cardholder, DateTime?validade, Guid layoutCracha)
{
try
{
DateTime _DataValidade;
if (validade != null)
{
_DataValidade = (DateTime)validade;
_DataValidade = _DataValidade.AddSeconds(86399);
_DataValidade = _DataValidade <= DateTime.Now ? DateTime.Now.AddSeconds(3) : _DataValidade;
}
else
{
_DataValidade = DateTime.Now.AddSeconds(86399);
}
Credential _credencial;
_sdk.TransactionManager.CreateTransaction();
_credencial = _sdk.CreateEntity("Credencial de " + cardholder.FirstName, EntityType.Credential) as Credential;
_credencial.Name = cardholder.FirstName + " " + cardholder.LastName;
_credencial.ActivationMode = new SpecificActivationPeriod(DateTime.Now, _DataValidade);
BadgeTemplate _BadgeTemplate = _sdk.GetEntity(layoutCracha) as BadgeTemplate;
_credencial.BadgeTemplate = _BadgeTemplate.Guid;
_credencial.InsertIntoPartition(Partition.DefaultPartitionGuid);
cardholder.Credentials.Add(_credencial);
_sdk.TransactionManager.CommitTransaction();
return(_credencial);
}
catch (Exception ex)
{
throw;
}
}
private static Cardholder BuscarCardHolder(string _CPF, string _CNPJ)
{
EntityConfigurationQuery query;
QueryCompletedEventArgs result;
try
{
query = _sdk.ReportManager.CreateReportQuery(ReportType.EntityConfiguration) as EntityConfigurationQuery;
query.EntityTypeFilter.Add(EntityType.Cardholder);
query.NameSearchMode = StringSearchMode.StartsWith;
result = query.Query();
SystemConfiguration systemConfiguration = _sdk.GetEntity(SdkGuids.SystemConfiguration) as SystemConfiguration;
var service = systemConfiguration.CustomFieldService;
if (result.Success)
{
foreach (DataRow dr in result.Data.Rows)
{
Cardholder _cardholder = _sdk.GetEntity((Guid)dr[0]) as Cardholder;
string _CPFteste = service.GetValue <string>("CPF", _cardholder.Guid);
string _CNPJteste = service.GetValue <string>("CNPJ", _cardholder.Guid);
if (_CPFteste == _CPF && _CNPJteste == _CNPJ)
{
return(_cardholder);
}
}
}
return(null);
}
catch (Exception ex)
{
Global.Log("Erro na void BuscarCardHolder ex: " + ex);
return(null);
}
}
public static List <Cardholder> GetCardHoldersFromXmlDox()
{
var cardHolderXML =
(from c in (XDocument.Load(GetFullFileName("Cardholders.xml")).Descendants("Cardholder")) select c)
.ToList();
List <Cardholder> _cardHolders = new List <Cardholder>(cardHolderXML.Count);
Cardholder _cardHolder;
foreach (var c in cardHolderXML)
{
_cardHolder = new Cardholder();
_cardHolder.LibraryCardID = c.Element("LibraryCardID").Value;
_cardHolder.Phone = c.Element("Phone").Value;
_cardHolder.ID = int.Parse(c.Element("ID").Value);
_cardHolders.Add(_cardHolder);
}
return(_cardHolders);
}
public InMemoryDatabase()
{
var config = new Configuration()
.SetProperty(NHibernate.Cfg.Environment.ReleaseConnections, "on_close")
.SetProperty(NHibernate.Cfg.Environment.Dialect, typeof(SQLiteDialect).AssemblyQualifiedName)
.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, typeof(SQLite20Driver).AssemblyQualifiedName)
.SetProperty(NHibernate.Cfg.Environment.ConnectionString, "Data Source =Demo.db3; FailIfMissing = false;PRAGMA synchronous=off;PRAGMA journal_mode = MEMORY;DateTimeKind=Utc")
.SetProperty(NHibernate.Cfg.Environment.ShowSql, "false")
.SetProperty(NHibernate.Cfg.Environment.FormatSql, "true");
config.AddAssembly(typeof(App).Assembly);
SchemaUpdate update = new SchemaUpdate(config);
update.Execute(useStdOut: true, doUpdate: true);
sessionFactory = config.BuildSessionFactory();
Cardholder cardholder1 = new Cardholder {
Birthday = DateTime.Now, Company = "AKKA", Firstname = "Mohamed", Lastname = "Zekhnini"
};
Cardholder cardholder2 = new Cardholder {
Birthday = DateTime.Now, Company = "VINCI", Firstname = "Abdel", Lastname = "Seghrouchni"
};
_cardholderTable = new ObservableCollection <Cardholder>();
using (ISession session = sessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
var cardholders = session.Query <CardholderOrm>().ToArray();
foreach (var cardholder in cardholders)
{
CardholderTable.Add(new Cardholder {
Firstname = cardholder.Firstname, Lastname = cardholder.Lastname, Birthday = cardholder.Birthday, Company = cardholder.Company, Id = cardholder.Id
});
}
}
}
public static void InitializeDatabases()
{
mEFERTDb = new EFERTDbContext();
mCCFTCentral = new CCFTCentral.CCFTCentral();
mCCFTEvent = new CCFTEvent.CCFTEvent();
try
{
Cardholder cardHolderByNic = (from pds in mCCFTCentral.PersonalDataStrings
where pds != null && pds.PersonalDataFieldID == 5051 && pds.Value != null && pds.Value == "12345-1234567-1"
select pds.Cardholder).FirstOrDefault();
}
catch (Exception e)
{
}
try
{
mVisitingLocations = (from visitLocation in mEFERTDb.VisitingLocations
where visitLocation != null
select visitLocation).ToList();
}
catch (Exception e)
{
}
try
{
List <CCFTEvent.Event> lstEvents = (from events in mCCFTEvent.Events
where events != null && events.EventType == 20001
select events).ToList();
}
catch (Exception e)
{
}
}
Card(CardType cardType, Cardholder cardHolder, double initialRate)
{
this.CardType = cardType;
this.Cardholder = cardHolder;
this.InitialRate = initialRate;
}
public BronzeCard(Cardholder cardHolder)
{
super(CardType.BRONZE, cardHolder, 0);
}
public bool TryWithdraw(int value, Cardholder cardholder)
{
int count100 = Count100;
int count200 = Count200;
int count1000 = Count1000;
int count5000 = Count5000;
int cardholderCount100 = cardholder.Count100;
int cardholderCount200 = cardholder.Count200;
int cardholderCount1000 = cardholder.Count1000;
int cardholderCount5000 = cardholder.Count5000;
if (value / 5000 < count5000)
{
count5000 -= value / 5000;
cardholderCount5000 += value / 5000;
value -= 5000 * (value / 5000);
}
else
{
value -= 5000 * count5000;
cardholderCount5000 += Count5000;
count5000 = 0;
}
if (value / 1000 < count1000)
{
count1000 -= value / 1000;
cardholderCount1000 += value / 1000;
value -= 1000 * (value / 1000);
}
else
{
value -= 1000 * count1000;
cardholderCount1000 += count1000;
count1000 = 0;
}
if (value / 200 < count200)
{
count200 -= value / 200;
cardholderCount200 += value / 200;
value -= 200 * (value / 200);
}
else
{
value -= 200 * count200;
cardholderCount200 += count200;
count200 = 0;
}
if (value / 100 < count100)
{
count100 -= value / 100;
cardholderCount100 += value / 100;
value -= 100 * (value / 100);
}
else
{
value -= 100 * count100;
cardholderCount100 += count100;
count100 = 0;
}
if (value != 0)
{
return(false);
}
Count100 = count100;
Count200 = count200;
Count1000 = count1000;
Count5000 = count5000;
cardholder.Count100 = cardholderCount100;
cardholder.Count200 = cardholderCount200;
cardholder.Count1000 = cardholderCount1000;
cardholder.Count5000 = cardholderCount5000;
return(true);
}
public void WriteToFile(Cardholder person, string epc, string reader, ushort ant)
{
// Set File parameters
string csvSeperator = ";";
StringBuilder streamOutput = new StringBuilder();
var antenna = Tuple.Create <string, ushort> (reader, ant);
var strRSSIcurve = person.GetPowerCurve(antenna).GetCurveIndexY(0).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(1).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(2).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(3).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(4).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(5).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(6).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(7).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(8).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(9).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexY(10).ToString() + ";"
;
var strRSSItime = person.GetPowerCurve(antenna).GetCurveIndexX(0).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(1).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(2).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(3).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(4).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(5).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(6).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(7).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(8).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(9).ToString() + ";" +
person.GetPowerCurve(antenna).GetCurveIndexX(10).ToString() + ";"
;
var strDopplercurve = person.GetDopplerEffectCurve(antenna).GetCurveIndexY(0).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(1).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(2).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(3).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(4).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(5).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(6).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(7).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(8).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(9).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexY(10).ToString()
;
var strDopplertime = person.GetDopplerEffectCurve(antenna).GetCurveIndexX(0).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(1).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(2).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(3).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(4).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(5).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(6).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(7).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(8).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(9).ToString() + ";" +
person.GetDopplerEffectCurve(antenna).GetCurveIndexX(10).ToString()
;
string[][] dataOutput = new string[][] {
new string[] { person.GetName(), epc, reader, ant.ToString(), DateTime.Now.ToString("dd/MM/yyyy; HH:mm:ss:ffff"), person.GetCurAmbient().GetName(), ";", strRSSIcurve, strRSSItime, strDopplercurve, ";", strDopplertime, ";", person.GetAmbient(0).GetName(), person.GetAmbient(2).GetName(), person.GetAmbient(3).GetName(), person.GetAmbient(4).GetName(), person.GetAmbient(5).GetName(), person.GetAmbient(6).GetName() }
};
int length = dataOutput.GetLength(0);
for (int i = 0; i < length; i++)
{
streamOutput.AppendLine(string.Join(csvSeperator, dataOutput[i]));
}
// Appends more lines to the csv file
File.AppendAllText(filePath, streamOutput.ToString());
}
public GoldCard(Cardholder cardHolder)
{
super(CardType.GOLD, cardHolder, 2);
}
public void AddCardHolder(Cardholder cardholder)
{
}
public void DeleteCardHolder(Cardholder cardholder)
{
Contract.Requires(CardholderTable.Contains(cardholder));
Contract.Ensures(!CardholderTable.Contains(cardholder));
CardholderTable.Remove(cardholder);
}
public SilverCard(Cardholder cardholder)
{
super(CardType.SILVER, cardholder, 2);
}
public static bool Vincular(ClasseColaboradoresCredenciais.ColaboradorCredencial colaboradorCredencial)
{
try
{
//IEngine _sdk = Main.engine;
Cardholder _cardholder = null;
string _firstname = "";
string _lastname = "";
////// CardHolder
try
{
_cardholder = BuscarCardHolder(colaboradorCredencial.CPF, colaboradorCredencial.CNPJ);
_sdk.TransactionManager.CreateTransaction();
string[] _nomeCompleto = colaboradorCredencial.ColaboradorNome.Split(' ');
int _len = _nomeCompleto.Count();
if (_len > 1)
{
_lastname = _nomeCompleto[_len - 1];
_firstname = _nomeCompleto[0];
}
else
{
_firstname = colaboradorCredencial.ColaboradorNome;
}
CardholderGroup _cardholderGroup = _sdk.GetEntity(EntityType.CardholderGroup, 1) as CardholderGroup;
if (_cardholder == null)
{
_cardholder = _sdk.CreateEntity(colaboradorCredencial.ColaboradorNome, EntityType.Cardholder) as Cardholder;
}
BitmapImage _img1 = Conversores.STRtoIMG(colaboradorCredencial.ColaboradorFoto) as BitmapImage;
BitmapImage _img2 = Conversores.STRtoIMG(colaboradorCredencial.EmpresaLogo) as BitmapImage;
Bitmap _Foto = Conversores.BitmapImageToBitmap(_img1);
if (_Foto != null)
{
_cardholder.Picture = _Foto;
}
////// CUSTOM FIELDS //////
//var _systemConfiguration = _sdk.GetEntity(SdkGuids.SystemConfiguration) as SystemConfiguration;
//var _customFieldService = _systemConfiguration.CustomFieldService;
//Bitmap _Logo = Conversores.BitmapImageToBitmap(_img2);
//System.Drawing.Image _img3 = System.Drawing.Image.FromFile("D:\\Meus Documentos\\Visual Studio 2015\\Projects\\Genetec\\Projeto Credenciamento\\iModSCCredenciamento 1.0.0.3\\iModSCCredenciamento\\Resources\\Contrato.jpg");
//var _customField = _customFieldService.CustomFields.Where(x => x.EntityType == EntityType.Cardholder && x.Name.Equals("Logo")).FirstOrDefault();
//if (_customField != null)
//{
// _customFieldService.SetValue(_customField, _cardholder.Guid, _img3);
//}
Bitmap _Logo = Conversores.BitmapImageToBitmap(_img2);
if (_Logo != null)
{
_cardholder.SetCustomFieldAsync("Logo", _Logo);
}
Bitmap _Motorista = null;
if (colaboradorCredencial.Motorista)
{
_img1 = new BitmapImage(new Uri("pack://application:,,,/iModSCCredenciamento;component/Resources/Veiculo.png", UriKind.Absolute));
_Motorista = Conversores.BitmapImageToBitmap(_img1);
_cardholder.SetCustomFieldAsync("Motorista", _Motorista);
}
_cardholder.SetCustomFieldAsync("Colaborador (ID)", colaboradorCredencial.ColaboradorID);
_cardholder.SetCustomFieldAsync("Apelido", colaboradorCredencial.ColaboradorApelido.Trim());
_cardholder.SetCustomFieldAsync("CPF", colaboradorCredencial.CPF.Trim());
_cardholder.SetCustomFieldAsync("Empresa", colaboradorCredencial.EmpresaNome.Trim());
_cardholder.SetCustomFieldAsync("Nome Fantasia", colaboradorCredencial.EmpresaApelido.Trim());
_cardholder.SetCustomFieldAsync("CNPJ", colaboradorCredencial.CNPJ.Trim());
_cardholder.SetCustomFieldAsync("Cargo", colaboradorCredencial.Cargo.Trim());
_cardholder.InsertIntoPartition(Partition.DefaultPartitionGuid);
if (_cardholder.Groups.Count == 0 && _cardholderGroup != null)
{
_cardholder.Groups.Add(_cardholderGroup.Guid);
}
_cardholder.FirstName = _firstname.Trim();
_cardholder.LastName = _lastname.Trim();
_sdk.TransactionManager.CommitTransaction();
colaboradorCredencial.CardHolderGuid = _cardholder.Guid;
}
catch (Exception ex)
{
if (_sdk.TransactionManager.IsTransactionActive)
{
_sdk.TransactionManager.RollbackTransaction();
}
return(false);
}
//// Credencial
///
if (colaboradorCredencial.FormatIDGUID != "00000000-0000-0000-0000-000000000000" && colaboradorCredencial.NumeroCredencial != "")
{
try
{
DateTime _DataValidade;
if (colaboradorCredencial.Validade != null)
{
_DataValidade = (DateTime)colaboradorCredencial.Validade;
_DataValidade = _DataValidade.AddSeconds(86399);
_DataValidade = _DataValidade <= DateTime.Now ? DateTime.Now.AddSeconds(3) : _DataValidade;
}
else
{
_DataValidade = DateTime.Now.AddSeconds(86399);
}
Credential _credencial; // = _sdk.GetEntity((Guid)colaboradorCredencial.CredencialGuid) as Credential;
_credencial = BuscarCredencial(colaboradorCredencial.NumeroCredencial, colaboradorCredencial.FormatIDGUID, colaboradorCredencial.FC);
if (_credencial != null)
{
if (_credencial.CardholderGuid != _cardholder.Guid)
{
//MessageBox.Show("Esta credencial pertence a outro usuário e não pode ser vinculada!", "Erro ao Vincular", MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
Global.PopupBox("Esta credencial já está associada a um usuário e não pode ser vinculada!", 4);
return(false);
}
else // atualizar credencial
{
if (colaboradorCredencial.LayoutCrachaGUID != "")
{
//BadgeTemplate _BadgeTemplate = _sdk.GetEntity(new Guid(colaboradorCredencial.LayoutCrachaGUID)) as BadgeTemplate;
//_credencial.BadgeTemplate = _BadgeTemplate.Guid;
_credencial.ActivationMode = new SpecificActivationPeriod(DateTime.Now, _DataValidade);
_credencial.SetCustomFieldAsync("Privilégio #1", colaboradorCredencial.PrivilegioDescricao1);
_credencial.SetCustomFieldAsync("Privilégio #2", colaboradorCredencial.PrivilegioDescricao2);
}
}
}
else //criar nova credencial
{
_sdk.TransactionManager.CreateTransaction();
_credencial = _sdk.CreateEntity("Credencial de " + _firstname, EntityType.Credential) as Credential;
_credencial.Name = colaboradorCredencial.NumeroCredencial.Trim() + " - " + _firstname + " " + _lastname;
_credencial.ActivationMode = new SpecificActivationPeriod(DateTime.Now, _DataValidade);
if (!colaboradorCredencial.Ativa)
{
_credencial.State = CredentialState.Inactive;
}
//_credencial.SetCustomFieldAsync("Privilégio", colaboradorCredencial.PrivilegioDescricao1);
if (colaboradorCredencial.LayoutCrachaGUID != "")
{
//BadgeTemplate _BadgeTemplate = _sdk.GetEntity(new Guid(colaboradorCredencial.LayoutCrachaGUID)) as BadgeTemplate;
//_credencial.BadgeTemplate = _BadgeTemplate.Guid;
}
//0 N/D 00000000-0000-0000-0000-000000000000
//1 Standard - 26 bits 00000000-0000-0000-0000-000000000200
//2 H10302 - 37 bits 00000000-0000-0000-0000-000000000400
//3 H10304 - 37 bits 00000000-0000-0000-0000-000000000500
//4 H10306 - 34 bits 00000000-0000-0000-0000-000000000300
//5 HID Corporate 1000 - 35 bits 00000000-0000-0000-0000-000000000600
//6 HID Corporate 1000 - 48 bits 00000000-0000-0000-0000-000000000800
//7 CSN 00000000-0000-0000-0000-000000000700
switch (colaboradorCredencial.FormatIDGUID)
{
case "00000000-0000-0000-0000-000000000200":
_credencial.Format = new WiegandStandardCredentialFormat(Convert.ToInt32(colaboradorCredencial.FC), Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000400":
_credencial.Format = new WiegandH10302CredentialFormat(Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000500":
_credencial.Format = new WiegandH10304CredentialFormat(Convert.ToInt32(colaboradorCredencial.FC), Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000300":
_credencial.Format = new WiegandH10306CredentialFormat(Convert.ToInt32(colaboradorCredencial.FC), Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000600":
_credencial.Format = new WiegandCorporate1000CredentialFormat(Convert.ToInt32(colaboradorCredencial.FC), Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000800":
_credencial.Format = new Wiegand48BitCorporate1000CredentialFormat(Convert.ToInt32(colaboradorCredencial.FC), Convert.ToInt32(colaboradorCredencial.NumeroCredencial.Trim()));
break;
case "00000000-0000-0000-0000-000000000700":
long _cardnumber = long.Parse(colaboradorCredencial.NumeroCredencial.Trim());
_credencial.Format = new WiegandCsn32CredentialFormat(_cardnumber);
break;
}
//if (_credencial.Format != null)
//{
_credencial.InsertIntoPartition(Partition.DefaultPartitionGuid);
_cardholder.Credentials.Add(_credencial);
//}
_sdk.TransactionManager.CommitTransaction();
}
colaboradorCredencial.CredencialGuid = _credencial.Guid;
}
catch (Exception ex)
{
if (_sdk.TransactionManager.IsTransactionActive)
{
_sdk.TransactionManager.RollbackTransaction();
}
return(false);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void SearchCardHolderFromBarcodeReader(string barcodeString)
{
// MessageBox.Show(this, "aarrBarcodelenght before spliting." + barcodeString);
string[] arrBarcode = barcodeString.Split('\r');
if (arrBarcode.Length == 1 || arrBarcode.Length == 2 || arrBarcode.Length == 3)
{
// MessageBox.Show(this, "aarrBarcodelenght after spliting."+ arrBarcode.Length);
// MessageBox.Show(this, "aarrBarcode data." + arrBarcode);
//smart card or Overseas
string barcodeSplit = arrBarcode.Length == 3 ? arrBarcode[1] : arrBarcode[0];
barcodeSplit = barcodeSplit.Replace("\0", string.Empty);
if (barcodeSplit.Length >= 13)
{
if (IsDigitsOnly(barcodeSplit))
{
string nicNumber = arrBarcode.Length == 3 ? barcodeSplit.Substring(0, 13): barcodeSplit.Substring(12);
if (nicNumber.Length > 13)
{
nicNumber = nicNumber.Substring(0, 13);
}
if (nicNumber.Length >= 13)
{
nicNumber = nicNumber.Insert(5, "-");
nicNumber = nicNumber.Insert(13, "-");
// MessageBox.Show(this, " CNIC number."+ nicNumber);
SearchCardHolderCore(nicNumber, true);
}
}
else
{
MessageBox.Show(this, "Barcode is not of valid CNIC number.");
}
}
else
{
Cardholder tempCard = (from ftItem in EFERTDbUtility.mCCFTCentral.FTItems
where ftItem != null && ftItem.Description == barcodeSplit
select ftItem.Cardholder).FirstOrDefault();
if (tempCard == null)
{
SearchCardHolderCore(barcodeSplit, false);
}
else
{
bool isTempCard = tempCard.FirstName.StartsWith("TEMPORARY-") || tempCard.FirstName.StartsWith("T-");
bool isVisitorCard = tempCard.FirstName.StartsWith("VISITOR-") || tempCard.FirstName.StartsWith("V-");
if (!isTempCard && !isVisitorCard)
{
isTempCard = true;
}
SearchCardHolderCore(tempCard.LastName, false, isTempCard, isVisitorCard);
}
}
}
else
{
//Old NIC Card
for (int i = 0; i < arrBarcode.Length; i++)
{
string barcodeSplit = arrBarcode[i];
if (barcodeSplit.Length == 6)
{
string nicNumber = arrBarcode[i - 1];
if (nicNumber.Length > 13)
{
nicNumber = nicNumber.Substring(0, 13);
}
if (nicNumber.Length >= 13)
{
nicNumber = nicNumber.Insert(5, "-");
nicNumber = nicNumber.Insert(13, "-");
//MessageBox.Show(this, "old CNIC number." + nicNumber);
SearchCardHolderCore(nicNumber, true);
break;
}
}
}
}
}
private void SearchCardHolderCore(string searchString, bool isNicNumber, bool isTempCard = false, bool isVisitorCard = false)
{
EFERTDbUtility.InitializeDatabases(false);
CCFTCentral ccftCentral = EFERTDbUtility.mCCFTCentral;
Cardholder cardHolder = null;
CardHolderInfo cardHolderInfo = null;
VisitorCardHolder visitor = null;
DailyCardHolder dailyCardHolder = null;
bool updatedCardExist = true;
if (isNicNumber)
{
Task <Cardholder> cardHolderByNicTask = new Task <Cardholder>(() =>
{
Cardholder cardHolderByNic = (from pds in ccftCentral.PersonalDataStrings
where pds != null && pds.PersonalDataFieldID == 5051 && pds.Value != null && pds.Value == searchString
select pds.Cardholder).FirstOrDefault();
return(cardHolderByNic);
});
cardHolderByNicTask.Start();
cardHolderInfo = (from card in EFERTDbUtility.mEFERTDb.CardHolders
where card != null && card.CNICNumber == searchString
select card).FirstOrDefault();
if (cardHolderInfo == null)
{
cardHolder = cardHolderByNicTask.Result;
if (cardHolder == null)
{
dailyCardHolder = (from daily in EFERTDbUtility.mEFERTDb.DailyCardHolders
where daily != null && daily.CNICNumber == searchString
select daily).FirstOrDefault();
if (dailyCardHolder == null)
{
visitor = (from visit in EFERTDbUtility.mEFERTDb.Visitors
where visit != null && visit.CNICNumber == searchString
select visit).FirstOrDefault();
}
}
}
else
{
if (cardHolderInfo.IsTemp)
{
cardHolder = cardHolderByNicTask.Result;
if (cardHolder == null)
{
updatedCardExist = false;
}
}
}
}
else
{
Task <Cardholder> cardHolderByCardNumberTask = new Task <Cardholder>(() =>
{
Cardholder cardHolderByCardNumber = (from c in ccftCentral.Cardholders
where c != null && c.LastName == searchString
select c).FirstOrDefault();
return(cardHolderByCardNumber);
});
cardHolderByCardNumberTask.Start();
cardHolderInfo = (from card in EFERTDbUtility.mEFERTDb.CardHolders
where card != null && card.CardNumber == searchString
select card).FirstOrDefault();
if (cardHolderInfo == null)
{
CheckInAndOutInfo cardIssued = (from checkIn in EFERTDbUtility.mEFERTDb.CheckedInInfos
where checkIn != null && checkIn.CheckedIn && checkIn.CardNumber == searchString
select checkIn).FirstOrDefault();
if (cardIssued != null)
{
dailyCardHolder = cardIssued.DailyCardHolders;
if (dailyCardHolder == null)
{
visitor = cardIssued.Visitors;
if (visitor == null)
{
cardHolderInfo = cardIssued.CardHolderInfos;
if (cardHolderInfo != null && cardHolderInfo.IsTemp)
{
cardHolder = (from pds in ccftCentral.PersonalDataStrings
where pds != null && pds.PersonalDataFieldID == 5051 && pds.Value != null && pds.Value == cardIssued.CNICNumber
select pds.Cardholder).FirstOrDefault();
if (cardHolder != null)
{
updatedCardExist = true;
}
else
{
updatedCardExist = false;
}
}
}
}
}
if (visitor == null && dailyCardHolder == null && cardHolderInfo == null)
{
if (!isTempCard && !isVisitorCard)
{
cardHolder = cardHolderByCardNumberTask.Result;
}
}
if (visitor == null && dailyCardHolder == null && cardHolder == null && cardHolderInfo == null)
{
if (Form.ActiveForm != null)
{
bool found = false;
if (Form.ActiveForm is VisitorForm)
{
found = true;
(Form.ActiveForm as VisitorForm).SetCardNumber(searchString);
}
else if (Form.ActiveForm is PermanentChForm)
{
found = true;
(Form.ActiveForm as PermanentChForm).SetCardNumber(searchString);
}
else if (Form.ActiveForm is ContractorChForm)
{
found = true;
(Form.ActiveForm as ContractorChForm).SetCardNumber(searchString);
}
if (found)
{
return;
}
}
if (isTempCard)
{
MessageBox.Show(this, "This temporary card is not issued to any person.");
}
else if (isVisitorCard)
{
MessageBox.Show(this, "This visitor card is not issued to any visitor.");
}
else
{
MessageBox.Show(this, "Cardholder with " + searchString + " card number is not found.");
}
return;
}
}
//else
//{
// if (!cardHolderInfo.GallagherCardHolder)
// {
// cardHolder = cardHolderByNicTask.Result;
// if (cardHolder == null)
// {
// updatedCardExist = false;
// }
// }
//}
//bool isDigitOnly = this.IsDigitsOnly(searchString);
//if (isDigitOnly)
//{
//cardHolder = (from c in ccftCentral.Cardholders
// where c != null && c.LastName == searchString
// select c).FirstOrDefault();
//}
//else
//{
// cardHolder = (from c in ccftCentral.Cardholders
// where c != null && c.FirstName == searchString
// select c).FirstOrDefault();
//}
}
if (cardHolder == null && cardHolderInfo == null && visitor == null && dailyCardHolder == null)
{
ContractorChForm npchf = new ContractorChForm(searchString);
npchf.ShowDialog(this);
}
else
{
if (cardHolderInfo != null && !cardHolderInfo.IsTemp)
{
string cadre = cardHolderInfo.Cadre == null ? "" : cardHolderInfo.Cadre.CadreName;
bool isPermanent = cadre.ToLower() == "nmpt" || cadre.ToLower() == "mpt";
if (isPermanent)
{
PermanentChForm permanentForm = new PermanentChForm(cardHolderInfo);
permanentForm.Show();
}
else
{
ContractorChForm contractorForm = new ContractorChForm(cardHolderInfo);
contractorForm.Show();
}
}
else if (cardHolder != null)
{
Dictionary <int, string> chPds = new Dictionary <int, string>();
foreach (PersonalDataString pds in cardHolder.PersonalDataStrings)
{
if (pds != null)
{
chPds.Add(pds.PersonalDataFieldID, pds.Value);
}
}
string cadre = (from c in chPds
where c.Key == 12952 && c.Value != null
select c.Value).FirstOrDefault();
if (string.IsNullOrEmpty(cadre))
{
MessageBox.Show(this, "No Cadre found.");
}
else
{
bool isPermanent = cadre.ToLower() == "nmpt" || cadre.ToLower() == "mpt";
if (isPermanent)
{
int? pNumber = cardHolder.PersonalDataIntegers == null || cardHolder.PersonalDataIntegers.Count == 0 ? null : cardHolder.PersonalDataIntegers.ElementAt(0).Value;
string strPNumber = pNumber == null ? "P-Number not found." : pNumber.ToString();
DateTime?dateOfBirth = cardHolder.PersonalDataDates == null || cardHolder.PersonalDataDates.Count == 0 ? null : cardHolder.PersonalDataDates.ElementAt(0).Value;
string strDOB = dateOfBirth == null ? "Date of birth not found." : dateOfBirth.ToString();
string bloodGroup = chPds.ContainsKey(5047) && chPds[5047] != null ? chPds[5047] : string.Empty;
string CNICNumber = chPds.ContainsKey(5051) && chPds[5051] != null ? chPds[5051] : string.Empty;
string crew = chPds.ContainsKey(12869) && chPds[12869] != null ? chPds[12869] : string.Empty;
string department = chPds.ContainsKey(5043) && chPds[5043] != null ? chPds[5043] : string.Empty;
string designation = chPds.ContainsKey(5042) && chPds[5042] != null ? chPds[5042] : string.Empty;
string contactNumber = chPds.ContainsKey(5053) && chPds[5053] != null ? chPds[5053] : string.Empty;
string section = chPds.ContainsKey(12951) && chPds[12951] != null ? chPds[12951] : string.Empty;
int cardHolderId = cardHolder.FTItemID;
string companyName = chPds.ContainsKey(5059) && chPds[5059] != null ? chPds[5059] : string.Empty;
CadreInfo cadreInfo = (from c in EFERTDbUtility.mEFERTDb.Cadres
where c != null && c.CadreName == cadre
select c).FirstOrDefault() ?? new CadreInfo()
{
CadreName = cadre
};
CrewInfo crewInfo = string.IsNullOrEmpty(crew) ? null :
((from c in EFERTDbUtility.mEFERTDb.Crews
where c != null && c.CrewName == crew
select c).FirstOrDefault() ?? new CrewInfo()
{
CrewName = crew
});
DepartmentInfo departmentInfo = string.IsNullOrEmpty(department) ? null :
((from c in EFERTDbUtility.mEFERTDb.Departments
where c != null && c.DepartmentName == department
select c).FirstOrDefault() ?? new DepartmentInfo()
{
DepartmentName = department
});
DesignationInfo designationInfo = string.IsNullOrEmpty(designation) ? null :
((from c in EFERTDbUtility.mEFERTDb.Designations
where c != null && c.Designation == designation
select c).FirstOrDefault() ?? new DesignationInfo()
{
Designation = designation
});
SectionInfo sectionInfo = string.IsNullOrEmpty(section) ? null :
((from c in EFERTDbUtility.mEFERTDb.Sections
where c != null && c.SectionName == section
select c).FirstOrDefault() ?? new SectionInfo()
{
SectionName = section
});
CompanyInfo companyInfo = string.IsNullOrEmpty(companyName) ? null :
((from c in EFERTDbUtility.mEFERTDb.Companies
where c != null && c.CompanyName == companyName
select c).FirstOrDefault() ?? new CompanyInfo()
{
CompanyName = companyName
});
if (cardHolderInfo != null && cardHolderInfo.IsTemp)
{
cardHolderInfo.FTItemId = cardHolderId;
cardHolderInfo.FirstName = cardHolder.FirstName;
cardHolderInfo.LastName = cardHolder.LastName;
cardHolderInfo.BloodGroup = string.IsNullOrEmpty(bloodGroup) ? null : bloodGroup;
cardHolderInfo.CardNumber = cardHolder.LastName;
cardHolderInfo.CNICNumber = string.IsNullOrEmpty(CNICNumber) ? null : CNICNumber;
cardHolderInfo.EmergancyContactNumber = string.IsNullOrEmpty(contactNumber) ? null : contactNumber;
cardHolderInfo.PNumber = pNumber == null ? null : pNumber.ToString();
cardHolderInfo.DateOfBirth = dateOfBirth == null ? null : dateOfBirth.ToString();
cardHolderInfo.IsTemp = false;
setCarholderInfo(cardHolderInfo, departmentInfo, cadreInfo, crewInfo, designationInfo, sectionInfo, companyInfo);
EFERTDbUtility.mEFERTDb.Entry(cardHolderInfo).State = System.Data.Entity.EntityState.Modified;
}
else
{
cardHolderInfo = new CardHolderInfo()
{
FTItemId = cardHolderId,
FirstName = cardHolder.FirstName,
LastName = cardHolder.LastName,
BloodGroup = string.IsNullOrEmpty(bloodGroup) ? null : bloodGroup,
CardNumber = cardHolder.LastName,
CNICNumber = string.IsNullOrEmpty(CNICNumber) ? null : CNICNumber,
EmergancyContactNumber = string.IsNullOrEmpty(contactNumber) ? null : contactNumber,
PNumber = pNumber == null ? null : pNumber.ToString(),
DateOfBirth = dateOfBirth == null ? null : dateOfBirth.ToString(),
IsTemp = false
};
setCarholderInfo(cardHolderInfo, departmentInfo, cadreInfo, crewInfo, designationInfo, sectionInfo, companyInfo);
EFERTDbUtility.mEFERTDb.CardHolders.Add(cardHolderInfo);
}
EFERTDbUtility.mEFERTDb.SaveChanges();
PermanentChForm permanentForm = new PermanentChForm(cardHolderInfo);
permanentForm.Show();
}
else
{
string companyName = chPds.ContainsKey(5059) && chPds[5059] != null ? chPds[5059] : string.Empty;
string CNICNumber = chPds.ContainsKey(5051) && chPds[5051] != null ? chPds[5051] : string.Empty;
string department = chPds.ContainsKey(5043) && chPds[5043] != null ? chPds[5043] : string.Empty;
string designation = chPds.ContainsKey(5042) && chPds[5042] != null ? chPds[5042] : string.Empty;
string emergancyContactNumber = chPds.ContainsKey(5053) && chPds[5053] != null ? chPds[5053] : string.Empty;
string section = chPds.ContainsKey(12951) && chPds[12951] != null ? chPds[12951] : string.Empty;
string wONumber = chPds.ContainsKey(5344) && chPds[5344] != null ? chPds[5344] : string.Empty;
int cardHolderId = cardHolder.FTItemID;
CadreInfo cadreInfo = (from c in EFERTDbUtility.mEFERTDb.Cadres
where c != null && c.CadreName == cadre
select c).FirstOrDefault() ?? new CadreInfo()
{
CadreName = cadre
};
CrewInfo crewInfo = null;
DepartmentInfo departmentInfo = string.IsNullOrEmpty(department) ? null :
((from c in EFERTDbUtility.mEFERTDb.Departments
where c != null && c.DepartmentName == department
select c).FirstOrDefault() ?? new DepartmentInfo()
{
DepartmentName = department
});
DesignationInfo designationInfo = string.IsNullOrEmpty(designation) ? null :
((from c in EFERTDbUtility.mEFERTDb.Designations
where c != null && c.Designation == designation
select c).FirstOrDefault() ?? new DesignationInfo()
{
Designation = designation
});
SectionInfo sectionInfo = string.IsNullOrEmpty(section) ? null :
((from c in EFERTDbUtility.mEFERTDb.Sections
where c != null && c.SectionName == section
select c).FirstOrDefault() ?? new SectionInfo()
{
SectionName = section
});
CompanyInfo companyInfo = string.IsNullOrEmpty(companyName) ? null :
((from c in EFERTDbUtility.mEFERTDb.Companies
where c != null && c.CompanyName == companyName
select c).FirstOrDefault() ?? new CompanyInfo()
{
CompanyName = companyName
});
if (cardHolderInfo != null && cardHolderInfo.IsTemp)
{
cardHolderInfo.FTItemId = cardHolderId;
cardHolderInfo.FirstName = cardHolder.FirstName;
cardHolderInfo.LastName = cardHolder.LastName;
cardHolderInfo.CardNumber = cardHolder.LastName;
cardHolderInfo.CNICNumber = string.IsNullOrEmpty(CNICNumber) ? null : CNICNumber;
cardHolderInfo.EmergancyContactNumber = string.IsNullOrEmpty(emergancyContactNumber) ? null : emergancyContactNumber;
cardHolderInfo.WONumber = string.IsNullOrEmpty(wONumber) ? null : wONumber;
cardHolderInfo.IsTemp = false;
setCarholderInfo(cardHolderInfo, departmentInfo, cadreInfo, crewInfo, designationInfo, sectionInfo, companyInfo);
EFERTDbUtility.mEFERTDb.Entry(cardHolderInfo).State = System.Data.Entity.EntityState.Modified;
}
else
{
cardHolderInfo = new CardHolderInfo()
{
FTItemId = cardHolderId,
FirstName = cardHolder.FirstName,
LastName = cardHolder.LastName,
CardNumber = cardHolder.LastName,
CNICNumber = string.IsNullOrEmpty(CNICNumber) ? null : CNICNumber,
EmergancyContactNumber = string.IsNullOrEmpty(emergancyContactNumber) ? null : emergancyContactNumber,
WONumber = string.IsNullOrEmpty(wONumber) ? null : wONumber,
IsTemp = false
};
setCarholderInfo(cardHolderInfo, departmentInfo, cadreInfo, crewInfo, designationInfo, sectionInfo, companyInfo);
EFERTDbUtility.mEFERTDb.CardHolders.Add(cardHolderInfo);
}
EFERTDbUtility.mEFERTDb.SaveChanges();
ContractorChForm contractorForm = new ContractorChForm(cardHolderInfo);
contractorForm.Show();
}
}
}
else if (!updatedCardExist)
{
ContractorChForm contractorForm = new ContractorChForm(cardHolderInfo, true);
contractorForm.Show();
}
else if (visitor != null)
{
VisitorForm vistorForm = new VisitorForm(visitor);
vistorForm.Show();
}
else if (dailyCardHolder != null)
{
ContractorChForm contractorForm = new ContractorChForm(dailyCardHolder);
contractorForm.Show();
}
}
}
private void super(CardType Bronze, Cardholder cardHolder, int v)
{
throw new NotImplementedException();
}
public RequestedMobileCredentialViewModel(Student student, Cardholder.Card mobileCredential, Cardholder cardholder, string?error = null, string?message = null) : base(error, message)
{
Student = student;
Credential = mobileCredential;
Cardholder = cardholder;
}
