/// <summary>
        /// This Method is used for Insert and Update of LeadGeneator Master
        /// </summary>
        /// <param name="objEn"></param>
        /// <param name="OpType"></param>
        /// <returns></returns>
        public string InsertUpdate(LeadGenerator objEn, Int32 OpType)
        {
            string    msg       = string.Empty;
            DbCommand DbCommand = default(DbCommand);

            try
            {
                Database ds = default(Database);

                ds = DatabaseFactory.CreateDatabase(cnstr);

                DbCommand = ds.GetStoredProcCommand("USP_tblMstLeadGenerator_InsertUpdate");

                ds.AddInParameter(DbCommand, "LeadGeneratorID", DbType.Guid, objEn.LeadGeneratorID);
                ds.AddInParameter(DbCommand, "LeadGeneratorName", DbType.String, objEn.LeadGeneratorName);
                ds.AddInParameter(DbCommand, "ContactNo1", DbType.String, objEn.ContactNo1);
                ds.AddInParameter(DbCommand, "ContactNo2", DbType.String, objEn.ContactNo2);
                ds.AddInParameter(DbCommand, "EmailID", DbType.String, objEn.EmailID);
                //ds.AddInParameter(DbCommand, "Share", DbType.Decimal, objEn.Share);
                ds.AddInParameter(DbCommand, "EntBy", DbType.Guid, new Guid(userid));
                ds.AddInParameter(DbCommand, "Change", DbType.Int32, OpType);
                msg = ds.ExecuteNonQuery(DbCommand).ToString();
                DbCommand.Parameters.Clear();
                msg = "success";
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DbCommand.Dispose();
            }
            return(msg);
        }
        /// <summary>
        /// This Method is used to Retrive all the entries of LeadGenerator
        /// </summary>
        /// <returns></returns>
        public IEnumerable <LeadGenerator> GetAll()
        {
            List <LeadGenerator> enobjlst  = new List <LeadGenerator>();
            DbCommand            DbCommand = default(DbCommand);

            try
            {
                Database ds = DatabaseFactory.CreateDatabase(cnstr);
                DbCommand = ds.GetStoredProcCommand("USP_tblMstLeadGenerator_GetAll");

                using (IDataReader dataReader = ds.ExecuteReader(DbCommand))
                {
                    while (dataReader.Read())
                    {
                        LeadGenerator objen = new LeadGenerator();
                        DAL.EntityUtils.PopulateEntity(objen, dataReader);
                        enobjlst.Add(objen);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DbCommand.Dispose();
            }
            return(enobjlst);
        }
        /// <summary>
        /// This Method is used to get Single Entry of Lead Generator By LeadGeneratorID
        /// </summary>
        /// <param name="LGId"></param>
        /// <returns></returns>
        public LeadGenerator GetSingle(Guid LGId)
        {
            LeadGenerator entobj1   = new LeadGenerator();
            DbCommand     DbCommand = default(DbCommand);

            try
            {
                Database ds = DatabaseFactory.CreateDatabase(cnstr);
                DbCommand = ds.GetStoredProcCommand("USP_tblMstLeadGenerator_GetByID");
                ds.AddInParameter(DbCommand, "LeadGeneratorID", DbType.Guid, LGId);
                IDataReader reader = (ds.ExecuteReader(DbCommand));
                DbCommand.Parameters.Clear();

                if (reader.Read())
                {
                    DAL.EntityUtils.PopulateEntity(entobj1, reader);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DbCommand.Dispose();
            }
            return(entobj1);
        }