Beispiel #1
0
        //Add new Banner
        public static int AddRecord(etblBannerM eobj)
        {
            int retval = 0;

            using (OneFineRateEntities db = new OneFineRateEntities())
            {
                try
                {
                    bool chkPageBottom = false;
                    bool chkExists     = db.tblBannerMs.Any(
                        p => p.sBannerName == eobj.sBannerName
                        //&& p.sBannerType == eobj.sBannerType
                        && p.cstatus == eobj.cstatus
                        );
                    if (eobj.sBannerType == "Page Bottom")
                    {
                        chkPageBottom = db.tblBannerMs.Any(
                            p => p.sBannerType == eobj.sBannerType
                            );
                    }

                    if (chkExists != true)
                    {
                        if (chkPageBottom != true)
                        {
                            OneFineRate.tblBannerM dbuser = (OneFineRate.tblBannerM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBannerM());
                            db.tblBannerMs.Add(dbuser);
                            db.SaveChanges();
                            retval = 1;
                        }
                        else
                        {
                            retval = 3;
                        }
                    }
                    else
                    {
                        retval = 2;
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            }
            return(retval);
        }
Beispiel #2
0
        //Update new Banner
        public static int UpdateRecord(etblBannerM eobj)
        {
            int retval = 0;

            using (OneFineRateEntities db = new OneFineRateEntities())
            {
                try
                {
                    OneFineRate.tblBannerM obj = (OneFineRate.tblBannerM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBannerM());
                    db.tblBannerMs.Attach(obj);
                    db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();
                    retval = 1;
                }
                catch (Exception)
                {
                    throw;
                }
            }
            return(retval);
        }