public void Insert_NewPackHeader(New_Pack newPack)
{
using (new SharedConnection(dbConnection))
{
dbConnection.Execute(SqlLoader.GetSql("Insert_NewPackHeader"),
newPack.PackId,
newPack.PackName,
newPack.Return_TotalSizes_ToInt(),
newPack.Return_TotalUnits_ToInt()
);
}
}
public New_Pack Serialize_PackData_ToNewPack(string packID, string packName, DataGridView dgvSizeRatios)
{
New_Pack result = new New_Pack();
List <New_Pack_Sizes> packSizes = new List <New_Pack_Sizes>();
int displaySequence = 1;
foreach (DataGridViewRow _row in dgvSizeRatios.Rows)
{
New_Pack_Sizes packSize = new New_Pack_Sizes()
{
Size_Code = Convert.ToInt32(_row.Cells[0].Value.ToString()),
Qty = Convert.ToInt32(_row.Cells[2].Value.ToString()),
Display_Sequence = displaySequence
};
packSizes.Add(packSize);
displaySequence++;
}
result.PackId = packID;
result.PackName = packName;
result.SizeList = packSizes;
return(result);
}
public void Insert_NewPackDetail(New_Pack newPack)
{
using (new SharedConnection(dbConnection))
{
string _sqlInsertQuery = "INSERT ALL ";
string _sqlInsertHeaders = "INTO hir_Pack_makeup (pack_id, size_code, units_qty, display_sequence)";
foreach (New_Pack_Sizes packSize in newPack.SizeList)
{
_sqlInsertQuery += string.Format("{0} VALUES ('{1}',{2},{3},{4}) ",
_sqlInsertHeaders,
newPack.PackId,
packSize.Size_Code,
packSize.Qty,
packSize.Display_Sequence
);
}
_sqlInsertQuery += "SELECT * FROM dual";
dbConnection.Execute(_sqlInsertQuery);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
string _sumbissionErrors = app.Validate_NewPack_AllDataValid(tbPackName.Text,
dgvSizeRatios);
if (_sumbissionErrors == "")
{
New_Pack newPack = app.Return_NewPack_ToModel(this.tbPackId.Text,
this.tbPackName.Text,
this.dgvSizeRatios);
bool _isUniquePack = app.Validate_NewPack_IsUnique(newPack);
if (_isUniquePack)
{
app.Insert_NewPack_ToDB(newPack);
Run();
}
}
else
{
MessageBox.Show(_sumbissionErrors, "Please fix the following errors before continuing", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Insert_NewPackHeader_ToDB(New_Pack newPack)
{
oracleRepo.Insert_NewPackHeader(newPack);
}
public void Insert_NewPackDetail_ToDb(New_Pack newPack)
{
oracleRepo.Insert_NewPackDetail(newPack);
}
public void Insert_NewPack_ToDB(New_Pack newPack)
{
dataHandler.Insert_NewPack_ToDB(newPack);
}
public bool Validate_NewPack_IsUnique(New_Pack newPack)
{
return(validationHandler.Validate_NewPack_IsUnique(newPack));
}
public bool Validate_NewPack_IsUnique(New_Pack newPack)
{
return(true);
}
public void Insert_NewPack_ToDB(New_Pack newPack)
{
performInsert.Insert_NewPackHeader_ToDB(newPack);
performInsert.Insert_NewPackDetail_ToDb(newPack);
}
