/// <summary>
/// Add Spare Part
/// </summary>
/// <param name="sparePartName"></param>
/// <param name="description"></param>
/// <param name="additionalData"></param>
/// <param name="categoryID"></param>
/// <param name="imagepath"></param>
/// <returns></returns>
public int AddSparePart(string sparePartName, string description, string additionalData, int categoryID, string imagepath)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var sparePart = db.Set <SparePart>();
sparePart.Add(new SparePart {
SparePartName = sparePartName, CategoryID = categoryID, ImagePath = imagepath, Description = description, AdditionalData = additionalData
});
db.SaveChanges();
recordId = db.Set <SparePart>().LastOrDefault().SparePartID;
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
public int AddCrew(string name, string designation)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var crew = db.Set <Crew>();
crew.Add(new Crew {
Name = name, Designation = designation
});
db.SaveChanges();
recordId = Int32.Parse(db.Set <Crew>().LastOrDefault().Name);
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Aircraft Model
/// </summary>
/// <param name="aircraftModelname"></param>
/// <param name="description"></param>
/// <param name="additionalData"></param>
/// <param name="categoryID"></param>
/// <param name="engineTypeId"></param>
/// <param name="manufacturerId"></param>
/// <param name="imagepath"></param>
/// <returns></returns>
public int AddAircraftModel(string aircraftModelname, string description, string additionalData, int categoryID, int engineTypeId, string flightNumber, string imagepath)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var aircraftModel = db.Set <AircraftModel>();
aircraftModel.Add(new AircraftModel {
ModelName = aircraftModelname, CategoryID = categoryID, EngineTypeID = engineTypeId, FlightNumber = flightNumber, ImagePath = imagepath, Description = description, AdditionalData = additionalData
});
db.SaveChanges();
recordId = db.Set <AircraftModel>().LastOrDefault().AircraftModelID;
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Category
/// </summary>
/// <param name="categoryName"></param>
/// <param name="additionalData"></param>
/// <returns></returns>
public int AddCategory(string categoryName, string additionalData)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var category = db.Set <Category>();
category.Add(new Category {
CategoryName = categoryName, AdditionalData = additionalData
});
db.SaveChanges();
recordId = db.Set <Category>().LastOrDefault().CategoryID;
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add MaintenanceChecks
/// </summary>
/// <param name="description"></param>
/// <param name="status"></param>
/// <returns></returns>
public int AddMaintenanceChecks(string description, bool status)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var maintenanceChecks = db.Set <MaintenanceChecks>();
maintenanceChecks.Add(new MaintenanceChecks {
Description = description, status = status
});
db.SaveChanges();
recordId = Int32.Parse(db.Set <MaintenanceChecks>().LastOrDefault().Description);
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Component Work
/// </summary>
/// <param name="WorkID"></param>
/// <param name="Component"></param>
/// <param name="SerialNumber"></param>
/// <param name="FlightNumber"></param>
/// <param name="Description"></param>
/// <param name="Deliverydetails"></param>
/// <param name="CreatedDate"></param>
/// <param name="Location"></param>
/// <returns></returns>
public int AddComponentWork(int workID, string component, string serialNumber, string flightNumber, string description, /*DeliveryDetails deliveryDetails*/ string createdDate, string location)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var componentwork = db.Set <ComponentWork>();
componentwork.Add(new ComponentWork {
WorkID = workID, Component = component, SerialNumber = serialNumber, FlightNumber = flightNumber, Description = description, CreatedDate = createdDate, Location = location
});
db.SaveChanges();
recordId = (db.Set <ComponentWork>().LastOrDefault().WorkID);
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Manufacturer
/// </summary>
/// <param name="manufacturerName"></param>
/// <param name="description"></param>
/// <param name="additionalData"></param>
/// <returns></returns>
public int AddManufacturer(string manufacturerName, string description, string additionalData)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var manufacturer = db.Set <Manufacturer>();
manufacturer.Add(new Manufacturer {
ManufacturerName = manufacturerName, Description = description, AdditionalData = additionalData
});
db.SaveChanges();
recordId = Int32.Parse(db.Set <Manufacturer>().LastOrDefault().ManufacturerID);
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Get Inventory Data
/// </summary>
/// <returns></returns>
//public List<Inventory> GetInventoryData()
//{
// List<Inventory> inventory = new List<Inventory>();
// using (var db = new EasyMaintainDBContext())
// {
// //var query = from b in db.Inventories
// // orderby b.InventoryID
// // select b;
// //foreach (var item in query)
// //{
// // inventory.Add(item as Inventory);
// //}
// }
// return inventory;
//}
//--- Insert Data
/// <summary>
/// Add Supplier
/// </summary>
/// <param name="supplierName"></param>
/// <param name="emailAddress"></param>
/// <param name="address"></param>
/// <param name="contact"></param>
/// <param name="description"></param>
/// <param name="additionalData"></param>
/// <returns></returns>
public int AddSupplier(string supplierName, string emailAddress, string address, string contact, string description, string additionalData)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var supplier = db.Set <Supplier>();
supplier.Add(new Supplier {
SupplierName = supplierName, EmailAddress = emailAddress, Address = address, ContactDetails = contact, Description = description, AdditionalData = additionalData
});
db.SaveChanges();
recordId = db.Set <Supplier>().LastOrDefault().SupplierID;
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Engine Type
/// </summary>
/// <param name="engineTypeName"></param>
/// <param name="additionalData"></param>
/// <returns></returns>
public int AddMaintenance(int workID, string flightModel, string flightNumber, string description, string startDate, string completionDate, string location)
{
int recordId = -1;
// insert
using (var db = new EasyMaintainDBContext())
{
try
{
var maintenance = db.Set <Maintenance>();
int record = maintenance.Add(new Maintenance {
WorkID = workID, FlightModel = flightModel, FlightNumber = flightNumber, Description = description, StartDate = startDate, CompletionDate = completionDate, Location = location
}).WorkID;
db.SaveChanges();
//recordId = db.Set<EngineType>().LastOrDefault().WorkID;
}
catch (SqlException ex)
{
throw ex;
}
}
return(recordId);
}
/// <summary>
/// Add Manufacturer
/// </summary>
/// <param name="DeliveryDetailsId"></param>
/// <param name="DeliveryDate"></param>
/// <param name="DeliveryMethod"></param>
/// <param name="PersonInCharge"></param>
/// <param name="AddressLine1"></param>
/// <param name="AddressLine2"></param>
/// <param name="City"></param>
/// <param name="State"></param>
/// <param name="AddtionalNotes"></param>
/// <returns></returns>
public int AddDeliveryDetails(string deliveryDetailsId, string deliveryDate, string deliveryMethod, string personInCharge, string addressLine1, string addressLine2, string city, string state, string addtionalNotes)
{
// insert
using (var db = new EasyMaintainDBContext())
{
var delivery = db.Set <DeliveryDetails>();
try
{
delivery.Add(new DeliveryDetails {
DeliveryDetailsId = Int32.Parse(deliveryDetailsId), DeliveryDate = deliveryDate, DeliveryMethod = deliveryMethod, PersonInCharge = personInCharge, AddressLine1 = addressLine1, AddressLine2 = addressLine2, City = city, State = state, AddtionalNotes = addtionalNotes
});
db.SaveChanges();
}
catch (SqlException ex)
{
throw ex;
}
return(1);
}
}