protected void GvYearlyInspection_SelectedIndexChanged(object sender, EventArgs e)
{
// Get the Yearly Schedule Id
Guid ScheduleId = (Guid)GvYearlyInspection.SelectedDataKey.Value;
fldScheduleId.Value = Convert.ToString(ScheduleId);
// Get the Monthly schedule details for the selected Schedule
Inspection objInspection = new Inspection();
DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
DataTable dtOfficeDetails = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId(ScheduleId);
string officeNames = "";
// Get the selected Offices
if (dtScheduleDetails.Rows.Count > 0)
{
foreach (DataRow drScheduleDetail in dtScheduleDetails.Rows)
{
officeNames = "";
DataRow[] drOfficeDetail = dtOfficeDetails.Select("DetailScheduleId='" + drScheduleDetail["DetailScheduleId"].ToString() + "'");
for (int i = 0; i < drOfficeDetail.Length; i++)
{
officeNames += Convert.ToString(drOfficeDetail[i]["OfficeName"]) + ", ";
}
// Remove the coma at the end of the string
if (officeNames.Length > 2)
{
officeNames = officeNames.Substring(0, officeNames.Length - 2);
}
drScheduleDetail["OfficeName"] = officeNames;
}
GvInspectionDetails.DataSource = dtScheduleDetails;
GvInspectionDetails.DataBind();
}
//DropDownList ddlInspectionMonth = ((DropDownList)FvInspectionIternary.FindControl("ddlMonth" + Mode));
}
protected void FvYearlySchedule_DataBound(object sender, EventArgs e)
{
if (FvYearlySchedule.CurrentMode == FormViewMode.Edit)
{
// Get the Yearly Schedule Id
Guid ScheduleId = (Guid)GvYearlyInspection.SelectedDataKey.Values["ScheduleId"];
// Get the Monthly schedule details for the selected Schedule
Inspection objInspection = new Inspection();
DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
DataTable dtOfficeDetails = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId(ScheduleId);
string officeNames = "";
// Get the selected Offices
if (dtScheduleDetails.Rows.Count > 0)
{
foreach (DataRow drScheduleDetail in dtScheduleDetails.Rows)
{
officeNames = "";
DataRow[] drOfficeDetail = dtOfficeDetails.Select("DetailScheduleId='" + drScheduleDetail["DetailScheduleId"].ToString() + "'");
for (int i = 0; i < drOfficeDetail.Length; i++)
{
officeNames += Convert.ToString(drOfficeDetail[i]["OfficeName"]) + ", ";
}
// Remove the coma at the end of the string
if (officeNames.Length > 2)
{
officeNames = officeNames.Substring(0, officeNames.Length - 2);
}
drScheduleDetail["OfficeName"] = officeNames;
}
ViewState["ScheduleDetails"] = dtScheduleDetails;
ViewState["SelectedOffices"] = dtOfficeDetails;
GridView grd = (GridView)FvYearlySchedule.FindControl("GvInspectionDetailsUpd");
grd.DataSource = dtScheduleDetails;
grd.SelectedIndex = -1;
grd.DataBind();
}
}
}