/// <summary>
/// Save the Material and also a blank entry for the corresponding cost centre
/// </summary>
/// <param name="m"></param>
/// <param name="type"></param>
public void SaveMaterial(Accessor.MaterialProperties m, int type)
{
using (LinqtoNewAgeDataContext dc = new LinqtoNewAgeDataContext())
{
tblMaterial mat = new tblMaterial
{
MaterialID = m.MaterialID,
Name = m.MaterialName,
Description = m.Destcription,
TypeID = m.TypeID
};
dc.tblMaterials.InsertOnSubmit(mat);
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
switch (type)
{
#region Length
case 1:
tblLengthCost l = new tblLengthCost
{
TypeID = 1,
MaterialID = m.MaterialID,
NoPieces = 0,
TotalLength = 0,
LengthPerPiece = 0,
TotalCostPieces = 0,
PricePerMeter = 0
};
dc.tblLengthCosts.InsertOnSubmit(l);
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
#endregion Length
#region Area
case 2:
tblAreaCost a = new tblAreaCost
{
TypeID = 2,
MaterialID = m.MaterialID,
TotalLenght = 0,
TotalWidth = 0,
TotalCost = 0,
PricePerMeterSQ = 0,
TotalArea = 0
};
dc.tblAreaCosts.InsertOnSubmit(a);
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
#endregion Area
#region Volume
case 3:
tblVolumeCost v = new tblVolumeCost
{
TypeID = 3,
MaterialID = m.MaterialID,
TotalVolume = 0,
TotalCost = 0,
PricePerLiter = 0
};
dc.tblVolumeCosts.InsertOnSubmit(v);
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
#endregion Volume
#region BussinessCost
case 4:
tblBussinessCost b = new tblBussinessCost
{
TypeID = 4,
MaterialID = m.MaterialID,
CostName = m.MaterialName,
RatePerHour = 0,
};
dc.tblBussinessCosts.InsertOnSubmit(b);
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
#endregion BussinessCost
//TODO FINISH INSERT
default:
break;
}
}
}
/// <summary>
/// Sets the inititial display populating all the fields with the selection
/// </summary>
public void SetDisplay()
{
int frameTyepID = 1; //Default
switch (frameType)
{
case myFrameType.SquareTwoFifty:
frameTyepID = 1;
break;
case myFrameType.Atwo:
frameTyepID = 2;
break;
case myFrameType.SquareFourFifty:
frameTyepID = 3;
break;
case myFrameType.FourFifty:
frameTyepID = 4;
break;
case myFrameType.FiveFifty:
frameTyepID = 5;
break;
case myFrameType.Pane:
frameTyepID = 6;
break;
default:
break;
}
tblAtlanticCanvasLength o = DataEngine.GetAtlanticLength(frameTyepID, materialID);
tblMaterial mat = DataEngine.GetMaterial(materialID);
tblLengthCost length = DataEngine.GetLengthPricePerMeter(materialID);
//Top Frame
lblFrame.Text = mat.Name;
lblMaterialID.Text = materialID;
string pricePerMeter = string.Format("{0:C}", length.PricePerMeter);
lblPricePerMeter.Text = pricePerMeter;
// Details
string frameLength = string.Format("{0:0.00}", o.FrameLenght);
lblFrameLength.Text = frameLength;
string frameWidth = string.Format("{0:0.00}", o.FrameWidth);
lblFrameWidth.Text = frameWidth;
string noFrames = string.Format("{0:0.00}", o.NoOfFrames);
lblNoFrames.Text = noFrames;
string TotalUsedFrmCost = string.Format("{0:C}", o.TotalUsedFrameCost);
lblTotalUsedFrameCost.Text = TotalUsedFrmCost;
string frameArea = string.Format("{0:0.00}", o.FrameArea);
lblFrameArea.Text = frameArea;
string canvasOverlap = string.Format("{0:0.00}", o.CanvasOverlap);
lblCanvasOveralap.Text = canvasOverlap;
string totalCanvasArea = string.Format("{0:0.00}", o.TotalCanvasArea);
lblTotalCanvasArea.Text = totalCanvasArea;
string frameTotalArea = string.Format("{0:0.00}", o.TotalFrameLength);
lblTotalFrameArea.Text = o.TotalFrameLength.ToString();
atlanticID = o.AtlanticCanvasLenID;
}