/// <summary>
/// Save
/// </summary>
/// <param name="unitId">unitId</param>
/// <param name="companyId">companyId</param>
public void Save(int unitId, int companyId)
{
UnitInformationTDS unitInformationChanges = (UnitInformationTDS)Data.GetChanges();
if (unitInformationChanges.InspectionDetails.Rows.Count > 0)
{
UnitInformationInspectionDetailsGateway unitInformationInspectionDetailsGateway = new UnitInformationInspectionDetailsGateway(unitInformationChanges);
foreach (UnitInformationTDS.InspectionDetailsRow row in (UnitInformationTDS.InspectionDetailsDataTable)unitInformationChanges.InspectionDetails)
{
// Insert new inspection
if ((!row.Deleted) && (!row.InDatabase))
{
// Insert inspection
int inspectionId = row.InspectionID;
DateTime date_ = unitInformationInspectionDetailsGateway.GetDate_(inspectionId);
Int64 country = unitInformationInspectionDetailsGateway.GetCountry(inspectionId);
Int64 state = unitInformationInspectionDetailsGateway.GetState(inspectionId);
string type = unitInformationInspectionDetailsGateway.GetType(inspectionId);
string result = unitInformationInspectionDetailsGateway.GetResult(inspectionId);
decimal? cost = unitInformationInspectionDetailsGateway.GetCost(inspectionId);
string notes = unitInformationInspectionDetailsGateway.GetNotes(inspectionId);
string inspectedBy = unitInformationInspectionDetailsGateway.GetInspectedBy(inspectionId);
string attach = unitInformationInspectionDetailsGateway.GetAttach(inspectionId);
InsertInspection(unitId, inspectionId, date_, country, state, type, result, cost, notes, inspectedBy, attach, false, companyId);
}
// Update inspection
if ((!row.Deleted) && (row.InDatabase))
{
int inspectionId = row.InspectionID;
// original values
DateTime originalDate_ = unitInformationInspectionDetailsGateway.GetDate_Original(inspectionId);
Int64 originalCountry = unitInformationInspectionDetailsGateway.GetCountryOriginal(inspectionId);
Int64 originalState = unitInformationInspectionDetailsGateway.GetStateOriginal(inspectionId);
string originalType = unitInformationInspectionDetailsGateway.GetTypeOriginal(inspectionId);
string originalResult = unitInformationInspectionDetailsGateway.GetResultOriginal(inspectionId);
decimal? originalCost = unitInformationInspectionDetailsGateway.GetCostOriginal(inspectionId);
string originalNotes = unitInformationInspectionDetailsGateway.GetNotesOriginal(inspectionId);
string originalInspectedBy = unitInformationInspectionDetailsGateway.GetInspectedByOriginal(inspectionId);
string originalAttach = unitInformationInspectionDetailsGateway.GetAttachOriginal(inspectionId);
// new values
DateTime newDate_ = unitInformationInspectionDetailsGateway.GetDate_(inspectionId);
Int64 newCountry = unitInformationInspectionDetailsGateway.GetCountry(inspectionId);
Int64 newState = unitInformationInspectionDetailsGateway.GetState(inspectionId);
string newType = unitInformationInspectionDetailsGateway.GetType(inspectionId);
string newResult = unitInformationInspectionDetailsGateway.GetResult(inspectionId);
decimal? newCost = unitInformationInspectionDetailsGateway.GetCost(inspectionId);
string newNotes = unitInformationInspectionDetailsGateway.GetNotes(inspectionId);
string newInspectedBy = unitInformationInspectionDetailsGateway.GetInspectedBy(inspectionId);
string newAttach = unitInformationInspectionDetailsGateway.GetAttach(inspectionId);
UpdateInspection(unitId, inspectionId, originalDate_, originalCountry, originalState, originalType, originalResult, originalCost, originalNotes, originalInspectedBy, originalAttach, false, companyId, unitId, inspectionId, newDate_, newCountry, newState, newType, newResult, newCost, newNotes, newInspectedBy, newAttach, false, companyId);
}
// Delete inspection
if ((row.Deleted) && (row.InDatabase))
{
int inspectionId = row.InspectionID;
DeleteInspection(unitId, inspectionId, companyId);
}
}
}
}
protected void grdInspections_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Control of footer controls
if (e.Row.RowType == DataControlRowType.Footer)
{
// For Country
((DropDownList)e.Row.FindControl("ddlCountryNew")).SelectedIndex = 0;
}
// Control of edit controls
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int unitId = Int32.Parse(hdfUnitId.Value);
int inspectionId = int.Parse(((Label)e.Row.FindControl("lblInspectionIdEdit")).Text);
int companyId = Int32.Parse(hdfCompanyId.Value);
DropDownList ddlCountry = ((DropDownList)e.Row.FindControl("ddlCountryEdit"));
DropDownList ddlState = ((DropDownList)e.Row.FindControl("ddlStateEdit"));
//UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway();
//unitsInspectionGateway.LoadByUnitIdInspectionId(unitId, inspectionId, companyId);
//if (unitsInspectionGateway.Table.Rows.Count > 0)
//{
// ((DropDownList)e.Row.FindControl("ddlCountryEdit")).SelectedValue = unitsInspectionGateway.GetCountry(unitId, inspectionId).ToString();
// ((RadDatePicker)e.Row.FindControl("tkrdpInspectionDateEdit")).SelectedDate = unitsInspectionGateway.GetDate_(unitId, inspectionId);
//}
//else
//{
// ddlCountry.SelectedValue = ((DropDownList)e.Row.FindControl("ddlCountryEdit")).SelectedValue;
//}
UnitInformationInspectionDetailsGateway unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetailsGateway(unitInformationTDS);
try
{
ddlCountry.SelectedValue = unitInformationInspectionDetailsForEdit.GetCountry(inspectionId).ToString();
((RadDatePicker)e.Row.FindControl("tkrdpInspectionDateEdit")).SelectedDate = unitInformationInspectionDetailsForEdit.GetDate_(inspectionId);
}
catch
{
}
ProvinceList provinceList = new ProvinceList();
provinceList.LoadByCountryIdAndAddItem(-1, "(Select a state)", int.Parse(ddlCountry.SelectedValue));
ddlState.DataSource = provinceList.Table;
ddlState.DataValueField = "ProvinceID";
ddlState.DataTextField = "Name";
ddlState.DataBind();
try
{
ddlState.SelectedValue = unitInformationInspectionDetailsForEdit.GetState(inspectionId).ToString();
}
catch
{
}
//if (unitsInspectionGateway.Table.Rows.Count > 0)
//{
// ddlState.SelectedValue = unitsInspectionGateway.GetState(unitId, inspectionId).ToString();
//}
//else
//{
// ddlState.SelectedValue = ((DropDownList)e.Row.FindControl("ddlStateEdit")).SelectedValue;
//}
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByUnitId
/// </summary>
/// <param name="unitId">unitId</param>
/// <param name="companyId">companyId</param>
public void LoadByUnitId(int unitId, int companyId)
{
UnitInformationInspectionDetailsGateway unitInformationInspectionDetails = new UnitInformationInspectionDetailsGateway(Data);
unitInformationInspectionDetails.LoadByUnitId(unitId, companyId);
}
