Пример #1
0
        public ActionResult DeleteConfirmed(string id)
        {
            CSCOSH cSCOSH = db.CSCOSHes.Find(id);

            db.CSCOSHes.Remove(cSCOSH);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #2
0
        public ActionResult DeleteConfirmed(string id, string person)
        {
            CSCOSH cSCOSH = db.CSCOSHes.Find(MyHtmlHelpers.ConvertByteStrToId(id), person);

            try
            {
                db.CSCOSHes.Remove(cSCOSH);
                db.SaveChanges();
                return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSH.CONO) }) + "#Member"));
            }
            catch (DbEntityValidationException dbEx)
            {
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        //string message = string.Format("{0}:{1}",
                        //    validationErrors.Entry.Entity.ToString(),
                        //   validationError.ErrorMessage);
                        // raise a new exception nesting
                        // the current instance as InnerException
                        ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
                    }
                }
            }
            catch (DbUpdateException ex)
            {
                UpdateException updateException = (UpdateException)ex.InnerException;
                if (updateException != null)
                {
                    if (updateException.InnerException != null)
                    {
                        var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;

                        foreach (var error in sqlException.Errors)
                        {
                            if (error.Message != null)
                            {
                                ModelState.AddModelError(string.Empty, error.Message);
                            }
                        }
                    }
                    else
                    {
                        ModelState.AddModelError(string.Empty, updateException.Message);
                    }
                }
                else
                {
                    ModelState.AddModelError(string.Empty, updateException.Message);
                }
            }
            catch (Exception e)
            {
                ModelState.AddModelError(string.Empty, e.Message);
            }
            return(View(cSCOSH));
        }
Пример #3
0
 public ActionResult Edit([Bind(Include = "CONO,PRSCODE,EFFDATE,TERDATE,ENDDATE,FOLIONO,REM,STAMP")] CSCOSH cSCOSH)
 {
     if (ModelState.IsValid)
     {
         db.Entry(cSCOSH).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.PRSCODE = new SelectList(db.CSPRS, "PRSCODE", "CONSTCODE", cSCOSH.PRSCODE);
     return(View(cSCOSH));
 }
Пример #4
0
        // GET: CSCOSHes/Delete/5
        public ActionResult Delete(string id, string person)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CSCOSH cSCOSH = db.CSCOSHes.Find(MyHtmlHelpers.ConvertByteStrToId(id), person);

            if (cSCOSH == null)
            {
                return(HttpNotFound());
            }
            return(View(cSCOSH));
        }
Пример #5
0
        // GET: CSCOSHes/Create
        public ActionResult Create(string id)
        {
            ViewBag.Parent = MyHtmlHelpers.ConvertByteStrToId(id);
            string sid = ViewBag.Parent;

            CSCOSH curRec = new CSCOSH();

            curRec.CONO     = sid;
            curRec.EFFDATE  = DateTime.Today;
            curRec.ENDDATE  = new DateTime(3000, 1, 1);
            curRec.CSCOMSTR = db.CSCOMSTRs.Find(curRec.CONO);
            ViewBag.PRSCODE = new SelectList(db.CSPRS.OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", curRec.PRSCODE);
            return(View(curRec));
        }
Пример #6
0
        // GET: CSCOSHes/Details/5
        public ActionResult Details(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CSCOSH cSCOSH = db.CSCOSHes.Find(id);

            if (cSCOSH == null)
            {
                return(HttpNotFound());
            }
            return(View(cSCOSH));
        }
Пример #7
0
        // GET: CSCOSHes/Edit/5
        public ActionResult Edit(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CSCOSH cSCOSH = db.CSCOSHes.Find(id);

            if (cSCOSH == null)
            {
                return(HttpNotFound());
            }
            ViewBag.PRSCODE = new SelectList(db.CSPRS, "PRSCODE", "CONSTCODE", cSCOSH.PRSCODE);
            return(View(cSCOSH));
        }
Пример #8
0
        // GET: CSCOSHes/Details/5
        public ActionResult Details(string id, string person)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CSCOSH cSCOSH = db.CSCOSHes.Find(MyHtmlHelpers.ConvertByteStrToId(id), person);

            if (cSCOSH == null)
            {
                return(HttpNotFound());
            }
            ViewBag.PRSCODE = new SelectList(db.CSPRS.OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", cSCOSH.PRSCODE);

            return(View(cSCOSH));
        }
Пример #9
0
        public ActionResult Edit([Bind(Include = "CONO,PRSCODE,EFFDATE,TERDATE,ENDDATE,FOLIONO,REM,STAMP")] CSCOSH cSCOSH)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    bool   changed = false;
                    CSCOSH csOrig  = (CSCOSH)Session["CSCOSH_ORIG"];
                    if (csOrig.PRSCODE != cSCOSH.PRSCODE)
                    {
                        changed = true;
                    }

                    cSCOSH.STAMP = cSCOSH.STAMP + 1;
                    if (changed)
                    {
                        CSCOSH csDel = db.CSCOSHes.Find(csOrig.CONO, csOrig.PRSCODE);
                        db.CSCOSHes.Remove(csDel);
                        db.CSCOSHes.Add(cSCOSH);
                    }
                    else
                    {
                        db.Entry(cSCOSH).State = EntityState.Modified;
                    }

                    db.SaveChanges();
                    return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSH.CONO) }) + "#Member"));
                }
                catch (DbEntityValidationException dbEx)
                {
                    foreach (var validationErrors in dbEx.EntityValidationErrors)
                    {
                        foreach (var validationError in validationErrors.ValidationErrors)
                        {
                            //string message = string.Format("{0}:{1}",
                            //    validationErrors.Entry.Entity.ToString(),
                            //   validationError.ErrorMessage);
                            // raise a new exception nesting
                            // the current instance as InnerException
                            ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
                        }
                    }
                }
                catch (DbUpdateException ex)
                {
                    UpdateException updateException = (UpdateException)ex.InnerException;
                    if (updateException != null)
                    {
                        if (updateException.InnerException != null)
                        {
                            var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;

                            foreach (var error in sqlException.Errors)
                            {
                                if (error.Message != null)
                                {
                                    ModelState.AddModelError(string.Empty, error.Message);
                                }
                            }
                        }
                        else
                        {
                            ModelState.AddModelError(string.Empty, updateException.Message);
                        }
                    }
                    else
                    {
                        ModelState.AddModelError(string.Empty, updateException.Message);
                    }
                }
                catch (Exception e)
                {
                    ModelState.AddModelError(string.Empty, e.Message);
                }
            }
            cSCOSH.CSCOMSTR   = db.CSCOMSTRs.Find(cSCOSH.CONO);
            ViewBag.PRSCODE   = new SelectList(db.CSPRS.OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", cSCOSH.PRSCODE);
            cSCOSH.CSCOSHCHGs = db.CSCOSHCHGs.Where(x => x.CONO == cSCOSH.CONO && x.PRSCODE == cSCOSH.PRSCODE).ToList();
            return(View(cSCOSH));
        }
Пример #10
0
        public ActionResult Create([Bind(Include = "CONO,PRSCODE,EFFDATE,TERDATE,ENDDATE,FOLIONO,REM,STAMP")] CSCOSH cSCOSH)
        {
            if (ModelState.IsValid)
            {
                cSCOSH.STAMP = 0;
                try
                {
                    int lastRowNo = 0;
                    try
                    {
                        lastRowNo = db.CSCOSHes.Where(m => m.CONO == cSCOSH.CONO).Max(n => n.FOLIONO);
                    }
                    catch (Exception e) { lastRowNo = 0; }
                    finally { };

                    cSCOSH.FOLIONO = lastRowNo + 1;
                    db.CSCOSHes.Add(cSCOSH);

                    CSCOLASTNO cSCOLASTNO = db.CSCOLASTNOes.Find(cSCOSH.CONO, "SHFOLIO");
                    if (cSCOLASTNO != null)
                    {
                        cSCOLASTNO.LASTNO          = cSCOSH.FOLIONO;
                        db.Entry(cSCOLASTNO).State = EntityState.Modified;
                    }
                    db.SaveChanges();
                    return(new RedirectResult(Url.Action("Edit", "CSCOMSTRs", new { id = MyHtmlHelpers.ConvertIdToByteStr(cSCOSH.CONO) }) + "#Member"));
                }
                catch (DbEntityValidationException dbEx)
                {
                    foreach (var validationErrors in dbEx.EntityValidationErrors)
                    {
                        foreach (var validationError in validationErrors.ValidationErrors)
                        {
                            //string message = string.Format("{0}:{1}",
                            //    validationErrors.Entry.Entity.ToString(),
                            //   validationError.ErrorMessage);
                            // raise a new exception nesting
                            // the current instance as InnerException
                            ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
                        }
                    }
                }
                catch (DbUpdateException ex)
                {
                    UpdateException updateException = (UpdateException)ex.InnerException;
                    if (updateException != null)
                    {
                        if (updateException.InnerException != null)
                        {
                            var sqlException = (FirebirdSql.Data.FirebirdClient.FbException)updateException.InnerException;

                            foreach (var error in sqlException.Errors)
                            {
                                if (error.Message != null)
                                {
                                    ModelState.AddModelError(string.Empty, error.Message);
                                }
                            }
                        }
                        else
                        {
                            ModelState.AddModelError(string.Empty, updateException.Message);
                        }
                    }
                    else
                    {
                        ModelState.AddModelError(string.Empty, updateException.Message);
                    }
                }
                catch (Exception e)
                {
                    ModelState.AddModelError(string.Empty, e.Message);
                }
            }

            cSCOSH.CSCOMSTR = db.CSCOMSTRs.Find(cSCOSH.CONO);
            ViewBag.PRSCODE = new SelectList(db.CSPRS.OrderBy(x => x.PRSNAME), "PRSCODE", "PRSNAME", cSCOSH.PRSCODE);
            return(View(cSCOSH));
        }