public static BitmapImage GetImage(ChemicalType ChemicalType, String ImagePath, String RegNumber, string MolString, bool isLarge = false)
{
try
{
if (ChemicalType == ChemicalType.NUM && !string.IsNullOrEmpty(ImagePath))
{
string path = Path.Combine(C.SHAREDPATH, ImagePath);
if (File.Exists(path))
{
return(BitMapToImage(new Bitmap(path), isLarge));
}
}
else if (ChemicalType == ChemicalType.S8000 && !string.IsNullOrEmpty(MolString))
{
return(MolToBitmapImage(MolString, isLarge));
}
else if (ChemicalType == ChemicalType.S8500 || ChemicalType == ChemicalType.S9000)
{
string path = S.MolImagePath(RegNumber);
if (File.Exists(path))
{
return(BitMapToImage(new Bitmap(path), isLarge));
}
}
return(null);
}
catch (Exception ex)
{
Log.This(ex);
return(null);
}
}
public static iTextSharp.text.Image GetItextImageFromPath(ChemicalType ChemicalType, String ImagePath)
{
iTextSharp.text.Image imgChem = null;
try
{
if (ChemicalType == ChemicalType.NUM && !string.IsNullOrEmpty(ImagePath))
{
string path = Path.Combine(C.SHAREDPATH, ImagePath);
if (File.Exists(path))
{
string TempPath = Path.Combine(Path.GetTempPath(), "tempImage.gif");
if (File.Exists(TempPath))
{
File.Delete(TempPath);
}
File.Copy(path, TempPath);
using (FileStream fstream = File.Open(TempPath, FileMode.Open, FileAccess.Read))
{
BinaryReader br = new BinaryReader(fstream);
byte[] imgData = br.ReadBytes((int)fstream.Length);
using (MemoryStream stream = new MemoryStream(imgData))
{
imgChem = iTextSharp.text.Image.GetInstance(stream);
}
br.Close();
}
if (File.Exists(TempPath))
{
File.Delete(TempPath);
}
}
//Resize image depend upon your need
imgChem.ScaleToFit(280f, 260f);
//Give space before image
imgChem.SpacingBefore = 30f;
//Give some space after the image
imgChem.SpacingAfter = 1f;
imgChem.Alignment = iTextSharp.text.Element.ALIGN_CENTER;
}
}
catch (Exception ex)
{
Log.This(ex);
}
return(imgChem);
}
public static void Initialize(ApplicationDbContext context)
{
//======================================================================
//NOTE: Seeds the database with Categories
//context.Database.EnsureCreated();
if (context.LabThing.Any())
{
return;
}
var categories = new Category[]
{
new Category {
Name = "Equipment"
},
new Category {
Name = "Instruments"
},
new Category {
Name = "Supplies"
},
new Category {
Name = "Other"
}
};
foreach (Category c in categories)
{
context.Categories.Add(c);
}
context.SaveChanges();
//======================================================================
//NOTE: Seeds the database with ChemicalTypes
//context.Database.EnsureCreated();
//if (context.ChemicalTypes.Any())
//{
// return;
//}
var chemicalType = new ChemicalType[]
{
new ChemicalType {
Name = "Reagent"
},
new ChemicalType {
Name = "Standard"
},
new ChemicalType {
Name = "Other"
}
};
foreach (ChemicalType ct in chemicalType)
{
context.ChemicalTypes.Add(ct);
}
context.SaveChanges();
//======================================================================
//NOTE: Seeds the database with Manufacturers
//context.Database.EnsureCreated();
//if (context.Manufacturers.Any())
//{
// return;
//}
var manufacturer = new Manufacturer[]
{
new Manufacturer {
Name = "AccuStandard"
},
new Manufacturer {
Name = "Bio-Rad"
},
new Manufacturer {
Name = "Cerilliant"
},
new Manufacturer {
Name = "Cole Parmer"
},
new Manufacturer {
Name = "Control Company"
},
new Manufacturer {
Name = "Daigger Scientific"
},
new Manufacturer {
Name = "FisherSci"
},
new Manufacturer {
Name = "GFS Chemicals"
},
new Manufacturer {
Name = "Grainger"
},
new Manufacturer {
Name = "High-Purity Standards"
},
new Manufacturer {
Name = "Honeywell"
},
new Manufacturer {
Name = "Labnet International"
},
new Manufacturer {
Name = "Luminex"
},
new Manufacturer {
Name = "McKesson"
},
new Manufacturer {
Name = "Medline"
},
new Manufacturer {
Name = "Midland Scientific"
},
new Manufacturer {
Name = "MilliporeSigma"
},
new Manufacturer {
Name = "Molecular Devices"
},
new Manufacturer {
Name = "Novatech"
},
new Manufacturer {
Name = "Promega"
},
new Manufacturer {
Name = "QIAGEN"
},
new Manufacturer {
Name = "Sciex"
},
new Manufacturer {
Name = "SigmaAldrich"
},
new Manufacturer {
Name = "ThermoFisher"
},
new Manufacturer {
Name = "Witton"
}
};
foreach (Manufacturer m in manufacturer)
{
context.Manufacturers.Add(m);
}
context.SaveChanges();
//======================================================================
//NOTE: Seeds the database with Employees
// Modified employee:
//context.Database.EnsureCreated();
//if (context.Employees.Any())
//{
// return;
//}
var employees = new List <Employee>();
Employee employee = new Employee
{
FirstName = "admin",
LastName = "admin",
//HireDate = DateTime.Parse("2000-01-01"),
UserName = "******",
NormalizedUserName = "******",
Email = "*****@*****.**",
NormalizedEmail = "*****@*****.**",
EmailConfirmed = true,
LockoutEnabled = false,
SecurityStamp = Guid.NewGuid().ToString("D")
};
var passwordHash = new PasswordHasher <Employee>();
employee.PasswordHash = passwordHash.HashPassword(employee, "Admin8*");
employees.Add(employee);
foreach (Employee e in employees)
{
context.Employees.Add(e);
}
context.SaveChanges();
//======================================================================
//NOTE: Seeds the database with LabThings
//context.Database.EnsureCreated();
//if (context.LabThing.Any())
//{
// return;
//}
var labThing = new LabThing[]
{
new LabThing {
Name = "Pipette", SerialNo = "ABC12345NRX", ModelNo = "1980", AcquisitionDate = DateTime.Parse("2001-01-01"), CalibratedOn = DateTime.Parse("2019-02-01"), CalibrationDue = DateTime.Parse("2020-02-01"), MaintenanceOn = DateTime.Parse("2019-02-01"), MaintenanceDue = DateTime.Parse("2020-02-01"), Note = "N/A", CategoryID = 3, ManufacturerID = 7
},
new LabThing {
Name = "Spectrometric Analyzer", SerialNo = "SN48206874", ModelNo = "AB24509", AcquisitionDate = DateTime.Parse("2015-07-09"), CalibratedOn = DateTime.Parse("2019-04-16"), CalibrationDue = DateTime.Parse("2019-05-16"), MaintenanceOn = DateTime.Parse("2019-01-01"), MaintenanceDue = DateTime.Parse("2020-01-01"), Note = "N/A", CategoryID = 1, ManufacturerID = 22
}
};
foreach (LabThing lt in labThing)
{
context.LabThing.Add(lt);
}
context.SaveChanges();
//======================================================================
//NOTE: Seeds the database with Chemicals
//context.Database.EnsureCreated();
//if (context.Chemicals.Any())
//{
// return;
//}
var chemical = new Chemical[]
{
new Chemical {
Name = "Sulfuric Acid, H2SO4", ReceivedDate = DateTime.Parse("2018-01-01"), OpenDate = DateTime.Parse("2019-02-01"), ExpirationDate = DateTime.Parse("2020-02-01"), COA = "<link>", Note = "N/A", ChemicalTypeID = 3, ManufacturerID = 7
},
new Chemical {
Name = "Sodium Hydroxide, NaOH", ReceivedDate = DateTime.Parse("2019-01-01"), OpenDate = DateTime.Parse("2019-01-05"), ExpirationDate = DateTime.Parse("2021-01-01"), COA = "<link>", Note = "N/A", ChemicalTypeID = 1, ManufacturerID = 1
}
};
foreach (Chemical chem in chemical)
{
context.Chemicals.Add(chem);
}
context.SaveChanges();
}
public ChemicalAmount(ChemicalType _type, int _amount)
{
type = _type;
amount = _amount;
}
public static IEnumerable <ReactionParticipantVM> OfChemicalType(this IEnumerable <ReactionParticipantVM> participants, ChemicalType type)
{
if (participants == null)
{
return(null);
}
return(participants.Where(p => p.ChemicalType == type));
}
