public ActionResult Edit(Reconciliation Reconciliation)
        {
            Reconciliation oReconciliation = new Reconciliation();

            oReconciliation.ReconciliationID = System.Convert.ToInt32(Reconciliation.ReconciliationID);
            oReconciliation = ReconciliationData.Select_Record(Reconciliation);

            if (ModelState.IsValid)
            {
                bool bSucess = false;
                bSucess = ReconciliationData.Update(oReconciliation, Reconciliation);
                if (bSucess == true)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError("", "Can Not Update");
                }
            }
            // ComboBox
            ViewData["InvoiceID"] = new SelectList(Reconciliation_InvoiceData.List(), "InvoiceID", "InvoiceNo", Reconciliation.InvoiceID);

            return(View(Reconciliation));
        }
        // GET: /Reconciliation/Delete/<id>
        public ActionResult Delete(
            Int32?ReconciliationID
            )
        {
            if (
                ReconciliationID == null
                )
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            dtInvoice = Reconciliation_InvoiceData.SelectAll();

            Reconciliation Reconciliation = new Reconciliation();

            Reconciliation.ReconciliationID = System.Convert.ToInt32(ReconciliationID);
            Reconciliation         = ReconciliationData.Select_Record(Reconciliation);
            Reconciliation.Invoice = new Invoice()
            {
                InvoiceID   = (Int32)Reconciliation.InvoiceID
                , InvoiceNo = (from DataRow rowInvoice in dtInvoice.Rows
                               where Reconciliation.InvoiceID == (int)rowInvoice["InvoiceID"]
                               select(String) rowInvoice["InvoiceNo"]).FirstOrDefault()
            };

            if (Reconciliation == null)
            {
                return(HttpNotFound());
            }
            return(View(Reconciliation));
        }
        // GET: /Reconciliation/Edit/<id>
        public ActionResult Edit(
            Int32?ReconciliationID
            )
        {
            if (
                ReconciliationID == null
                )
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Reconciliation Reconciliation = new Reconciliation();

            Reconciliation.ReconciliationID = System.Convert.ToInt32(ReconciliationID);
            Reconciliation = ReconciliationData.Select_Record(Reconciliation);

            if (Reconciliation == null)
            {
                return(HttpNotFound());
            }
            // ComboBox
            ViewData["InvoiceID"] = new SelectList(Reconciliation_InvoiceData.List(), "InvoiceID", "InvoiceNo", Reconciliation.InvoiceID);

            return(View(Reconciliation));
        }
        public ActionResult DeleteConfirmed(
            Int32?ReconciliationID
            )
        {
            Reconciliation Reconciliation = new Reconciliation();

            Reconciliation.ReconciliationID = System.Convert.ToInt32(ReconciliationID);
            Reconciliation = ReconciliationData.Select_Record(Reconciliation);

            bool bSucess = false;

            bSucess = ReconciliationData.Delete(Reconciliation);
            if (bSucess == true)
            {
                return(RedirectToAction("Index"));
            }
            else
            {
                ModelState.AddModelError("", "Can Not Delete");
            }
            return(null);
        }