예제 #1
0
        //[ValidateAntiForgeryToken]
        public JsonResult DeleteItemAll(int id)
        {
            var _qry = (from aw in db.tr_asset_warranty
                        where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
                        select new asset_warrantyViewModel()
            {
                warranty_id = aw.warranty_id
            }).ToList <asset_warrantyViewModel>();

            if (_qry != null)
            {
                foreach (asset_warrantyViewModel ass_wrt in _qry)
                {
                    tr_asset_warranty tr_asset_warranty = db.tr_asset_warranty.Find(ass_wrt.warranty_id);
                    if (tr_asset_warranty != null)
                    {
                        tr_asset_warranty.fl_active    = false;
                        tr_asset_warranty.deleted_by   = UserProfile.UserId;
                        tr_asset_warranty.deleted_date = DateTime.Now;

                        db.Entry(tr_asset_warranty).State = EntityState.Modified;
                        db.SaveChanges();
                    }
                }
                return(Json(1, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json(0, JsonRequestBehavior.AllowGet));
            }
        }
예제 #2
0
        public ActionResult DeleteConfirmed(int id)
        {
            tr_asset_warranty tr_asset_warranty = db.tr_asset_warranty.Find(id);

            db.tr_asset_warranty.Remove(tr_asset_warranty);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #3
0
 public ActionResult Edit([Bind(Include = "warranty_id,asset_id,warranty_number,warranty_item_name,warranty_date,warranty_exp_date,warranty_description,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] tr_asset_warranty tr_asset_warranty)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tr_asset_warranty).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tr_asset_warranty));
 }
예제 #4
0
        public ActionResult Edit([Bind(Include = "warranty_id, asset_parent_id, warranty_number, warranty_item_name, warranty_date, warranty_exp_date, warranty_description")] asset_warrantyViewModel asset_wrt)
        {
            if (asset_wrt.warranty_date > DateTime.Today)
            {
                ModelState.AddModelError("warranty_date", "Please enter a valid date.");
            }

            if (asset_wrt.warranty_date > asset_wrt.warranty_exp_date)
            {
                ModelState.AddModelError("warranty_exp_date", "Warranty expired date must be after warranty date.");
            }

            if (ModelState.IsValid && asset_wrt.warranty_id > 0)
            {
                tr_asset_warranty ass_warranty = db.tr_asset_warranty.Find(asset_wrt.warranty_id);
                ass_warranty.warranty_number      = asset_wrt.warranty_number;
                ass_warranty.warranty_item_name   = asset_wrt.warranty_item_name;
                ass_warranty.warranty_date        = asset_wrt.warranty_date;
                ass_warranty.warranty_exp_date    = asset_wrt.warranty_exp_date;
                ass_warranty.warranty_description = asset_wrt.warranty_description;

                ass_warranty.fl_active    = true;
                ass_warranty.updated_date = DateTime.Now;
                ass_warranty.updated_by   = UserProfile.UserId;
                ass_warranty.deleted_date = null;
                ass_warranty.deleted_by   = null;
                ass_warranty.org_id       = UserProfile.OrgId;

                db.Entry(ass_warranty).State = EntityState.Modified;
                db.SaveChanges();

                return(RedirectToAction("Index"));
            }

            tr_asset_registration ass_reg = db.tr_asset_registration.Find(asset_wrt.asset_parent_id);

            asset_wrt.FormMode = EnumFormModeKey.Form_Edit;

            asset_wrt.asset_parent_id = (int)ass_reg.asset_id;
            asset_wrt.asset_parent    = ass_reg;

            ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);

            asset_wrt.vendor_name = msvendor.vendor_name;

            //Data view edit
            asset_wrt.asset_warranty_list = (from aw in db.tr_asset_warranty
                                             where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_wrt.asset_parent_id)
                                             select aw).ToList <tr_asset_warranty>();

            return(View(asset_wrt));
        }
예제 #5
0
        // GET: asset_warranty/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tr_asset_warranty tr_asset_warranty = db.tr_asset_warranty.Find(id);

            if (tr_asset_warranty == null)
            {
                return(HttpNotFound());
            }
            return(View(tr_asset_warranty));
        }
예제 #6
0
        // GET: asset_warranty/Edit/5
        public ActionResult Edit(int?id, int?idw)
        {
            if (id == null || idw == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            tr_asset_registration ass_reg = db.tr_asset_registration.Find(id);

            if (ass_reg == null)
            {
                return(HttpNotFound("Assset not found."));
            }

            asset_warrantyViewModel asset_model = new asset_warrantyViewModel()
            {
                FormMode = EnumFormModeKey.Form_Edit,

                asset_parent_id = (int)ass_reg.asset_id,
                asset_parent    = ass_reg
            };

            tr_asset_warranty ass_warranty = db.tr_asset_warranty.Find(idw);

            if (ass_warranty != null)
            {
                asset_model.warranty_id          = ass_warranty.warranty_id;
                asset_model.warranty_number      = ass_warranty.warranty_number;
                asset_model.warranty_item_name   = ass_warranty.warranty_item_name;
                asset_model.warranty_date        = ass_warranty.warranty_date;
                asset_model.warranty_exp_date    = ass_warranty.warranty_exp_date;
                asset_model.warranty_description = ass_warranty.warranty_description;
            }

            ms_vendor msvendor = db.ms_vendor.Find(ass_reg.vendor_id);

            asset_model.vendor_name = msvendor.vendor_name;

            //Data view edit
            asset_model.asset_warranty_list = (from aw in db.tr_asset_warranty
                                               where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == id)
                                               select aw).ToList <tr_asset_warranty>();

            return(View(asset_model));
        }
예제 #7
0
        //[ValidateAntiForgeryToken]
        public JsonResult DeleteItem(int id)
        {
            tr_asset_warranty tr_asset_warranty = db.tr_asset_warranty.Find(id);

            if (tr_asset_warranty != null)
            {
                tr_asset_warranty.fl_active       = false;
                tr_asset_warranty.deleted_by      = UserProfile.UserId;
                tr_asset_warranty.deleted_date    = DateTime.Now;
                db.Entry(tr_asset_warranty).State = EntityState.Modified;
                db.SaveChanges();

                return(Json(1, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json(0, JsonRequestBehavior.AllowGet));
            }
        }
예제 #8
0
        public ActionResult Create([Bind(Include = "asset_parent_id, warranty_number, warranty_item_name, warranty_date, warranty_exp_date, warranty_description")] asset_warrantyViewModel asset_wrt)
        {
            try
            {
                if (asset_wrt.warranty_date > DateTime.Today)
                {
                    ModelState.AddModelError("warranty_date", "Please enter a valid date.");
                }

                if (asset_wrt.warranty_date > asset_wrt.warranty_exp_date)
                {
                    ModelState.AddModelError("warranty_exp_date", "Warranty expired date must be after warranty date.");
                }

                tr_asset_warranty existWarranty = (from exw in db.tr_asset_warranty.Where(exw => exw.warranty_number == asset_wrt.warranty_number && exw.asset_id == asset_wrt.asset_parent_id) select exw).FirstOrDefault <tr_asset_warranty>();

                if (existWarranty == null)
                {
                    if (ModelState.IsValid)
                    {
                        tr_asset_warranty ass_warranty = new tr_asset_warranty();
                        ass_warranty.asset_id             = asset_wrt.asset_parent_id;
                        ass_warranty.warranty_number      = asset_wrt.warranty_number;
                        ass_warranty.warranty_item_name   = asset_wrt.warranty_item_name;
                        ass_warranty.warranty_date        = asset_wrt.warranty_date;
                        ass_warranty.warranty_exp_date    = asset_wrt.warranty_exp_date;
                        ass_warranty.warranty_description = asset_wrt.warranty_description;

                        ass_warranty.fl_active    = true;
                        ass_warranty.created_date = DateTime.Now;
                        ass_warranty.created_by   = UserProfile.UserId;
                        ass_warranty.updated_date = DateTime.Now;
                        ass_warranty.updated_by   = UserProfile.UserId;
                        ass_warranty.deleted_date = null;
                        ass_warranty.deleted_by   = null;
                        ass_warranty.org_id       = UserProfile.OrgId;

                        ass_warranty = db.tr_asset_warranty.Add(ass_warranty);
                        db.SaveChanges();

                        ModelState.Clear();
                        asset_wrt.warranty_number    = string.Empty;
                        asset_wrt.warranty_item_name = string.Empty;
                        asset_wrt.warranty_date      = null;
                        asset_wrt.warranty_exp_date  = null;
                    }
                }
                else
                {
                    //Data view
                    List <tr_asset_warranty> assetwrtlist = asset_wrt.asset_warranty_list = (from aw in db.tr_asset_warranty
                                                                                             where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_wrt.asset_parent_id)
                                                                                             select aw).ToList <tr_asset_warranty>();
                    ModelState.Clear();
                    asset_wrt = new asset_warrantyViewModel();
                    asset_wrt.asset_warranty_list = assetwrtlist;
                    return(View(asset_wrt));
                }
                //Data view
                asset_wrt.asset_warranty_list = (from aw in db.tr_asset_warranty
                                                 where (aw.fl_active == true && aw.deleted_date == null && aw.asset_id == asset_wrt.asset_parent_id)
                                                 select aw).ToList <tr_asset_warranty>();
            }
            catch (Exception ex)
            {
                string msgErr = string.Format("An unknown error has occurred , Please contact your system administrator. {0}", ex.Message);
                if (ex.InnerException != null)
                {
                    msgErr += string.Format(" Inner Exception: {0}", ex.InnerException.Message);
                }
                ModelState.AddModelError("", msgErr);
            }
            return(View(asset_wrt));
        }