private void dgPMSchedules_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            try
            {
                dgPMSchedules.EditItemIndex = -1;
                pmitems = new clsPMSchedService();
                pmitems.iOrgId = OrgId;
                dgPMSchedules.DataSource = pmitems.GetPMSchedulesList();
                dgPMSchedules.DataBind();

            }
            catch(Exception ex)
            {
                _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
                Session["lastpage"] = "admin_pmschedules.aspx";
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(pmitems != null)
                    pmitems.Dispose();
            }
        }
 private void dgPMSchedules_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 {
     try
     {
         pmitems = new clsPMSchedService();
         pmitems.cAction = "U";
         pmitems.iOrgId = OrgId;
         pmitems.iPMSchedId = Convert.ToInt32(e.CommandArgument);
         pmitems.sPMSchedName = ((TextBox)e.Item.FindControl("tbPMScheduleName")).Text;
         if(pmitems.PMScheduleDetails() == -1)
         {
             Header.ErrorMessage = _functions.ErrorMessage(169);
         }
         else
         {
             dgPMSchedules.EditItemIndex = -1;
             dgPMSchedules.DataSource = pmitems.GetPMSchedulesList();
             dgPMSchedules.DataBind();
         }
     }
     catch(Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"] = "admin_pmschedules.aspx";
         Session["error"] = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if(pmitems != null)
             pmitems.Dispose();
     }
 }
        private void btnAddSchedule_Click(object sender, System.EventArgs e)
        {
            try
            {
                pmitems = new clsPMSchedService();
                pmitems.cAction = "U";
                pmitems.iOrgId = OrgId;
                pmitems.iPMSchedId = 0;
                pmitems.sPMSchedName = tbScheduleName.Text;
                pmitems.PMScheduleDetails();
                dgPMSchedules.EditItemIndex = -1;
                dgPMSchedules.DataSource = pmitems.GetPMSchedulesList();
                dgPMSchedules.DataBind();
                tbScheduleName.Text = "";

            }
            catch(Exception ex)
            {
                _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
                Session["lastpage"] = "admin_pmschedules.aspx";
                Session["error"] = ex.Message;
                Session["error_report"] = ex.ToString();
                Response.Redirect("error.aspx", false);
            }
            finally
            {
                if(pmitems != null)
                    pmitems.Dispose();
            }
        }
 private void dgPMSchedules_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 {
     try
     {
         pmitems = new clsPMSchedService();
         pmitems.cAction = "D";
         pmitems.iOrgId = OrgId;
         pmitems.iPMSchedId = Convert.ToInt32(e.CommandArgument);
         switch(pmitems.PMScheduleDetails())
         {
             case -1:
                 Header.ErrorMessage = _functions.ErrorMessage(169);
                 return;
             case -2:
                 Header.ErrorMessage = _functions.ErrorMessage(170);
                 return;
             case -3:
                 Header.ErrorMessage = _functions.ErrorMessage(171);
                 return;
             default:
                 break;
         }
         dgPMSchedules.EditItemIndex = -1;
         dgPMSchedules.DataSource = pmitems.GetPMSchedulesList();
         dgPMSchedules.DataBind();
     }
     catch(Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"] = "admin_pmschedules.aspx";
         Session["error"] = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if(pmitems != null)
             pmitems.Dispose();
     }
 }
        private void ShowPMItems()
        {
            try
            {
                pmsched = new clsPMSchedService();
                pmsched.iOrgId = OrgId;
                pmsched.iInspectItemId = ItemId;
                dsPMSchedServices = pmsched.GetPMSchedPMServicesList();
                dsPMSchedServices.Relations.Add(new DataRelation( "Schedules_Services", dsPMSchedServices.Tables["Table"].Columns["Id"], dsPMSchedServices.Tables["Table1"].Columns["PMSchedId"]));

                ddlPMSchedules.DataSource = dsPMSchedServices;
                ddlPMSchedules.DataMember = "Table";
                ddlPMSchedules.DataBind();

                ddlPMServices.DataSource = dsPMSchedServices;
                ddlPMServices.DataMember = "Table1";
                ddlPMServices.DataBind();

                ListLink.Enabled = true;
                ListLink.DataBind();
            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
            finally
            {
                if(pmsched != null)
                    pmsched.Dispose();
            }
        }
 private void btnDelete_Click(object sender, System.EventArgs e)
 {
     try
     {
         pmitem = new clsPMSchedService();
         pmitem.cAction = "D";
         pmitem.iOrgId = OrgId;
         pmitem.iPMSchedDetailId = DetailId;
         switch(pmitem.PMSchedServiceDetails())
         {
             case -1:
                 Header.ErrorMessage = _functions.ErrorMessage(174);
                 return;
             case -2:
                 Header.ErrorMessage = _functions.ErrorMessage(175);
                 return;
         }
         Response.Redirect(sLastPage, false);
     }
     catch(Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"] = sCurrentPage;
         Session["error"] = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if(pmitem != null)
             pmitem.Dispose();
     }
 }
 /// <summary>
 /// Update the PM Schedule Detail info
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btSave_FormSubmit(object sender, EventArgs e)
 {
     try
     {
         pmitem = new clsPMSchedService();
         pmitem.cAction = "U";
         pmitem.iOrgId = OrgId;
         pmitem.iPMSchedDetailId = DetailId;
         pmitem.iPMSchedId = PMSchedId;
         pmitem.iPMServiceId = Convert.ToInt32(ddlPMServices.SelectedValue);
         pmitem.iUnitMeasureId = Convert.ToInt32(ddlMeasures.SelectedValue);
         pmitem.iDays = tbDays.Text.Length>0?Convert.ToInt32(tbDays.Text):SqlInt32.Null;
         pmitem.dmUnits = tbUnits.Text.Length>0?Convert.ToDecimal(tbUnits.Text):SqlDecimal.Null;
         if(pmitem.PMSchedServiceDetails() == -1)
         {
             Header.ErrorMessage = _functions.ErrorMessage(174);
             return;
         }
         Response.Redirect(sLastPage, false);
     }
     catch(FormatException fex)
     {
         Header.ErrorMessage = _functions.ErrorMessage(108);
     }
     catch(Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"] = sCurrentPage;
         Session["error"] = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if(pmitem != null)
             pmitem.Dispose();
     }
 }
 private void btnAddPMItem_Click(object sender, System.EventArgs e)
 {
     try
     {
         pmitems = new clsPMSchedService();
         pmitems.cAction = "U";
         pmitems.iOrgId = OrgId;
         pmitems.iPMServiceId = 0;
         pmitems.iRepairCatId = Convert.ToInt32(ddlCategory.SelectedValue);
         pmitems.sPMServiceName = tbItemName.Text;
         pmitems.PMServiceDetails();
         dgPMItems.DataSource = pmitems.GetPMServicesList();
         dgPMItems.DataBind();
         tbItemName.Text= "";
     }
     catch(Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"] = "admin_pmitems.aspx";
         Session["error"] = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if(pmitems != null)
             pmitems.Dispose();
     }
 }