Esempio n. 1
0
        public ActionResult Index()
        {
            var result = (from p in db.tblServiceCharges select p).ToList();
            List <ServiceChargesModel> list = new List <ServiceChargesModel>();

            foreach (var item in result)
            {
                ServiceChargesModel model = new ServiceChargesModel();
                model.ServiceId      = item.ServicId;
                model.ServicName     = item.ServiceName;
                model.ServiceCharges = item.Charges;
                list.Add(model);
            }
            return(View(list));
        }
Esempio n. 2
0
 public ActionResult Create(int id = 0)
 {
     if (id > 0)
     {
         var data = (from p in db.tblServiceCharges where p.ServicId == id select p).SingleOrDefault();
         ServiceChargesModel model = new ServiceChargesModel();
         model.ServiceId      = data.ServicId;
         model.ServicName     = data.ServiceName;
         model.ServiceCharges = data.Charges;
         return(View(model));
     }
     else
     {
         return(View());
     }
 }
Esempio n. 3
0
 public ActionResult Create(ServiceChargesModel model)
 {
     //var result = (from p in db.tblServiceCharges where p.ServiceName == "T" && p.ServiceName == "R" && p.ServiceName == "H" select p).SingleOrDefault();
     //if (result != null)
     //{
     //    try
     //    {
     //        tblServiceCharge tb = new tblServiceCharge();
     //        if (model.ServiceId > 0)
     //        {
     //            tb = (from p in db.tblServiceCharges where p.ServicId == model.ServiceId select p).SingleOrDefault();
     //        }
     //        tb.ServiceName = model.ServicName;
     //        tb.Charges = model.ServiceCharges;
     //        if (model.ServiceId > 0)
     //        {
     //            db.SaveChanges();
     //            TempData["servicecharg"] = "Record Edit Successfully..!";
     //            return RedirectToAction("Index", "ServicCharges");
     //        }
     //        else
     //        {
     //            db.tblServiceCharges.Add(tb);
     //            db.SaveChanges();
     //            TempData["servicecharg"] = "Record Insert Successfully..!";
     //            return RedirectToAction("Index", "ServicCharges");
     //        }
     //    }
     //    catch (Exception ex)
     //    {
     //        TempData["servicecharg"] = ex.Message;
     //        return RedirectToAction("Index", "ServicCharges");
     //    }
     //}
     //else
     //{
     //    TempData["servicCreate"] = "This Charges is already Exist..First Delete From Service Report..";
     //    return RedirectToAction("Create");
     //}
     try
     {
         tblServiceCharge tb = new tblServiceCharge();
         var result          = (from p in db.tblServiceCharges where p.ServiceName == model.ServicName select p).SingleOrDefault();
         if (result != null)
         {
             result.ServiceName = model.ServicName;
             result.Charges     = model.ServiceCharges;
             db.SaveChanges();
             TempData["servicecharg"] = "Record Edit Successfully..!";
             return(RedirectToAction("Index", "ServicCharges"));
         }
         else
         {
             tb.ServiceName = model.ServicName;
             tb.Charges     = model.ServiceCharges;
             db.tblServiceCharges.Add(tb);
             db.SaveChanges();
             TempData["servicecharg"] = "Record Insert Successfully..!";
             return(RedirectToAction("Index", "ServicCharges"));
         }
     }
     catch (Exception ex)
     {
         TempData["servicCreate"] = ex.Message;
         return(RedirectToAction("Create"));
     }
 }