/// <summary>
/// Create a new Specification object.
/// </summary>
/// <param name="specID">Initial value of the SpecID property.</param>
/// <param name="machineID">Initial value of the MachineID property.</param>
/// <param name="specUrl">Initial value of the SpecUrl property.</param>
/// <param name="status">Initial value of the Status property.</param>
/// <param name="machineSpecID">Initial value of the MachineSpecID property.</param>
public static Specification CreateSpecification(global::System.Int32 specID, global::System.Int32 machineID, global::System.String specUrl, global::System.String status, global::System.Int32 machineSpecID)
{
Specification specification = new Specification();
specification.SpecID = specID;
specification.MachineID = machineID;
specification.SpecUrl = specUrl;
specification.Status = status;
specification.MachineSpecID = machineSpecID;
return specification;
}
/// <summary>
/// Deprecated Method for adding a new object to the Specifications EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSpecifications(Specification specification)
{
base.AddObject("Specifications", specification);
}
protected void btnUploadSpec_Click(object sender, EventArgs e)
{
if (uploadFile.HasFile == false)
{
UploadDetails.Text = "Please first select a file to upload...";
}
else
{
using (GESEntities db = new GESEntities())
{
int iMachineID = Int32.Parse(lblMachineID.Text.Substring(lblMachineID.Text.IndexOf(":") + 1).Trim());
//Fetch next photo # in the photo table for this machine
int iNextSpecID = 0;
System.Nullable<Int32> GetNextSpec = (from p in db.Specifications where p.MachineID == iMachineID select (int?)p.MachineSpecID).Max();
if (GetNextSpec.HasValue)
{
iNextSpecID = GetNextSpec.Value + 1;
}
else
{
iNextSpecID = 1;
}
//Save the image
string fileName = iMachineID.ToString() + "-" + iNextSpecID.ToString() + Path.GetExtension(uploadFile.FileName);
string filePath = Server.MapPath("~/Specs/" + fileName);
string fileNameTemp = "Temp" + iMachineID.ToString() + "-" + iNextSpecID.ToString() + Path.GetExtension(uploadFile.FileName);
string filePathTemp = Server.MapPath("~/Specs/" + fileNameTemp);
uploadFile.SaveAs(filePathTemp);
//delete Temp file
if (File.Exists(filePathTemp))
{
File.Delete(filePathTemp);
}
// Display the uploaded file's details
UploadDetails.Text = string.Format(@"Uploaded file: {0}<br /> File size (in bytes): {1:N0}<br /> Content-type: {2}", uploadFile.FileName, uploadFile.FileBytes.Length, uploadFile.PostedFile.ContentType);
//insert a row into the photos table
Specification newSpec = new Specification();
newSpec.MachineID = iMachineID;
newSpec.SpecName = "Test";
newSpec.SpecDescription = "Test";
newSpec.SpecUrl = "Specs/" + fileName;
newSpec.Status = "Active";
newSpec.MachineSpecID = iNextSpecID;
db.Specifications.AddObject(newSpec);
db.SaveChanges();
//Refresh thumbnail list
SpecsEntityDataSource.WhereParameters.Clear();
SpecsEntityDataSource.AutoGenerateWhereClause = true;
SpecsEntityDataSource.WhereParameters.Add("MachineID", TypeCode.Int32, iMachineID.ToString());
gridSpecs.Visible = true;
}
}
}
