Exemple #1
0
        public async Task <IHttpActionResult> Post(NhomQuyenViewModel.Dto instance)
        {
            var result         = new TransferObj <NHOMQUYEN>();
            var curentUnitCode = _service.GetCurrentUnitCode();

            if (instance.MANHOMQUYEN == "")
            {
                result.Status  = false;
                result.Message = "Mã không hợp lệ";
                return(Ok(result));
            }
            else
            {
                var exist = _service.Repository.DbSet.FirstOrDefault(x => x.MANHOMQUYEN == instance.MANHOMQUYEN && x.UNITCODE.Equals(curentUnitCode));
                if (exist != null)
                {
                    result.Status  = false;
                    result.Message = "Đã tồn tại mã khách hàng này";
                    return(Ok(result));
                }
            }
            try
            {
                instance.MANHOMQUYEN = _service.SaveCode();
                var data = Mapper.Map <NhomQuyenViewModel.Dto, NHOMQUYEN>(instance);
                var item = _service.Insert(data);
                int inst = await _service.UnitOfWork.SaveAsync();

                if (inst > 0)
                {
                    result.Status  = true;
                    result.Data    = item;
                    result.Message = "Thêm mới thành công";
                }
                else
                {
                    result.Status  = false;
                    result.Data    = null;
                    result.Message = "Thao tác không thành công";
                }
            }
            catch (Exception e)
            {
                result.Status  = false;
                result.Message = e.Message;
            }
            return(Ok(result));
        }
Exemple #2
0
        public IHttpActionResult GetNhomQuyenChuaCauHinh(string userName)
        {
            var result = new TransferObj <List <NhomQuyenViewModel.Dto> >();
            List <NhomQuyenViewModel.Dto> listNhomQuyen = new List <NhomQuyenViewModel.Dto>();

            if (!string.IsNullOrEmpty(userName))
            {
                try
                {
                    string stringConnect = ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString;
                    using (OracleConnection connection = new OracleConnection(stringConnect))
                    {
                        try
                        {
                            connection.Open();
                            if (connection.State == ConnectionState.Open)
                            {
                                OracleCommand command = new OracleCommand();
                                command.Connection  = connection;
                                command.CommandType = CommandType.Text;
                                command.CommandText = string.Format(@"SELECT
                                                                    a.ID,
                                                                    a.MANHOMQUYEN,
                                                                    a.TENNHOMQUYEN
                                                                FROM
                                                                    NHOMQUYEN a
                                                                WHERE a.MANHOMQUYEN NOT IN (
                                                                    SELECT
                                                                        b.MANHOMQUYEN
                                                                    FROM
                                                                        NGUOIDUNG_NHOMQUYEN b
                                                                    WHERE
                                                                        b.USERNAME = :USERNAME)
                                                                    ");
                                command.Parameters.Add(@"USERNAME", OracleDbType.NVarchar2, 50).Value = userName;
                                OracleDataReader dataReader = command.ExecuteReader();
                                if (dataReader.HasRows)
                                {
                                    while (dataReader.Read())
                                    {
                                        NhomQuyenViewModel.Dto row = new NhomQuyenViewModel.Dto();
                                        if (dataReader["ID"] != null)
                                        {
                                            row.ID = dataReader["ID"].ToString();
                                        }
                                        if (dataReader["MANHOMQUYEN"] != null)
                                        {
                                            row.MANHOMQUYEN = dataReader["MANHOMQUYEN"].ToString();
                                        }
                                        if (dataReader["TENNHOMQUYEN"] != null)
                                        {
                                            row.TENNHOMQUYEN = dataReader["TENNHOMQUYEN"].ToString();
                                        }
                                        listNhomQuyen.Add(row);
                                    }
                                }
                                dataReader.Close();
                            }
                        }
                        catch (Exception ex)
                        {
                        }
                        finally
                        {
                            connection.Close();
                            connection.Dispose();
                        }
                    }
                    if (listNhomQuyen.Count > 0)
                    {
                        result.Status  = true;
                        result.Data    = listNhomQuyen;
                        result.Message = "Thành công";
                    }
                    else
                    {
                        result.Status  = false;
                        result.Data    = null;
                        result.Message = "Không có dữ liệu";
                    }
                }
                catch (Exception ex)
                {
                    result.Status  = false;
                    result.Message = ex.Message;
                }
            }
            return(Ok(result));
        }