Exemplo n.º 1
0
    protected void btnQueryAddIns_Click(object sender, EventArgs e)
    {
        string Mode = "Ins";
        Guid InspectionId = Guid.Empty;
        if (null == ViewState["InspectionQueryListDetails"])
        {
            ViewState["InspectionQueryListDetails"] = new Inspection().GetInspectionQueriesByInspectionId(Guid.Empty);
            InspectionId = Guid.Empty;
        }
        GridView GvInspectionQueries = ((GridView) WzInspection.FindControl("GvInspectionQueries" + Mode));
        DataTable dtInspectionQueryListDetails = (DataTable) ViewState["InspectionQueryListDetails"];
        DropDownList ddlCheckListId = ((DropDownList) WzInspection.FindControl("ddlCheckListId" + Mode));
        TextBox txtQuery = (TextBox) WzInspection.FindControl("txtQuery" + Mode);
        TextBox txtQueryRemarks = (TextBox) WzInspection.FindControl("txtQueryRemarks" + Mode);

        DataRow dr = dtInspectionQueryListDetails.NewRow();
        dr["QueryId"] = Guid.NewGuid();
        dr["InspectionId"] = Guid.Empty;
        dr["CheckListId"] = ddlCheckListId.SelectedItem.Value;
        dr["Description"] = ddlCheckListId.SelectedItem.Text;

        dr["Query"] = txtQuery.Text;
        dr["Remarks"] = txtQueryRemarks.Text;

        dtInspectionQueryListDetails.Rows.Add(dr);
        ViewState["InspectionQueryListDetails"] = dtInspectionQueryListDetails;
        GvInspectionQueries.DataSource = (DataTable) ViewState["InspectionQueryListDetails"];
        GvInspectionQueries.DataBind();
        txtQuery.Text = "";
        txtQueryRemarks.Text = "";
    }
Exemplo n.º 2
0
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        Inspection objinspection= new Inspection();

        GvInspectionMemo.DataSource = objinspection.SearchInspectionDetails(txtInspectionNo.Text);
        GvInspectionMemo.DataBind();
    }
Exemplo n.º 3
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        string Mode = "Ins";
        Guid InspectionId = Guid.Empty;
        if (null == ViewState["MemoDetails"])
        {
            ViewState["MemoDetails"] = new Inspection().GetInspectionMemoById(Guid.Empty);
            InspectionId = Guid.Empty;
        }
        if (fvMemo.CurrentMode == FormViewMode.Edit)
        {
            InspectionId = (Guid) fvMemo.DataKey["InspectionId"];
            Mode = "Upd";
        }

        //	GridView GvInspectionMemoDetailsIns = (GridView) sender;

        DataTable dtMemoDetails = (DataTable) ViewState["MemoDetails"];

        TextBox txtSubject = ((TextBox) fvMemo.FindControl("txtSubject" + Mode));
        TextBox txtMemoDate = ((TextBox) fvMemo.FindControl("txtMemoDate" + Mode));
        TextBox txtMemoBody = ((TextBox) fvMemo.FindControl("txtMemoBody" + Mode));

        object[] keys = new object[gvMemo.SelectedDataKey.Values.Count];
        for (int i = 0; i < keys.Length; i++)
        {
            keys[i] = gvMemo.SelectedDataKey.Values[i];
        }
        DataRow dr = dtMemoDetails.Rows.Find(keys);

        if (null != dr)
        {
         dr["InspectionMemoId"] = Guid.NewGuid();

        dr["Subject"] = txtSubject.Text;
        dr["MemoDate"] = txtMemoDate.Text.ToString();
        dr["MemoBody"] = txtMemoBody.Text;
        //dr["MemoDate"] = txtMemoDate.

        dr["InspectionId"] = InspectionId;
        //dtMemoDetails.Rows.Add(dr);

        }

        gvMemo.DataSource = (DataTable) ViewState["MemoDetails"];
        //	gvMemo.DataBind();
        gvMemo.SelectedIndex = -1;
        txtSubject.Text = "";
        txtMemoDate.Text = "";
        txtMemoBody.Text = "";

        ((Button) fvMemo.FindControl("btnAdd")).Visible = true;
        ((Button) fvMemo.FindControl("btnUpdate")).Visible = false;
    }
Exemplo n.º 4
0
    protected void FvInspectionIternary_DataBound(object sender, EventArgs e)
    {
        string Mode = String.Empty;
        switch (FvInspectionIternary.CurrentMode)
        {
            case FormViewMode.Edit:
                Mode = "Upd";
                break;
            case FormViewMode.Insert:
                Mode = "Ins";
                break;
            case FormViewMode.ReadOnly:
                Mode = "Itm";
                break;
            default:
                break;
        }

        // Get the Yearly Schedule Id
        Guid ScheduleId = new Guid(fldScheduleId.Value);
        // Get the Monthly schedule details for the selected Schedule
        Inspection objInspection = new Inspection();
        DataTable dtScheduleDetails = objInspection.GetYearlyInspectionDetailsById(ScheduleId);
        DropDownList ddlInspectionMonth = ((DropDownList)FvInspectionIternary.FindControl("ddlMonth" + Mode));

        GvInspectionDetails.DataSource = dtScheduleDetails;
        GvInspectionDetails.DataBind();
        if (dtScheduleDetails.Rows.Count > 0)
        {
            //int year= (int)dtScheduleDetails.Rows[0]["Year"];
            //Label lblYear = (Label)FvInspectionIternary.FindControl("lblYear" + Mode);
            //if (lblYear != null)
            //    lblYear.Text = Convert.ToString(year);

            //PopCalendar popInspectingDate = (PopCalendar)FvInspectionIternary.FindControl("popInspectingDate" + Mode);

            //RangeFrom DateFrom = new RangeFrom();
            //RangeTo DateTo = new RangeTo();

            //DateFrom.Date = new DateTime(year, ddlInspectionMonth.SelectedIndex, 01);
            //DateTo.Date = new DateTime(year, ddlInspectionMonth.SelectedIndex, DateTime.DaysInMonth(year, ddlInspectionMonth.SelectedIndex));

            //if (popInspectingDate != null){
                //popInspectingDate.From = DateFrom;
                //popInspectingDate.To = DateTo;
            //}
            ddlInspectionMonth.SelectedIndex = Convert.ToInt32(dtScheduleDetails.Rows[0]["Month"]);
        }
    }
Exemplo n.º 5
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     Inspection ins = new Inspection();
 }
Exemplo n.º 6
0
 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));
 }
Exemplo n.º 7
0
    protected void btnQueryUpdateIns_Click(object sender, EventArgs e)
    {
        string Mode = "Ins";
        Guid InspectionId = Guid.Empty;
        if (null == ViewState["InspectionQueryListDetails"])
        {
            ViewState["InspectionQueryListDetails"] = new Inspection().GetInspectionQueriesByInspectionId(Guid.Empty);
            InspectionId = Guid.Empty;
        }

        GridView GvInspectionQueries = ((GridView) WzInspection.FindControl("GvInspectionQueries" + Mode));
        DataTable dtInspectionQueryListDetails = (DataTable) ViewState["InspectionQueryListDetails"];

        DropDownList ddlCheckListId = ((DropDownList) WzInspection.FindControl("ddlCheckListId" + Mode));
        TextBox txtQuery = ((TextBox) WzInspection.FindControl("txtQuery" + Mode));
        TextBox txtQueryRemarks = ((TextBox) WzInspection.FindControl("txtQueryRemarks" + Mode));
        object[] keys = { GvInspectionQueries.SelectedDataKey.Value };

        DataRow dr = dtInspectionQueryListDetails.Rows.Find(keys);
        if (null != dr)
        {
            dr["CheckListId"] = ddlCheckListId.SelectedValue;
            dr["Query"] = txtQuery.Text;
            dr["Remarks"] = txtQueryRemarks.Text;

        }

        ((Button) WzInspection.FindControl("btnQueryAdd" + Mode)).Visible = true;
        ((Button) WzInspection.FindControl("btnQueryUpdate" + Mode)).Visible = false;

        GvInspectionQueries.DataSource = (DataTable) ViewState["InspectionQueryListDetails"];
        GvInspectionQueries.DataBind();
        GvInspectionQueries.SelectedIndex = -1;

        txtQuery.Text = "";
        txtQueryRemarks.Text = "";
    }
Exemplo n.º 8
0
    protected void WzInspection_FinishButtonClick(object sender, WizardNavigationEventArgs e)
    {
        Inspection objInspection = new Inspection();

        InspectionDetailsRow InspectionDetails = Inspection.GetInspectionDetailsRow();
        InspectionDetails.InspectionTypeId = new Guid(ddlInspectionTypeIdIns.SelectedValue);
        InspectionDetails.InspectingOfficerId = new Guid(ddlInspectingOfficerIdIns.SelectedValue);
        InspectionDetails.InspectorOfficeName = txtInspectorOfficeNameIns.Text;
        InspectionDetails.InspectedOfficeId = new Guid(ddlInspectedOfficeIdIns.SelectedValue);
        InspectionDetails.LicenseId = new Guid(ddlLicenseIdIns.SelectedValue);
        InspectionDetails.IsDiscrepancyFound = chkIsDiscrepancyFoundIns.Checked;
        InspectionDetails.Remarks = txtInspectionRemarksIns.Text;

        Wizard Container = (Wizard) Master.FindControl("Main").FindControl("WzInspection");
        List<CheckListInspectionRow> CheckListRows = new List<CheckListInspectionRow>();

        string filename = Server.MapPath("~\\Inspection\\InspectionCheckList.xml");

        XmlDocument InspectionCheckListXml = new XmlDocument();
        InspectionCheckListXml.Load(filename);

        foreach (XmlNode Node in InspectionCheckListXml.SelectNodes("DocumentElement/Page/Items"))
        {
            CheckListInspectionRow CheckListRow = Inspection.GetCheckListRow();
            TextBox txtRemarks = (TextBox) Container.FindControl("txt" + Node.Attributes["ItemId"].Value);
            CheckBox chkYesNo = (CheckBox) Container.FindControl("chk" + Node.Attributes["ItemId"].Value);

            CheckListRow.InspectionCheckListId = new Guid(Node.Attributes["ItemId"].Value);
            if (null != txtRemarks)
                CheckListRow.Remarks = txtRemarks.Text;
            else
                CheckListRow.SetRemarksNull();

            if (null != chkYesNo)
                CheckListRow.Checked = chkYesNo.Checked;
            else
                CheckListRow.Checked = false;

            CheckListRows.Add(CheckListRow);
        }

        DataTable InspectionQueries = (DataTable) ViewState["InspectionQueryListDetails"];

        //objInspection.AddNewInspection(InspectionDetails, CheckListRows, InspectionQueries);
    }
Exemplo n.º 9
0
 protected void WzInspection_DataBinding(object sender, EventArgs e)
 {
     GridView GvInspectionDetails = ((GridView) mvInspectionDetails.FindControl("GvInspectionDetails"));
     Guid InspectionId = (Guid) GvInspectionDetails.SelectedDataKey.Value;
     Inspection objInspection = new Inspection();
     DataTable dtInspectionDetails = new DataTable();
     //dtInspectionDetails = objInspection.GetAllInspectionDetailsById(InspectionId);
     txtInspectorOfficeNameUpd.Text = Convert.ToString(dtInspectionDetails.Columns["InspectorOfficeName"]);
     DataTable dtQueries = new DataTable();
     dtQueries = objInspection.GetInspectionQueriesByInspectionId(InspectionId);
     GvInspectionQueriesUpd.DataSource = dtQueries;
     GvInspectionQueriesUpd.DataBind();
 }
Exemplo n.º 10
0
    protected void WzInspectionUpd_DataBinding(object sender, EventArgs e)
    {
        if (fldSelectedKey.Value != "")
        {
            Guid InspectionId = new Guid(fldSelectedKey.Value);

            Inspection objInspection = new Inspection();
            DataRow drInspectionDetails = objInspection.GetInspectionDetailsById(InspectionId).Rows[0];

            //ddlInspectionTypeIdUpd.DataValueField = ((Guid) drInspectionDetails["InspectionTypeId"]).ToString();
            // ddlInspectingOfficerIdUpd.DataValueField = ((Guid) drInspectionDetails["InspectingOfficerId"]).ToString();

            //ddlInspectionTypeIdUpd.DataTextField = ((Guid) drInspectionDetails["InspectionTypeId"]).ToString();
            //ddlInspectingOfficerIdUpd.DataTextField = ((Guid) drInspectionDetails["InspectingOfficerId"]).ToString();

            //txtInspectorOfficeNameUpd.Text = ((Guid) drInspectionDetails["InspectorOfficeName"]).ToString();
            txtInspectorOfficeNameUpd.Text = Convert.ToString(drInspectionDetails["InspectorOfficeName"]);
            IsdescripancyFoundUpd.Checked = (bool) (drInspectionDetails["IsDiscrepancyFound"]);
            txtInspectionRemarksUpd.Text = Convert.ToString(drInspectionDetails["Remarks"]);

            DataTable dtQueries = new DataTable();

            dtQueries = objInspection.GetInspectionQueriesByInspectionId(InspectionId);

            GvInspectionQueriesUpd.DataSource = dtQueries;
            GvInspectionQueriesUpd.DataBind();

            Wizard Container = (Wizard) Master.FindControl("Main").FindControl("WzInspectionUpd");
            List<CheckListInspectionRow> CheckListRows = new List<CheckListInspectionRow>();

            string filename = Server.MapPath("~\\Inspection\\InspectionCheckList.xml");
            XmlDocument InspectionCheckListXml = new XmlDocument();
            InspectionCheckListXml.Load(filename);

            foreach (XmlNode Node in InspectionCheckListXml.SelectNodes("DocumentElement/Items"))
            {

                CheckListInspectionTable dtChecklist = new CheckListInspectionTable();
                dtChecklist = (CheckListInspectionTable) objInspection.GetInspectionCheckListById(InspectionId);
                CheckListInspectionRow drCheckListRow = Inspection.GetCheckListRow();
                Guid[] keys = { InspectionId,
                                new Guid(Node.Attributes["ItemId"].Value) };
                drCheckListRow = (CheckListInspectionRow) dtChecklist.FindByInspectionIdInspectionCheckListId(keys[0], keys[1]);
                TextBox txtRemarks = (TextBox) Container.FindControl("txt" + Node.Attributes["ItemId"].Value);
                CheckBox chkYesNo = (CheckBox) Container.FindControl("chk" + Node.Attributes["ItemId"].Value);
                if (null != txtRemarks)
                {
                    txtRemarks.Text = Convert.ToString(drCheckListRow["Remarks"]);
                }
                if (null != chkYesNo)
                {
                    chkYesNo.Checked = (bool) drCheckListRow["Checked"];
                }

            }

        }
    }
Exemplo n.º 11
0
    protected void GvInspectionQueriesUpd_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (fldSelectedKey.Value != "")
        {
            Guid InspectionId = new Guid(fldSelectedKey.Value);
            string Mode = "Upd";

            if (null == ViewState["InspectionQueryListDetails"])
            {
                ViewState["InspectionQueryListDetails"] = new Inspection().GetInspectionQueriesByInspectionId(InspectionId);

            }
            GridView GvInspectionQueries = ((GridView) WzInspectionUpd.FindControl("GvInspectionQueries" + Mode));

            DataTable dtInspectionQueryListDetails = (DataTable) ViewState["InspectionQueryListDetails"];

            DropDownList ddlCheckListId = ((DropDownList) WzInspectionUpd.FindControl("ddlCheckListId" + Mode));
            TextBox txtQuery = ((TextBox) WzInspectionUpd.FindControl("txtQuery" + Mode));
            TextBox txtQueryRemarks = ((TextBox) WzInspectionUpd.FindControl("txtQueryRemarks" + Mode));
            object[] keys = { GvInspectionQueries.SelectedDataKey.Value };

            DataRow dr = dtInspectionQueryListDetails.Rows.Find(keys);

            if (null != dr)
            {
                ddlCheckListId.SelectedValue = Convert.ToString(dr["CheckListId"]);

                txtQuery.Text = Convert.ToString(dr["Query"]);

                txtQueryRemarks.Text = Convert.ToString(dr["Remarks"]);
            }

            ((Button) WzInspectionUpd.FindControl("btnQueryAdd" + Mode)).Visible = false;
            ((Button) WzInspectionUpd.FindControl("btnQueryUpdate")).Visible = true;

        }
    }
Exemplo n.º 12
0
    protected void GvInspectionQueriesUpd_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        if (fldSelectedKey.Value != "")
        {
            Guid InspectionId = new Guid(fldSelectedKey.Value);
            string Mode = "Upd";

            if (null == ViewState["InspectionQueryListDetails"])
            {
                ViewState["InspectionQueryListDetails"] = new Inspection().GetInspectionQueriesByInspectionId(InspectionId);

            }

            GridView GvInspectionQueries = (GridView) sender;
            DataTable dtInspectionQueryListDetails = (DataTable) ViewState["InspectionQueryListDetails"];
            int i = e.RowIndex;
            dtInspectionQueryListDetails.Rows[i].Delete();
            dtInspectionQueryListDetails.AcceptChanges();

            ViewState["InspectionQueryListDetails"] = dtInspectionQueryListDetails;
            GvInspectionQueries.DataSource = ViewState["InspectionQueryListDetails"];
            GvInspectionQueries.DataBind();

        }
    }
Exemplo n.º 13
0
    protected void GvInspectionQueriesIns_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Guid InspectionId = Guid.Empty;
        if (null == ViewState["InspectionQueryListDetails"])
        {
            ViewState["InspectionQueryListDetails"] = new Inspection().GetInspectionQueriesByInspectionId(Guid.Empty);
            InspectionId = Guid.Empty;
        }

        GridView GvInspectionQueries = (GridView) sender;
        DataTable dtInspectionQueryListDetails = (DataTable) ViewState["InspectionQueryListDetails"];
        int i = e.RowIndex;
        dtInspectionQueryListDetails.Rows[i].Delete();
        dtInspectionQueryListDetails.AcceptChanges();

        ViewState["InspectionQueryListDetails"] = dtInspectionQueryListDetails;
        GvInspectionQueries.DataSource = ViewState["InspectionQueryListDetails"];
        GvInspectionQueries.DataBind();
    }
    protected void GvInspectionDetailsIns_SelectedIndexChanged(object sender, EventArgs e)
    {
        string Mode = String.Empty;
        switch (FvYearlySchedule.CurrentMode)
        {
            case FormViewMode.Edit:
                Mode = "Upd";
                break;
            case FormViewMode.Insert:
                Mode = "Ins";
                break;
            case FormViewMode.ReadOnly:
                Mode = "Itm";
                break;
            default:
                break;
        }

        // Declare the varioables and get reference to the controls
        Guid ScheduleId = Guid.Empty;
        GridView gvInspectionDetails = ((GridView)FvYearlySchedule.FindControl("GvInspectionDetails" + Mode));
        DropDownList ddlMonth = ((DropDownList)FvYearlySchedule.FindControl("ddlMonth" + Mode));
        ListBox lstInspectingOffice = ((ListBox)FvYearlySchedule.FindControl("lstInspectingOffice" + Mode));
        TextBox txtDetailRemarks = ((TextBox)FvYearlySchedule.FindControl("txtDetailRemarks" + Mode));

        if (null == ViewState["ScheduleDetails"])
        {
            ViewState["ScheduleDetails"] = new Inspection().GetYearlyInspectionDetailsById(Guid.Empty);
            ScheduleId = Guid.Empty;
        }
        if (FvYearlySchedule.CurrentMode == FormViewMode.Edit)
        {
            if (null == ViewState["SelectedOffices"])
            {
                ViewState["SelectedOffices"] = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId((Guid)gvInspectionDetails.SelectedDataKey.Value);
            }
            ScheduleId = (Guid)FvYearlySchedule.DataKey["ScheduleId"];
        }

        DataTable dtScheduleDetails = (DataTable)ViewState["ScheduleDetails"];
        DataTable dtOfficeDetails = (DataTable)ViewState["SelectedOffices"];

        object[] keys = { gvInspectionDetails.SelectedDataKey.Value };
        DataRow drScheduleDetail = dtScheduleDetails.Rows.Find(keys);
        Guid DetailScheduleId = (Guid)drScheduleDetail["DetailScheduleId"];

        if (null != drScheduleDetail)
        {
            ddlMonth.SelectedValue = Convert.ToString(drScheduleDetail["Month"]);
            txtDetailRemarks.Text = Convert.ToString(drScheduleDetail["Remarks"]);

            // Find and select each of the Offices
            lstInspectingOffice.ClearSelection();
            foreach (DataRow row in dtOfficeDetails.Rows)
            {
                if (DetailScheduleId.Equals(row["DetailScheduleId"]))
                    lstInspectingOffice.Items.FindByValue(row["InspectingOfficeId"].ToString()).Selected = true;
            }
        }

        // Show appropriate buttons
        ((Button)FvYearlySchedule.FindControl("btnAddInspectionDetail" + Mode)).Visible = false;
        ((Button)FvYearlySchedule.FindControl("btnUpdateInspectionDetail" + Mode)).Visible = true;
    }
    //protected void GvInspectionDetailsIns_SelectedIndexChanged(object sender, EventArgs e)
    //{
    //    string Mode=String.Empty;
    //    switch (FvYearlySchedule.CurrentMode)
    //    {
    //        case FormViewMode.Edit:
    //            Mode = "Upd";
    //            break;
    //        case FormViewMode.Insert:
    //            Mode = "Ins";
    //            break;
    //        case FormViewMode.ReadOnly:
    //            Mode = "Itm";
    //            break;
    //        default:
    //            break;
    //    }
    //    // Declare the varioables and get reference to the controls
    //    Guid ScheduleId = Guid.Empty;
    //    GridView gvInspectionDetails = ((GridView) FvYearlySchedule.FindControl("GvInspectionDetails" + Mode));
    //    DropDownList ddlMonth = ((DropDownList) FvYearlySchedule.FindControl("ddlMonth" + Mode));
    //    ListBox lstInspectingOffice = ((ListBox) FvYearlySchedule.FindControl("lstInspectingOffice" + Mode));
    //    TextBox txtDetailRemarks = ((TextBox) FvYearlySchedule.FindControl("txtDetailRemarks" + Mode));
    //    if (null == ViewState["ScheduleDetails"])
    //    {
    //        ViewState["ScheduleDetails"] = new Inspection().GetYearlyInspectionDetailsById(Guid.Empty);
    //        ScheduleId = Guid.Empty;
    //    }
    //    if (FvYearlySchedule.CurrentMode == FormViewMode.Edit)
    //    {
    //        if (null == ViewState["SelectedOffices"])
    //        {
    //            ViewState["SelectedOffices"] = new Inspection().GetMonthlyInspectionScheduleByDetailScheduleId((Guid)gvInspectionDetails.SelectedDataKey.Value);
    //        }
    //        ScheduleId = (Guid)FvYearlySchedule.DataKey["ScheduleId"];
    //    }
    //    DataTable dtScheduleDetails = (DataTable) ViewState["ScheduleDetails"];
    //    DataTable dtOfficeDetails = (DataTable) ViewState["SelectedOffices"];
    //    object[] keys = { gvInspectionDetails.SelectedDataKey.Value };
    //    DataRow drScheduleDetail = dtScheduleDetails.Rows.Find(keys);
    //    Guid DetailScheduleId = (Guid)drScheduleDetail["DetailScheduleId"];
    //    if (null != drScheduleDetail)
    //    {
    //        ddlMonth.SelectedValue = Convert.ToString(drScheduleDetail["Month"]);
    //        txtDetailRemarks.Text = Convert.ToString(drScheduleDetail["Remarks"]);
    //        // Find and select each of the Offices
    //        lstInspectingOffice.ClearSelection();
    //        foreach (DataRow row in dtOfficeDetails.Rows)
    //        {
    //            if (DetailScheduleId.Equals(row["DetailScheduleId"]))
    //                lstInspectingOffice.Items.FindByValue(row["InspectingOfficeId"].ToString()).Selected = true;
    //        }
    //    }
    //    ((Button) FvYearlySchedule.FindControl("btnAddInspectionDetail" + Mode)).Visible = false;
    //    ((Button) FvYearlySchedule.FindControl("btnUpdateInspectionDetail" + Mode)).Visible = true;
    //}
    protected void GvInspectionDetailsIns_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Guid ScheduleId = Guid.Empty;
        if (null == ViewState["ScheduleDetails"])
        {
            ViewState["ScheduleDetails"] = new Inspection().GetYearlyInspectionDetailsById(Guid.Empty);
            ScheduleId = Guid.Empty;
        }
        if (FvYearlySchedule.CurrentMode == FormViewMode.Edit)
        {
            ScheduleId = (Guid)FvYearlySchedule.DataKey["ScheduleId"];
        }

        GridView GvInspectionDetails = (GridView)sender;
        DataTable dtScheduleDetails = (DataTable)ViewState["ScheduleDetails"];
        int i = e.RowIndex;
        dtScheduleDetails.Rows[i].Delete();
        dtScheduleDetails.AcceptChanges();

        ViewState["ScheduleDetails"] = dtScheduleDetails;
        GvInspectionDetails.DataSource = ViewState["ScheduleDetails"];
        GvInspectionDetails.DataBind();
    }
    //public void InitofficesAssigned()
    //{
    //    dtofficesSelected = (DataTable)Session["ActsApplicable"];
    //    if (dtofficesSelected == null)
    //    {
    //        dtofficesSelected = new DataTable();
    //        dtofficesSelected.Columns.Add("OfficeId", typeof(Guid));
    //        dtofficesSelected.Columns.Add("OfficeName", typeof(bool));
    //        dtofficesSelected.PrimaryKey = new DataColumn[] { dtActsApplicable.Columns["OfficeId"] };
    //    }
    //}
    protected void btnAddDetail_Click(object sender, EventArgs e)
    {
        string Mode = String.Empty;
        switch (FvYearlySchedule.CurrentMode)
        {
            case FormViewMode.Edit:
                Mode = "Upd";
                break;
            case FormViewMode.Insert:
                Mode="Ins";
                break;
            case FormViewMode.ReadOnly:
                Mode="Itm";
                break;
            default:
                break;
        }
        string inspectionOffices = "";

        if (null == ViewState["ScheduleDetails"])
        {
            ViewState["ScheduleDetails"] = new Inspection().GetYearlyInspectionDetailsById(Guid.Empty);
        }

        // Check if office details already exist in the ViewState
        if (null == ViewState["SelectedOffices"])
        {
            // Create the Office Details schema
            DataTable SelectedOffices = new DataTable();
            SelectedOffices = new DataTable();
            SelectedOffices.Columns.Add("MonthlyScheduleId", typeof(Guid));
            SelectedOffices.Columns.Add("DetailScheduleId", typeof(Guid));
            SelectedOffices.Columns.Add("InspectingOfficeId", typeof(Guid));
            SelectedOffices.PrimaryKey = new DataColumn[] { SelectedOffices.Columns["MonthlyScheduleId"]};

            ViewState["SelectedOffices"] = SelectedOffices;
        }

        // Get the coltrols
        DataTable dtScheduleDetails = (DataTable)ViewState["ScheduleDetails"];
        DataTable dtOfficeDetails = (DataTable)ViewState["SelectedOffices"];
        GridView grdScheduleDetails = ((GridView)FvYearlySchedule.FindControl("GvInspectionDetails" + Mode));
        DropDownList ddlInspectionMonth = ((DropDownList)FvYearlySchedule.FindControl("ddlMonth" + Mode));
        ListBox lstInspectingOffice = ((ListBox)FvYearlySchedule.FindControl("lstInspectingOffice" + Mode));
        TextBox txtDetailRemarks = ((TextBox)FvYearlySchedule.FindControl("txtDetailRemarks" + Mode));

        // Create the DataRow to insert Yearly Schedule Details (each Month)
        DataRow drScheduleDetail = null;
        // Assign coluimn values
        Guid ScheduleId = Guid.Empty;
        Guid DetailScheduleId = Guid.NewGuid();
        drScheduleDetail = dtScheduleDetails.NewRow();
        drScheduleDetail["ScheduleId"] = ScheduleId;
        drScheduleDetail["DetailScheduleId"] = DetailScheduleId;
        drScheduleDetail["Month"] = Convert.ToDecimal(ddlInspectionMonth.SelectedValue);
        drScheduleDetail["Remarks"] = txtDetailRemarks.Text;

        // Get the selected offices
        foreach (ListItem Item in lstInspectingOffice.Items)
        {
            if (Item.Selected)
            {
                // Create the DataRow to insert Office details (each Office/Month)
                DataRow drOfficeDetail = null;
                drOfficeDetail = dtOfficeDetails.NewRow();
                drOfficeDetail["MonthlyScheduleId"] = Guid.NewGuid();
                drOfficeDetail["DetailScheduleId"] = DetailScheduleId;
                drOfficeDetail["InspectingOfficeId"] = Item.Value;

                // Generate the coma seperated text to display in the Grid
                inspectionOffices += Item.Text + ", ";
                dtOfficeDetails.Rows.Add(drOfficeDetail);
            }
        }
        // Remove the coma at the end of the string
        if (inspectionOffices.Length > 2)
        {
            inspectionOffices = inspectionOffices.Substring(0, inspectionOffices.Length - 2);
        }

        // Add the coma seperated text to the column value
        drScheduleDetail["OfficeName"] = inspectionOffices;
        // Add the row to the table
        dtScheduleDetails.Rows.Add(drScheduleDetail);

        // Store OfficeDetails and ScheduleDetails in ViewState
        ViewState["SelectedOffices"] = dtOfficeDetails;
        ViewState["ScheduleDetails"] = dtScheduleDetails;

        // Reset the Controls
        ddlInspectionMonth.SelectedIndex = -1;
        lstInspectingOffice.SelectedIndex = -1;
        txtDetailRemarks.Text = String.Empty;
        grdScheduleDetails.SelectedIndex = -1;

        // Bind the DataGrid
        grdScheduleDetails.DataSource = dtScheduleDetails;
        grdScheduleDetails.DataBind();
    }
    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();
            }
        }
    }