コード例 #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            ms_insurance ms_insurance = db.ms_insurance.Find(id);

            db.ms_insurance.Remove(ms_insurance);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #2
0
 public ActionResult Edit([Bind(Include = "insurance_id,insurance_code,insurance_name,insurance_address,country_id,insurance_phone,insurance_mail,insurance_cp_name,insurance_cp_phone,insurance_cp_mail,insurance_description,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_insurance ms_insurance)
 {
     if (ModelState.IsValid)
     {
         db.Entry(ms_insurance).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.country_id = new SelectList(db.ms_country, "country_id", "country_code", ms_insurance.country_id);
     return(View(ms_insurance));
 }
コード例 #3
0
        // GET: insurance/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ms_insurance ms_insurance = db.ms_insurance.Find(id);

            if (ms_insurance == null)
            {
                return(HttpNotFound());
            }
            return(View(ms_insurance));
        }
コード例 #4
0
        // GET: insurance/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ms_insurance ms_insurance = db.ms_insurance.Find(id);

            if (ms_insurance == null)
            {
                return(HttpNotFound());
            }
            ViewBag.country_id = new SelectList(db.ms_country, "country_id", "country_code", ms_insurance.country_id);
            return(View(ms_insurance));
        }
コード例 #5
0
        public ActionResult SaveData(string NewName)
        {
            int idC;

            int.TryParse(Request.Form["insuranceID"], out idC);

            ms_insurance ms_insurance = new ms_insurance();

            ms_insurance.insurance_id          = idC;
            ms_insurance.insurance_code        = Request.Form["insuranceCode"];
            ms_insurance.insurance_name        = Request.Form["insuranceName"];
            ms_insurance.insurance_address     = Request.Form["insuranceAddress"];
            ms_insurance.country_id            = Convert.ToInt32(Request.Form["Country"]);
            ms_insurance.insurance_phone       = Request.Form["insurancePhone"];
            ms_insurance.insurance_mail        = Request.Form["insuranceMail"];
            ms_insurance.insurance_cp_name     = Request.Form["insuranceCPName"];
            ms_insurance.insurance_cp_phone    = Request.Form["insuranceCPPhone"];
            ms_insurance.insurance_cp_mail     = Request.Form["insuranceCPMail"];
            ms_insurance.insurance_description = Request.Form["insuranceDescription"];
            ms_insurance.fl_active             = Request.Form["rec_isactive"] == "Yes" ? true : false;
            ms_insurance.deleted_by            = null;
            ms_insurance.deleted_date          = null;

            if (idC == 0)
            {
                ms_insurance.created_by      = UserProfile.UserId;
                ms_insurance.created_date    = DateTime.Now;
                ms_insurance.org_id          = UserProfile.OrgId;
                db.Entry(ms_insurance).State = EntityState.Added;
                db.SaveChanges();
                return(Json("Insert", JsonRequestBehavior.AllowGet));
            }
            else
            {
                ms_insurance.updated_by      = UserProfile.UserId;
                ms_insurance.updated_date    = DateTime.Now;
                db.Entry(ms_insurance).State = EntityState.Modified;
                db.SaveChanges();
                return(Json("Update", JsonRequestBehavior.AllowGet));
            }
        }
コード例 #6
0
 public JsonResult CrudInsurance()
 {
     if (Request.Form["oper"] == "add")
     {
         //prepare for insert data
         ms_insurance ms_insurance = new ms_insurance();
         ms_insurance.insurance_code        = Request.Form["insurance_code"];
         ms_insurance.insurance_name        = Request.Form["insurance_name"];
         ms_insurance.insurance_address     = Request.Form["insurance_address"];
         ms_insurance.country_id            = Convert.ToInt32(Request.Form["country_id"]);
         ms_insurance.insurance_phone       = Request.Form["insurance_phone"];
         ms_insurance.insurance_mail        = Request.Form["insurance_mail"];
         ms_insurance.insurance_cp_name     = Request.Form["insurance_cp_name"];
         ms_insurance.insurance_cp_phone    = Request.Form["insurance_cp_phone"];
         ms_insurance.insurance_cp_mail     = Request.Form["insurance_cp_mail"];
         ms_insurance.insurance_description = Request.Form["insurance_description"];
         ms_insurance.created_by            = 1;
         ms_insurance.fl_active             = Request.Form["rec_isactive"] == "Yes" ? true : false;
         ms_insurance.created_date          = DateTime.Now;
         ms_insurance.updated_by            = 1;
         ms_insurance.updated_date          = DateTime.Now;
         ms_insurance.org_id = 0;
         db.ms_insurance.Add(ms_insurance);
         db.SaveChanges();
         return(Json("Insert Insurance Data Success!", JsonRequestBehavior.AllowGet));
     }
     else if (Request.Form["oper"] == "edit")
     {
         if (IsNumeric(Request.Form["insurance_id"].ToString()))
         {
             //prepare for update data
             int          id           = Convert.ToInt32(Request.Form["insurance_id"]);
             ms_insurance ms_insurance = db.ms_insurance.Find(id);
             ms_insurance.insurance_code        = Request.Form["insurance_code"];
             ms_insurance.insurance_name        = Request.Form["insurance_name"];
             ms_insurance.insurance_address     = Request.Form["insurance_address"];
             ms_insurance.country_id            = Convert.ToInt32(Request.Form["country_id"]);
             ms_insurance.insurance_phone       = Request.Form["insurance_phone"];
             ms_insurance.insurance_mail        = Request.Form["insurance_mail"];
             ms_insurance.insurance_cp_name     = Request.Form["insurance_cp_name"];
             ms_insurance.insurance_cp_phone    = Request.Form["insurance_cp_phone"];
             ms_insurance.insurance_cp_mail     = Request.Form["insurance_cp_mail"];
             ms_insurance.insurance_description = Request.Form["insurance_description"];
             ms_insurance.updated_by            = 1;
             ms_insurance.updated_date          = DateTime.Now;
             db.SaveChanges();
             return(Json("Update Insurance Data Success!", JsonRequestBehavior.AllowGet));
         }
         else
         {
             //prepare for insert data
             ms_insurance ms_insurance = new ms_insurance();
             ms_insurance.insurance_code        = Request.Form["insurance_code"];
             ms_insurance.insurance_name        = Request.Form["insurance_name"];
             ms_insurance.insurance_address     = Request.Form["insurance_address"];
             ms_insurance.country_id            = Convert.ToInt32(Request.Form["country_id"]);
             ms_insurance.insurance_phone       = Request.Form["insurance_phone"];
             ms_insurance.insurance_mail        = Request.Form["insurance_mail"];
             ms_insurance.insurance_cp_name     = Request.Form["insurance_cp_name"];
             ms_insurance.insurance_cp_phone    = Request.Form["insurance_cp_phone"];
             ms_insurance.insurance_cp_mail     = Request.Form["insurance_cp_mail"];
             ms_insurance.insurance_description = Request.Form["insurance_description"];
             ms_insurance.created_by            = 1;
             ms_insurance.fl_active             = Request.Form["rec_isactive"] == "Yes" ? true : false;
             ms_insurance.created_date          = DateTime.Now;
             ms_insurance.updated_by            = 1;
             ms_insurance.updated_date          = DateTime.Now;
             ms_insurance.org_id = 0;
             db.ms_insurance.Add(ms_insurance);
             db.SaveChanges();
             return(Json("Insert Insurance Data Success!", JsonRequestBehavior.AllowGet));
         }
     }
     else
     {
         if (Request.Form["oper"] == "del")
         {
             //for delete process
             string   ids    = Request.Form["id"];
             string[] values = ids.Split(',');
             for (int i = 0; i < values.Length; i++)
             {
                 values[i] = values[i].Trim();
                 //prepare for soft delete data
                 int          id  = Convert.ToInt32(values[i]);
                 ms_insurance cou = db.ms_insurance.Find(id);
                 cou.deleted_by   = 1;
                 cou.deleted_date = DateTime.Now;
                 db.SaveChanges();
             }
         }
         return(Json("Deleted Success!"));
     }
 }