public void DeleteTariff(DTariffModel Tariff)
        {
            d_tariff dtd = GetTariffById(Tariff.Id);

            beEbergyContext.d_tariffs.DeleteOnSubmit(dtd);

            Commit();
        }
        public JsonResult TariffAjaxHandler(DTariffModel data)
        {
            DTariffModel result = null;

            if(Request.Params.Get("action") == "create")
            {
                result = da.InsertTariff(data);
            }
            else if(Request.Params.Get("action") == "edit")
            {
                result = da.UpdateTariff(data);
            }
            else if(Request.Params.Get("action") == "remove")
            {
                da.DeleteTariff(data);
                result = data;
            }

            return Json(new
            {
                data = result
            }, JsonRequestBehavior.AllowGet);
        }
        public DTariffModel UpdateTariff(DTariffModel Tariff)
        {
            d_tariff dtd = GetTariffById(Tariff.Id);

            dtd.code = Tariff.code;
            dtd.name = Tariff.name;
            dtd.tariff_1 = Tariff.tariff_1;
            dtd.tariff_2 = Tariff.tariff_2;
            dtd.tariff_3 = Tariff.tariff_3;
            dtd.tariff_4 = Tariff.tariff_4;

            Commit();

            return Tariff;
        }
        public DTariffModel InsertTariff(DTariffModel Tariff)
        {
            d_tariff dt = new d_tariff();

            dt.code = Tariff.code;
            dt.name = Tariff.name;
            dt.tariff_1 = Tariff.tariff_1;
            dt.tariff_2 = Tariff.tariff_2;
            dt.tariff_3 = Tariff.tariff_3;
            dt.tariff_4 = Tariff.tariff_4;

            beEbergyContext.d_tariffs.InsertOnSubmit(dt);
            Commit();

            Tariff.Id = dt.Id;

            return Tariff;
        }