public MarketSourceModel GetMarketSourceData(int Id)
        {
            ShomaRMEntities   db    = new ShomaRMEntities();
            MarketSourceModel model = new MarketSourceModel();

            var GetMarketSourceData = db.tbl_Advertiser.Where(p => p.AdID == Id).FirstOrDefault();

            if (GetMarketSourceData != null)
            {
                model.AdID       = GetMarketSourceData.AdID;
                model.Advertiser = GetMarketSourceData.Advertiser;
            }
            model.AdID = Id;
            return(model);
        }
        public MarketSourceModel GetMarketSourceInfo(int ID = 0)
        {
            ShomaRMEntities   db    = new ShomaRMEntities();
            MarketSourceModel model = new MarketSourceModel();

            model.AdID       = 0;
            model.Advertiser = "";

            var MarketSourceInfo = db.tbl_Advertiser.Where(p => p.AdID == AdID).FirstOrDefault();

            if (MarketSourceInfo != null)
            {
                model.AdID       = MarketSourceInfo.AdID;
                model.Advertiser = MarketSourceInfo.Advertiser;
            }

            return(model);
        }
        public List <MarketSourceModel> GetMarketSourceList()
        {
            ShomaRMEntities          db    = new ShomaRMEntities();
            List <MarketSourceModel> model = new List <MarketSourceModel>();

            try
            {
                DataTable dtTable = new DataTable();
                using (var cmd = db.Database.Connection.CreateCommand())
                {
                    db.Database.Connection.Open();
                    cmd.CommandText = "usp_Get_Advertiser";
                    cmd.CommandType = CommandType.StoredProcedure;

                    //DbParameter paramC = cmd.CreateParameter();
                    //paramC.ParameterName = "Criteria";
                    //paramC.Value = MarketSourceName;
                    //cmd.Parameters.Add(paramC);

                    DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
                    da.SelectCommand = cmd;
                    da.Fill(dtTable);
                    db.Database.Connection.Close();
                }
                foreach (DataRow dr in dtTable.Rows)
                {
                    MarketSourceModel usm = new MarketSourceModel();
                    usm.AdID       = int.Parse(dr["AdID"].ToString());
                    usm.Advertiser = dr["Advertiser"].ToString();
                    model.Add(usm);
                }
                db.Dispose();
                return(model.ToList());
            }
            catch (Exception ex)
            {
                db.Database.Connection.Close();
                throw ex;
            }
        }
        public long SaveUpdateMarketSource(MarketSourceModel model)
        {
            ShomaRMEntities db             = new ShomaRMEntities();
            var             userNameExists = db.tbl_Advertiser.Where(p => p.AdID != model.AdID && p.Advertiser == model.Advertiser).FirstOrDefault();

            if (userNameExists == null)
            {
                if (model.AdID == 0)
                {
                    var MarketSourceData = new tbl_Advertiser()
                    {
                        Advertiser = model.Advertiser
                    };
                    db.tbl_Advertiser.Add(MarketSourceData);
                    db.SaveChanges();
                    model.AdID = MarketSourceData.AdID;
                }
                else
                {
                    var MarketSourceInfo = db.tbl_Advertiser.Where(p => p.AdID == model.AdID).FirstOrDefault();
                    if (MarketSourceInfo != null)
                    {
                        MarketSourceInfo.Advertiser = model.Advertiser;
                        db.SaveChanges();
                    }
                    else
                    {
                        throw new Exception(model.Advertiser + " not exists in the system.");
                    }
                }

                return(model.AdID);
            }
            else
            {
                throw new Exception(model.Advertiser + " already exists in the system.");
            }
        }