public HttpResponseMessage Delete()
        {
            bal = new M_CustomerTypeBAL();
            ResposeType         response   = new ResposeType();
            HttpResponseMessage mapMessage = null;

            M_CustomerTypeDTO dto = null;

            response.statusCode = false;
            try
            {
                var context = HttpContext.Current;

                dto = ConvertX.GetReqeustForm <M_CustomerTypeDTO>();

                logger.debug("Delete dto:" + dto.ToString());
                response.statusCode = bal.Delete(dto);
            }
            catch (Exception ex)
            {
                logger.error("Delete error:" + ex.ToString());
                response.statusText = ex.ToString();
            }

            mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
            return(mapMessage);
        }
        public HttpResponseMessage LoadList()
        {
            bal = new M_CustomerTypeBAL();
            ResposeType              response   = new ResposeType();
            HttpResponseMessage      mapMessage = null;
            List <M_CustomerTypeDTO> dataList   = new List <M_CustomerTypeDTO>();

            M_CustomerTypeDTO dto = null;

            response.statusCode = false;
            try
            {
                var context = HttpContext.Current;

                dto = ConvertX.GetReqeustForm <M_CustomerTypeDTO>();

                logger.debug("Search dto:" + dto.ToString());
                dataList            = bal.FindByObjList(dto);
                response.statusCode = true;
                response.data       = dataList;
            }
            catch (Exception ex)
            {
                logger.error("Search error:" + ex.ToString());
                response.statusText = ex.ToString();
            }

            mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
            return(mapMessage);
        }
        public HttpResponseMessage Add()
        {
            bal = new M_CustomerTypeBAL();
            ResposeType         response   = new ResposeType();
            HttpResponseMessage mapMessage = null;

            M_CustomerTypeDTO dto = null;

            response.statusCode = false;
            try
            {
                var context = HttpContext.Current;

                dto = ConvertX.GetReqeustForm <M_CustomerTypeDTO>();
                string UserID = context.Request.Form["UserID"];
                if (ObjUtil.isEmpty(UserID))
                {
                    throw new Exception("UserID is require");
                }
                dto.CreateBy = UserID;
                dto.UpdateBy = UserID;

                logger.debug("Add dto:" + dto.ToString());
                response.statusCode = bal.Add(dto);
            }
            catch (Exception ex)
            {
                logger.error("Add error:" + ex.ToString());
                response.statusText = ex.ToString();
            }

            mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
            return(mapMessage);
        }
Example #4
0
        public List <M_CustomerTypeDTO> FindByObjList(object data)
        {
            List <SqlParameter> parameterList = new List <SqlParameter>();

            objList   = new List <M_CustomerTypeDTO>();
            dataTable = null;

            string procName = "sp_M_CustomerType_FindByColumn";

            try
            {
                dataTable = new DataTable();
                adapter   = new SqlDataAdapter();
                SqlConnection conn = OpenConnection();
                if (data != null)
                {
                    parameterList.AddRange(GetParameters(procName, data).ToArray());
                }
                command             = new SqlCommand(procName, conn);
                command.CommandType = CommandType.StoredProcedure;
                if (data != null)
                {
                    command.Parameters.AddRange(parameterList.ToArray());
                }



                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        obj = new M_CustomerTypeDTO();
                        obj.CustomerTypeID   = reader["CustomerTypeID"].ToString();
                        obj.CustomerTypeCode = reader["CustomerTypeCode"].ToString();
                        obj.Name             = reader["Name"].ToString();
                        obj.Status           = reader["Status"].ToString();
                        obj.CreateDate       = reader["CreateDate"].ToString();
                        obj.CreateBy         = reader["CreateBy"].ToString();
                        obj.UpdateDate       = reader["UpdateDate"].ToString();
                        obj.UpdateBy         = reader["UpdateBy"].ToString();
                        objList.Add(obj);
                    }
                }
            }
            catch (Exception ex) { }
            finally
            {
                CloseConnection();
            }
            return(objList);
        }