using SmartCoalApplication.Core.DbOpreate.DbIDal;
using SmartCoalApplication.Core.DbOpreate.DbModel;
using System;
using System.Collections.Generic;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SmartCoalApplication.Core.DbOpreate.DbCodeFirstDAL
{
    class mic_project_info_DAL : Imic_project_info
    {

        #region 基础功能

        /// <summary>
        /// 添加信息
        /// <param name="model">实体</param>
        /// </summary>
        /// <returns></returns>
        public bool Add(mic_project_info model)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                dbEntity.mic_project_info_market.Add(model);
                int recordsAffected;
                recordsAffected = dbEntity.SaveChanges();
                return recordsAffected > 0;
            }
        }

        /// <summary>
        /// 删除信息
        /// <param name="id">主键</param>
        /// </summary>
        /// <returns></returns>
        public bool Del(int id)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                var info = dbEntity.mic_project_info_market.SingleOrDefault(m => m.id == id);
                if (info != null)
                {
                    dbEntity.mic_project_info_market.Remove(info);
                    dbEntity.SaveChanges();
                }
                else
                {
                    return false;
                }
                return true;
            }
        }

        /// <summary>
        /// 获得信息
        /// <param name="id">主键</param>
        /// </summary>
        /// <returns></returns>
        public mic_project_info FindDefault(int id)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                return dbEntity.mic_project_info_market.Where(m => m.id == id).FirstOrDefault();
            }
        }

        /// <summary>
        /// 更新信息
        /// <param name="model">实体</param>
        /// </summary>
        /// <returns></returns>
        public bool Update(mic_project_info model)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                var info = dbEntity.mic_project_info_market.SingleOrDefault(m => m.id == model.id);

                info.id = model.id;//主键ID
                info.project_code = model.project_code;
                info.project_company = model.project_company;
                info.project_contact = model.project_contact;
                info.project_date = model.project_date;
                info.project_id = model.project_id;
                info.project_rating = model.project_rating;
                info.project_sender = model.project_sender;

                int recordsAffected;
                recordsAffected = dbEntity.SaveChanges();
                return recordsAffected > 0;
            }
        }

        /// <summary>
        /// 获得所有信息
        /// </summary>
        /// <returns></returns>
        public List<mic_project_info> FindAll()
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                return dbEntity.mic_project_info_market.OrderByDescending(m => m.id).ToList();
            }
        }

        #endregion 基础功能

        public mic_project_info FindByProjectCode(string code)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                return dbEntity.mic_project_info_market.Where(m => m.project_code.Equals(code)).FirstOrDefault();
            }
        }

        public mic_project_info FindByProjectCodeAndProjectId(string code, int projectId)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                return dbEntity.mic_project_info_market.Where(m => m.project_code.Equals(code) && m.project_id == projectId).FirstOrDefault();
            }
        }
        

        public List<mic_project_info> FindAllByKey(string mvalue)
        {
            using (DBEntities dbEntity = new DBEntities())
            {
                var sql = "SELECT * from mic_project_info where project_code like '%" + mvalue + "%' " +
                    "or project_company like '%" + mvalue + "%' " +
                    "or project_contact like '%" + mvalue + "%' " +
                    "or project_date like '%" + mvalue + "%' " +
                    "or project_rating like '%" + mvalue + "%' " +
                    "or project_sender like '%" + mvalue + "%' " +
                    "order by id desc";
                DbRawSqlQuery <mic_project_info> result1 = dbEntity.Database.SqlQuery<mic_project_info>(sql);
                return result1.ToList();
            }
        }
    }
}