public List <POCO.AccountsWithCentersCostsTable> M_AccountsWithCentersCostsTable_Get()
        {
            DataSet ds = new DataSet();

            POCO.AccountsWithCentersCostsTable        oAccountsWithCentersCostsTable  = new POCO.AccountsWithCentersCostsTable();
            List <POCO.AccountsWithCentersCostsTable> oLAccountsWithCentersCostsTable = new List <POCO.AccountsWithCentersCostsTable>();

            ds = oAccountsWithCentersCostsTableDAL.M_AccountsWithCentersCostsTable_Get();
            if (ds.Tables.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    oAccountsWithCentersCostsTable                  = new POCO.AccountsWithCentersCostsTable();
                    oAccountsWithCentersCostsTable.ID               = Int64.Parse(ds.Tables[0].Rows[i]["ID"].ToString());
                    oAccountsWithCentersCostsTable.AccountName      = ds.Tables[0].Rows[i]["AccountName"].ToString();
                    oAccountsWithCentersCostsTable.CentersCostsName = ds.Tables[0].Rows[i]["CentersCostsName"].ToString();
                    oAccountsWithCentersCostsTable.AccountNo        = Int64.Parse(ds.Tables[0].Rows[i]["AccountNo"].ToString());
                    oAccountsWithCentersCostsTable.CentersCostsNo   = Int64.Parse(ds.Tables[0].Rows[i]["CentersCostsNo"].ToString());

                    oLAccountsWithCentersCostsTable.Add(oAccountsWithCentersCostsTable);
                }
            }


            return(oLAccountsWithCentersCostsTable);
        }
Beispiel #2
0
        public ActionResult Edit(Int64 ParID, POCO.AccountsWithCentersCostsTable PoAccountsWithCentersCostsTable)
        {
            AccountsWithCentersCostsTableDBL oAccountsWithCentersCostsTableDBL = new AccountsWithCentersCostsTableDBL();

            PoAccountsWithCentersCostsTable.ID = ParID;
            oAccountsWithCentersCostsTableDBL.M_AccountsWithCentersCostsTable_Update(ParID, PoAccountsWithCentersCostsTable.AccountNo, PoAccountsWithCentersCostsTable.CentersCostsNo);
            return(RedirectToAction("Index"));
        }
Beispiel #3
0
        public ActionResult DeleteConfirmed(Int64 ParAccountNo, Int64 ParCentersCostsNo)
        {
            AccountsWithCentersCostsTableDBL oAccountsWithCentersCostsTableDBL = new AccountsWithCentersCostsTableDBL();

            POCO.AccountsWithCentersCostsTable oAccountsWithCentersCostsTable = oAccountsWithCentersCostsTableDBL.M_AccountsWithCentersCostsTable_Delete(ParAccountNo, ParCentersCostsNo);

            return(RedirectToAction("Index"));
        }
Beispiel #4
0
        public ActionResult Create(POCO.AccountsWithCentersCostsTable oAccountsWithCentersCostsTable)
        {
            if (ModelState.IsValid)
            {
                AccountsWithCentersCostsTableDBL oAccountsWithCentersCostsTableDBL = new AccountsWithCentersCostsTableDBL();
                oAccountsWithCentersCostsTableDBL.M_AccountsWithCentersCostsTable_Insert(oAccountsWithCentersCostsTable);

                return(RedirectToAction("Index"));
            }
            return(View(oAccountsWithCentersCostsTable));
        }
Beispiel #5
0
        // GET: AccountsWithCentersCostsTable/Delete/5
        public ActionResult Delete(Int64 ParAccountNo, Int64 ParCentersCostsNo)
        {
            AccountsWithCentersCostsTableDBL oAccountsWithCentersCostsTableDBL = new AccountsWithCentersCostsTableDBL();

            POCO.AccountsWithCentersCostsTable oAccountsWithCentersCostsTable = oAccountsWithCentersCostsTableDBL.M_AccountsWithCentersCostsTable_Find(ParAccountNo, ParCentersCostsNo);
            if (oAccountsWithCentersCostsTable == null)
            {
                return(HttpNotFound());
            }


            return(View(oAccountsWithCentersCostsTable));
        }
        public POCO.AccountsWithCentersCostsTable M_AccountsWithCentersCostsTable_Update(Int64 ID, Int64 AccountNo, Int64 CentersCostsNo)
        {
            DataSet ds = new DataSet();

            POCO.AccountsWithCentersCostsTable oAccountsWithCentersCostsTable = new POCO.AccountsWithCentersCostsTable();
            ds = oAccountsWithCentersCostsTableDAL.M_AccountsWithCentersCostsTable_Update(ID, AccountNo, CentersCostsNo);
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    oAccountsWithCentersCostsTable.AccountNo      = Int64.Parse(ds.Tables[0].Rows[0]["AccountNo"].ToString());
                    oAccountsWithCentersCostsTable.CentersCostsNo = Int64.Parse(ds.Tables[0].Rows[0]["CentersCostsNo"].ToString());
                }
            }
            return(oAccountsWithCentersCostsTable);
        }