/// <summary>
 /// LoadLastBatch
 /// </summary>
 /// <param name="companyId">companyId</param>
 public void LoadLastBatch(int companyId)
 {
     MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway(Data);
     mrBatchVerificationGateway.LoadLastBatch(companyId);
 }
        protected void tkrdpRehabilitationSprayedDate_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
        {
            if (hdfExistBatchId.Value == "False")
            {
                if (tkrdpRehabilitationSprayedDate.SelectedDate.HasValue)
                {
                    int companyId = Int32.Parse(hdfCompanyId.Value);
                    MrBatchVerificationGateway mrBatchVerificationForLastBatch = new MrBatchVerificationGateway();
                    mrBatchVerificationForLastBatch.LoadLastBatch(companyId);

                    if (mrBatchVerificationForLastBatch.Table.Rows.Count > 0)
                    {
                        WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
                        ddlRehabilitationBatchDate.SelectedValue = workManholeRehabilitationBatchGateway.GetLastId(companyId).ToString();
                    }
                }
                else
                {
                    ddlRehabilitationBatchDate.SelectedValue = "0";
                }
            }
        }
        /// <summary>
        /// SaveMHRehabWork
        /// </summary>
        /// <param name="projectId">projectId</param>
        /// <param name="mh_assetId">mh_assetId</param>
        /// <param name="companyId">companyId</param>
        private void SaveMHRehabWork(int projectId, int mh_assetId, int companyId)
        {
            MrBatchVerificationGateway mrBatchVerificationForLastBatch = new MrBatchVerificationGateway();
            mrBatchVerificationForLastBatch.LoadLastBatch(companyId);
            int? batchId = null;

            if (mrBatchVerificationForLastBatch.Table.Rows.Count > 0)
            {
                WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
                batchId = workManholeRehabilitationBatchGateway.GetLastId(companyId);
            }

            WorkManholeRehabilitation workManholeRehabilitation = new WorkManholeRehabilitation(null);
            workManholeRehabilitation.InsertDirectEmptyWorks(projectId, mh_assetId, null, null, batchId, false, companyId);
        }
        protected void ddlRehabilitationBatchDate_SelectedIndexChanged(object sender, EventArgs e)
        {
            // Get last batch id
            int companyId = Int32.Parse(hdfCompanyId.Value);
            int lastBatchId = 0;
            MrBatchVerificationGateway mrBatchVerificationForLastBatch = new MrBatchVerificationGateway();
            mrBatchVerificationForLastBatch.LoadLastBatch(companyId);

            if (mrBatchVerificationForLastBatch.Table.Rows.Count > 0)
            {
                WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
                lastBatchId = workManholeRehabilitationBatchGateway.GetLastId(companyId);
            }

            lblNotLastBatch.Visible = false;
            if (ddlRehabilitationBatchDate.SelectedValue != lastBatchId.ToString())
            {
                lblNotLastBatch.Visible = true;
            }
        }